| 1 | show columns from `products` | | 108 | 108 | 770 |
| 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`.`category_id` = 5 AND `Series`.`status` = '有効' AND `Product`.`series_id` = (266) ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 20 | | 18 | 18 | 11 |
| 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` = 5 | | 1 | 1 | 1 |
| 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` = 5 | | 1 | 1 | 1 |
| 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` = 5 | | 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` = 5 | | 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` = 5 | | 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` = 5 | | 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` = 5 | | 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` = 5 | | 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` = 5 | | 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` = 5 | | 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` = 5 | | 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` = 5 | | 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` = 5 | | 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` = 5 | | 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` = 5 | | 1 | 1 | 1 |
| 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` = 5 | | 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` = 5 | | 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` = 5 | | 1 | 1 | 1 |
| 22 | 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 (1966, 1965, 1964, 1963, 1962, 1961, 1960, 1959, 1958, 1957, 1956, 1955, 1954, 1953, 1952, 1951, 1950, 1949) | | 0 | 0 | 7 |
| 23 | 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 (1966, 1965, 1964, 1963, 1962, 1961, 1960, 1959, 1958, 1957, 1956, 1955, 1954, 1953, 1952, 1951, 1950, 1949) | | 10 | 10 | 7 |
| 24 | 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`.`category_id` = 5 AND `Series`.`status` = '有効' AND `Product`.`series_id` = (266) | | 18 | 18 | 9 |
| 25 | 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 (1949, 1950, 1951, 1952, 1953, 1954, 1955, 1956, 1957, 1958, 1959, 1960, 1961, 1962, 1963, 1964, 1965, 1966) | | 0 | 0 | 7 |
| 26 | 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 (1949, 1950, 1951, 1952, 1953, 1954, 1955, 1956, 1957, 1958, 1959, 1960, 1961, 1962, 1963, 1964, 1965, 1966) | | 10 | 10 | 7 |
| 27 | 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`.`category_id` = 5 AND `Series`.`status` = '有効' AND `Product`.`series_id` = (266) AND NOT (`Product`.`id` IN (1949, 1950, 1951, 1952, 1953, 1954, 1955, 1956, 1957, 1958, 1959, 1960, 1961, 1962, 1963, 1964, 1965, 1966)) ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 20 | | 0 | 0 | 10 |
| 28 | SELECT `Category`.`id`, `Category`.`name_en` FROM `irisoweb_test`.`categories` AS `Category` WHERE 1 = 1 | | 9 | 9 | 0 |
| 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` = 'Category' AND `model_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9) | | 10 | 10 | 7 |
| 30 | show columns from `products` | | 108 | 108 | 281 |
| 31 | SELECT `AddField`.`id`, `AddField`.`name` FROM `irisoweb_test`.`add_fields` AS `AddField` WHERE 1 = 1 ORDER BY `AddField`.`odr` ASC | | 48 | 48 | 0 |
| 32 | 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 |
| 33 | 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 |
| 34 | 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 | 1 |
| 35 | 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 |
| 36 | show columns from `products` | | 108 | 108 | 1 |
