1 | show columns from `products` | | 108 | 108 | 1 |
2 | SELECT `AddField`.`id`, `AddField`.`name` FROM `irisoweb_test`.`add_fields` AS `AddField` WHERE 1 = 1 ORDER BY `AddField`.`odr` ASC | | 48 | 48 | 1 |
3 | SELECT `Product`.`id`, `Product`.`status`, `Product`.`name`, `Product`.`y_name`, `Product`.`series_id`, `Product`.`type`, `Product`.`html`, `Product`.`html_en`, `Product`.`html_zh`, `Product`.`html_ko`, `Product`.`title`, `Product`.`title_en`, `Product`.`title_zh`, `Product`.`title_ko`, `Product`.`description`, `Product`.`description_en`, `Product`.`description_zh`, `Product`.`description_ko`, `Product`.`keyword_en`, `Product`.`keyword_zh`, `Product`.`keyword_ko`, `Product`.`file_title1`, `Product`.`file_title2`, `Product`.`file_title3`, `Product`.`file_title4`, `Product`.`file_title5`, `Product`.`file_title6`, `Product`.`file_title7`, `Product`.`file_title8`, `Product`.`file_role1`, `Product`.`file_role2`, `Product`.`file_role3`, `Product`.`file_role4`, `Product`.`file_role5`, `Product`.`file_role6`, `Product`.`file_role7`, `Product`.`file_role8`, `Product`.`file_count1`, `Product`.`file_count2`, `Product`.`file_count3`, `Product`.`file_count4`, `Product`.`file_count5`, `Product`.`file_count6`, `Product`.`file_count7`, `Product`.`file_count8`, `Product`.`alternative`, `Product`.`combination`, `Product`.`ambiguous`, `Product`.`buy_url1`, `Product`.`buy_url2`, `Product`.`buy_url3`, `Product`.`buy_url4`, `Product`.`buy_text1`, `Product`.`buy_text2`, `Product`.`buy_text3`, `Product`.`buy_text4`, `Product`.`odr`, `Product`.`created`, `Product`.`modified`, `Product`.`販売分類`, `Product`.`コネクタ形状`, `Product`.`嵌合方向`, `Product`.`基板実装部ピッチ`, `Product`.`接点部めっき`, `Product`.`めっき厚`, `Product`.`本体長さ(ピッチ方向)`, `Product`.`本体幅(奥行き)`, `Product`.`インピーダンス整合`, `Product`.`接触抵抗`, `Product`.`使用温度範囲(Min)`, `Product`.`RoHS2`, `Product`.`ハロゲンフリー`, `Product`.`2点接点`, `Product`.`位置決めボス`, `Product`.`グランド`, `Product`.`ワイドスライダー`, `Product`.`誘い込み用フランジ`, `Product`.`吸着用キャップ`, `Product`.`吸着用テープ`, `Product`.`可動量X`, `Product`.`可動量Y`, `Product`.`有効嵌合長Z`, `Product`.`振幅許容範囲`, `Product`.`挿抜回数`, `Product`.`ロック方式`, `Product`.`カード抜け防止機能`, `Product`.`梱包形態`, `Product`.`梱包数量`, `Product`.`基板実装方法`, `Product`.`嵌合形状`, `Product`.`実装形態`, `Product`.`接点方向`, `Product`.`嵌合部ピッチ`, `Product`.`極数`, `Product`.`伝送規格`, `Product`.`本体高さ`, `Product`.`定格電圧(AC)`, `Product`.`定格電圧(DC)`, `Product`.`定格電流`, `Product`.`耐電圧`, `Product`.`使用温度範囲(Max)`, `Product`.`抜け上寸法`, `Product`.`抜け下寸法`, `Product`.`配列`, `Product`.`フローティング機能`, `Product`.`伝送速度(代表参考値)`, `Product`.`共振振幅量`, (CONCAT(`Product`.`name`, " ", `Product`.`y_name`, " ", `Product`.`file_title1`, " ", `Product`.`file_title2`, " ", `Product`.`file_title3`, " ", `Product`.`file_title4`, " ", `Product`.`file_title5`, " ", `Product`.`file_title6`, " ", `Product`.`file_title7`, " ", `Product`.`file_title8`, " ", `Product`.`alternative`, " ", `Product`.`combination`, " ", `Product`.`ambiguous`, " ", `Series`.`detail`, " ", `Series`.`detail_en`, " ", `Series`.`detail_zh`, " ", `Series`.`detail_ko`, " ", `Series`.`html`, " ", `Series`.`html_en`, " ", `Series`.`html_zh`, " ", `Series`.`html_ko`)) AS `Product__keyword`, `Series`.`id`, `Series`.`name`, `Series`.`detail`, `Series`.`detail_en`, `Series`.`detail_zh`, `Series`.`detail_ko`, `Series`.`category_id` FROM `irisoweb_test`.`products` AS `Product` LEFT JOIN `irisoweb_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`販売分類` <> 'EOS' AND `Product`.`status` = '有効' AND `Series`.`status` = '有効' AND ((`Product`.`フローティング機能` = 'Yes') OR (`Product`.`ロック方式` = 'Auto I-Lock')) ORDER BY Product.極数 asc, Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 20 | | 20 | 20 | 12 |
4 | SELECT `Category`.`id`, `Category`.`url`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko` FROM `irisoweb_test`.`categories` AS `Category` WHERE `Category`.`id` = 1 | | 1 | 1 | 0 |
5 | SELECT `Category`.`id`, `Category`.`url`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko` FROM `irisoweb_test`.`categories` AS `Category` WHERE `Category`.`id` = 1 | | 1 | 1 | 0 |
6 | SELECT `Category`.`id`, `Category`.`url`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko` FROM `irisoweb_test`.`categories` AS `Category` WHERE `Category`.`id` = 1 | | 1 | 1 | 0 |
7 | SELECT `Category`.`id`, `Category`.`url`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko` FROM `irisoweb_test`.`categories` AS `Category` WHERE `Category`.`id` = 1 | | 1 | 1 | 0 |
8 | SELECT `Category`.`id`, `Category`.`url`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko` FROM `irisoweb_test`.`categories` AS `Category` WHERE `Category`.`id` = 1 | | 1 | 1 | 0 |
9 | SELECT `Category`.`id`, `Category`.`url`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko` FROM `irisoweb_test`.`categories` AS `Category` WHERE `Category`.`id` = 1 | | 1 | 1 | 0 |
10 | SELECT `Category`.`id`, `Category`.`url`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko` FROM `irisoweb_test`.`categories` AS `Category` WHERE `Category`.`id` = 1 | | 1 | 1 | 0 |
11 | SELECT `Category`.`id`, `Category`.`url`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko` FROM `irisoweb_test`.`categories` AS `Category` WHERE `Category`.`id` = 1 | | 1 | 1 | 0 |
12 | SELECT `Category`.`id`, `Category`.`url`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko` FROM `irisoweb_test`.`categories` AS `Category` WHERE `Category`.`id` = 1 | | 1 | 1 | 0 |
13 | SELECT `Category`.`id`, `Category`.`url`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko` FROM `irisoweb_test`.`categories` AS `Category` WHERE `Category`.`id` = 1 | | 1 | 1 | 0 |
14 | SELECT `Category`.`id`, `Category`.`url`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko` FROM `irisoweb_test`.`categories` AS `Category` WHERE `Category`.`id` = 1 | | 1 | 1 | 0 |
15 | SELECT `Category`.`id`, `Category`.`url`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko` FROM `irisoweb_test`.`categories` AS `Category` WHERE `Category`.`id` = 1 | | 1 | 1 | 0 |
16 | SELECT `Category`.`id`, `Category`.`url`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko` FROM `irisoweb_test`.`categories` AS `Category` WHERE `Category`.`id` = 1 | | 1 | 1 | 0 |
17 | SELECT `Category`.`id`, `Category`.`url`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko` FROM `irisoweb_test`.`categories` AS `Category` WHERE `Category`.`id` = 1 | | 1 | 1 | 0 |
18 | SELECT `Category`.`id`, `Category`.`url`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko` FROM `irisoweb_test`.`categories` AS `Category` WHERE `Category`.`id` = 1 | | 1 | 1 | 0 |
19 | SELECT `Category`.`id`, `Category`.`url`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko` FROM `irisoweb_test`.`categories` AS `Category` WHERE `Category`.`id` = 2 | | 1 | 1 | 0 |
20 | SELECT `Category`.`id`, `Category`.`url`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko` FROM `irisoweb_test`.`categories` AS `Category` WHERE `Category`.`id` = 2 | | 1 | 1 | 0 |
21 | SELECT `Category`.`id`, `Category`.`url`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko` FROM `irisoweb_test`.`categories` AS `Category` WHERE `Category`.`id` = 1 | | 1 | 1 | 0 |
22 | SELECT `Category`.`id`, `Category`.`url`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko` FROM `irisoweb_test`.`categories` AS `Category` WHERE `Category`.`id` = 2 | | 1 | 1 | 0 |
23 | SELECT `Category`.`id`, `Category`.`url`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko` FROM `irisoweb_test`.`categories` AS `Category` WHERE `Category`.`id` = 2 | | 1 | 1 | 0 |
24 | SELECT `Download`.`id`, `Download`.`type`, `Download`.`user_id`, `Download`.`series_id`, `Download`.`product_id`, `Download`.`field`, `Download`.`ip_address`, `Download`.`domain`, `Download`.`created`, `Download`.`modified` FROM `irisoweb_test`.`downloads` AS `Download` WHERE `user_id` IS NULL AND `type` = 'FAV' AND `Download`.`product_id` IN (10524, 10513, 10420, 10315, 10314, 10308, 10253, 10245, 9940, 9939, 9930, 9919, 9673, 9672, 9663, 380, 346, 10502, 364, 329) | | 0 | 0 | 6 |
25 | SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND `model_id` IN (10524, 10513, 10420, 10315, 10314, 10308, 10253, 10245, 9940, 9939, 9930, 9919, 9673, 9672, 9663, 380, 346, 10502, 364, 329) | | 55 | 55 | 7 |
26 | SELECT COUNT(*) AS `count` FROM `irisoweb_test`.`products` AS `Product` LEFT JOIN `irisoweb_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`販売分類` <> 'EOS' AND `Product`.`status` = '有効' AND `Series`.`status` = '有効' AND ((`Product`.`フローティング機能` = 'Yes') OR (`Product`.`ロック方式` = 'Auto I-Lock')) | | 1 | 1 | 12 |
27 | SELECT `Product`.`id`, `Product`.`name` FROM `irisoweb_test`.`products` AS `Product` LEFT JOIN `irisoweb_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`販売分類` <> 'EOS' AND `Product`.`status` = '有効' AND `Series`.`status` = '有効' AND ((`Product`.`フローティング機能` = 'Yes') OR (`Product`.`ロック方式` = 'Auto I-Lock')) | | 242 | 242 | 11 |
28 | SELECT `Download`.`id`, `Download`.`type`, `Download`.`user_id`, `Download`.`series_id`, `Download`.`product_id`, `Download`.`field`, `Download`.`ip_address`, `Download`.`domain`, `Download`.`created`, `Download`.`modified` FROM `irisoweb_test`.`downloads` AS `Download` WHERE `user_id` IS NULL AND `type` = 'FAV' AND `Download`.`product_id` IN (25, 26, 328, 329, 330, 331, 333, 334, 337, 338, 339, 340, 342, 343, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 362, 363, 364, 366, 367, 368, 369, 371, 372, 373, 374, 377, 378, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 9662, 9663, 9664, 9665, 9666, 9667, 9668, 9669, 9670, 9671, 9672, 9673, 9674, 9675, 9676, 9677, 9678, 9679, 9680, 9681, 9682, 9683, 9684, 9685, 9686, 9687, 9688, 9689, 9690, 9691, 9692, 9693, 9694, 9695, 9913, 9914, 9915, 9916, 9917, 9918, 9919, 9920, 9921, 9922, 9923, 9924, 9925, 9926, 9927, 9928, 9929, 9930, 9931, 9932, 9933, 9934, 9935, 9936, 9937, 9938, 9939, 9940, 9941, 9942, 9943, 9944, 9945, 9946, 9947, 9948, 9949, 9950, 9951, 9952, 9953, 9954, 9955, 9956, 9957, 9958, 9959, 9960, 9961, 9962, 9963, 9964, 9965, 9966, 10243, 10244, 10245, 10246, 10247, 10248, 10249, 10250, 10251, 10252, 10253, 10254, 10255, 10256, 10257, 10258, 10305, 10306, 10307, 10308, 10309, 10310, 10311, 10312, 10313, 10314, 10315, 10316, 10317, 10318, 10319, 10320, 10321, 10322, 10323, 10324, 10325, 10326, 10327, 10328, 10329, 10413, 10414, 10415, 10416, 10417, 10418, 10419, 10420, 10421, 10422, 10423, 10424, 10425, 10426, 10427, 10500, 10501, 10502, 10503, 10504, 10505, 10511, 10512, 10513, 10514, 10515, 10516, 10522, 10523, 10524, 10525, 10526, 10527, 10528, 10529, 10530, 11567, 11568, 11569, 11570, 11571, 11572, 11573, 11574, 11575, 11576, 11577, 11578, 11579, 11580, 11581, 11582, 11583, 11584, 11585, 11586, 11587, 11588, 11589, 11590, 11591) | | 0 | 0 | 7 |
29 | SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND `model_id` IN (25, 26, 328, 329, 330, 331, 333, 334, 337, 338, 339, 340, 342, 343, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 362, 363, 364, 366, 367, 368, 369, 371, 372, 373, 374, 377, 378, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 9662, 9663, 9664, 9665, 9666, 9667, 9668, 9669, 9670, 9671, 9672, 9673, 9674, 9675, 9676, 9677, 9678, 9679, 9680, 9681, 9682, 9683, 9684, 9685, 9686, 9687, 9688, 9689, 9690, 9691, 9692, 9693, 9694, 9695, 9913, 9914, 9915, 9916, 9917, 9918, 9919, 9920, 9921, 9922, 9923, 9924, 9925, 9926, 9927, 9928, 9929, 9930, 9931, 9932, 9933, 9934, 9935, 9936, 9937, 9938, 9939, 9940, 9941, 9942, 9943, 9944, 9945, 9946, 9947, 9948, 9949, 9950, 9951, 9952, 9953, 9954, 9955, 9956, 9957, 9958, 9959, 9960, 9961, 9962, 9963, 9964, 9965, 9966, 10243, 10244, 10245, 10246, 10247, 10248, 10249, 10250, 10251, 10252, 10253, 10254, 10255, 10256, 10257, 10258, 10305, 10306, 10307, 10308, 10309, 10310, 10311, 10312, 10313, 10314, 10315, 10316, 10317, 10318, 10319, 10320, 10321, 10322, 10323, 10324, 10325, 10326, 10327, 10328, 10329, 10413, 10414, 10415, 10416, 10417, 10418, 10419, 10420, 10421, 10422, 10423, 10424, 10425, 10426, 10427, 10500, 10501, 10502, 10503, 10504, 10505, 10511, 10512, 10513, 10514, 10515, 10516, 10522, 10523, 10524, 10525, 10526, 10527, 10528, 10529, 10530, 11567, 11568, 11569, 11570, 11571, 11572, 11573, 11574, 11575, 11576, 11577, 11578, 11579, 11580, 11581, 11582, 11583, 11584, 11585, 11586, 11587, 11588, 11589, 11590, 11591) | | 616 | 616 | 8 |
30 | SELECT `Product`.`id`, `Product`.`status`, `Product`.`name`, `Product`.`y_name`, `Product`.`series_id`, `Product`.`type`, `Product`.`html`, `Product`.`html_en`, `Product`.`html_zh`, `Product`.`html_ko`, `Product`.`title`, `Product`.`title_en`, `Product`.`title_zh`, `Product`.`title_ko`, `Product`.`description`, `Product`.`description_en`, `Product`.`description_zh`, `Product`.`description_ko`, `Product`.`keyword_en`, `Product`.`keyword_zh`, `Product`.`keyword_ko`, `Product`.`file_title1`, `Product`.`file_title2`, `Product`.`file_title3`, `Product`.`file_title4`, `Product`.`file_title5`, `Product`.`file_title6`, `Product`.`file_title7`, `Product`.`file_title8`, `Product`.`file_role1`, `Product`.`file_role2`, `Product`.`file_role3`, `Product`.`file_role4`, `Product`.`file_role5`, `Product`.`file_role6`, `Product`.`file_role7`, `Product`.`file_role8`, `Product`.`file_count1`, `Product`.`file_count2`, `Product`.`file_count3`, `Product`.`file_count4`, `Product`.`file_count5`, `Product`.`file_count6`, `Product`.`file_count7`, `Product`.`file_count8`, `Product`.`alternative`, `Product`.`combination`, `Product`.`ambiguous`, `Product`.`buy_url1`, `Product`.`buy_url2`, `Product`.`buy_url3`, `Product`.`buy_url4`, `Product`.`buy_text1`, `Product`.`buy_text2`, `Product`.`buy_text3`, `Product`.`buy_text4`, `Product`.`odr`, `Product`.`created`, `Product`.`modified`, `Product`.`販売分類`, `Product`.`コネクタ形状`, `Product`.`嵌合方向`, `Product`.`基板実装部ピッチ`, `Product`.`接点部めっき`, `Product`.`めっき厚`, `Product`.`本体長さ(ピッチ方向)`, `Product`.`本体幅(奥行き)`, `Product`.`インピーダンス整合`, `Product`.`接触抵抗`, `Product`.`使用温度範囲(Min)`, `Product`.`RoHS2`, `Product`.`ハロゲンフリー`, `Product`.`2点接点`, `Product`.`位置決めボス`, `Product`.`グランド`, `Product`.`ワイドスライダー`, `Product`.`誘い込み用フランジ`, `Product`.`吸着用キャップ`, `Product`.`吸着用テープ`, `Product`.`可動量X`, `Product`.`可動量Y`, `Product`.`有効嵌合長Z`, `Product`.`振幅許容範囲`, `Product`.`挿抜回数`, `Product`.`ロック方式`, `Product`.`カード抜け防止機能`, `Product`.`梱包形態`, `Product`.`梱包数量`, `Product`.`基板実装方法`, `Product`.`嵌合形状`, `Product`.`実装形態`, `Product`.`接点方向`, `Product`.`嵌合部ピッチ`, `Product`.`極数`, `Product`.`伝送規格`, `Product`.`本体高さ`, `Product`.`定格電圧(AC)`, `Product`.`定格電圧(DC)`, `Product`.`定格電流`, `Product`.`耐電圧`, `Product`.`使用温度範囲(Max)`, `Product`.`抜け上寸法`, `Product`.`抜け下寸法`, `Product`.`配列`, `Product`.`フローティング機能`, `Product`.`伝送速度(代表参考値)`, `Product`.`共振振幅量`, (CONCAT(`Product`.`name`, " ", `Product`.`y_name`, " ", `Product`.`file_title1`, " ", `Product`.`file_title2`, " ", `Product`.`file_title3`, " ", `Product`.`file_title4`, " ", `Product`.`file_title5`, " ", `Product`.`file_title6`, " ", `Product`.`file_title7`, " ", `Product`.`file_title8`, " ", `Product`.`alternative`, " ", `Product`.`combination`, " ", `Product`.`ambiguous`, " ", `Series`.`detail`, " ", `Series`.`detail_en`, " ", `Series`.`detail_zh`, " ", `Series`.`detail_ko`, " ", `Series`.`html`, " ", `Series`.`html_en`, " ", `Series`.`html_zh`, " ", `Series`.`html_ko`)) AS `Product__keyword`, `Series`.`id`, `Series`.`name`, `Series`.`detail`, `Series`.`detail_en`, `Series`.`detail_zh`, `Series`.`detail_ko`, `Series`.`category_id` FROM `irisoweb_test`.`products` AS `Product` LEFT JOIN `irisoweb_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`販売分類` <> 'EOS' AND `Product`.`status` = '有効' AND `Series`.`status` = '有効' AND ((`Product`.`フローティング機能` = 'Yes') OR (`Product`.`ロック方式` = 'Auto I-Lock')) AND NOT (`Product`.`id` IN (25, 26, 328, 329, 330, 331, 333, 334, 337, 338, 339, 340, 342, 343, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 362, 363, 364, 366, 367, 368, 369, 371, 372, 373, 374, 377, 378, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 9662, 9663, 9664, 9665, 9666, 9667, 9668, 9669, 9670, 9671, 9672, 9673, 9674, 9675, 9676, 9677, 9678, 9679, 9680, 9681, 9682, 9683, 9684, 9685, 9686, 9687, 9688, 9689, 9690, 9691, 9692, 9693, 9694, 9695, 9913, 9914, 9915, 9916, 9917, 9918, 9919, 9920, 9921, 9922, 9923, 9924, 9925, 9926, 9927, 9928, 9929, 9930, 9931, 9932, 9933, 9934, 9935, 9936, 9937, 9938, 9939, 9940, 9941, 9942, 9943, 9944, 9945, 9946, 9947, 9948, 9949, 9950, 9951, 9952, 9953, 9954, 9955, 9956, 9957, 9958, 9959, 9960, 9961, 9962, 9963, 9964, 9965, 9966, 10243, 10244, 10245, 10246, 10247, 10248, 10249, 10250, 10251, 10252, 10253, 10254, 10255, 10256, 10257, 10258, 10305, 10306, 10307, 10308, 10309, 10310, 10311, 10312, 10313, 10314, 10315, 10316, 10317, 10318, 10319, 10320, 10321, 10322, 10323, 10324, 10325, 10326, 10327, 10328, 10329, 10413, 10414, 10415, 10416, 10417, 10418, 10419, 10420, 10421, 10422, 10423, 10424, 10425, 10426, 10427, 10500, 10501, 10502, 10503, 10504, 10505, 10511, 10512, 10513, 10514, 10515, 10516, 10522, 10523, 10524, 10525, 10526, 10527, 10528, 10529, 10530, 11567, 11568, 11569, 11570, 11571, 11572, 11573, 11574, 11575, 11576, 11577, 11578, 11579, 11580, 11581, 11582, 11583, 11584, 11585, 11586, 11587, 11588, 11589, 11590, 11591)) ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 20 | | 0 | 0 | 13 |
31 | SELECT `Category`.`id`, `Category`.`name_en` FROM `irisoweb_test`.`categories` AS `Category` WHERE 1 = 1 | | 9 | 9 | 0 |
32 | SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Category' AND `model_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9) | | 10 | 10 | 7 |
33 | show columns from `products` | | 108 | 108 | 1 |
34 | SELECT `AddField`.`id`, `AddField`.`name` FROM `irisoweb_test`.`add_fields` AS `AddField` WHERE 1 = 1 ORDER BY `AddField`.`odr` ASC | | 48 | 48 | 0 |
35 | SELECT `Category`.`id`, `Category`.`name_en` FROM `irisoweb_test`.`categories` AS `Category` WHERE 1 = 1 ORDER BY `Category`.`odr` DESC, `Category`.`id` DESC | | 9 | 9 | 0 |
36 | SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Category' AND `model_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9) | | 10 | 10 | 7 |
37 | SELECT `Category`.`id`, `Category`.`status`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko`, `Category`.`detail`, `Category`.`detail_en`, `Category`.`detail_zh`, `Category`.`detail_ko`, `Category`.`title`, `Category`.`title_en`, `Category`.`title_zh`, `Category`.`title_ko`, `Category`.`description`, `Category`.`description_en`, `Category`.`description_zh`, `Category`.`description_ko`, `Category`.`meta_keyword`, `Category`.`meta_keyword_en`, `Category`.`meta_keyword_zh`, `Category`.`meta_keyword_ko`, `Category`.`use_fields`, `Category`.`url`, `Category`.`header_title1`, `Category`.`header_title2`, `Category`.`header_title3`, `Category`.`header_title4`, `Category`.`header_url1`, `Category`.`header_url2`, `Category`.`header_url3`, `Category`.`header_url4`, `Category`.`odr`, `Category`.`created`, `Category`.`modified`, (CONCAT_WS( " ", IFNULL(`Category`.`name`, ""), IFNULL(`Category`.`name_en`, ""), IFNULL(`Category`.`name_zh`, ""), IFNULL(`Category`.`name_ko`, ""), IFNULL(`Category`.`detail`, ""), IFNULL(`Category`.`detail_en`, ""), IFNULL(`Category`.`detail_zh`, ""), IFNULL(`Category`.`detail_ko`, ""), IFNULL(`Category`.`url`, ""), IFNULL(`Category`.`header_title1`, ""), IFNULL(`Category`.`header_title2`, ""), IFNULL(`Category`.`header_title3`, ""), IFNULL(`Category`.`header_title4`, ""))) AS `Category__keyword` FROM `irisoweb_test`.`categories` AS `Category` WHERE 1 = 1 ORDER BY `Category`.`odr` DESC, `Category`.`id` DESC | | 9 | 9 | 2 |
38 | SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Category' AND `model_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9) | | 10 | 10 | 6 |
39 | show columns from `products` | | 108 | 108 | 1 |