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 | 0 |
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` = 2 AND `Series`.`status` = '有効' AND `Product`.`series_id` = (401) ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 20 | | 20 | 20 | 9 |
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` = 2 | | 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` = 2 | | 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` = 2 | | 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` = 2 | | 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` = 2 | | 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` = 2 | | 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` = 2 | | 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` = 2 | | 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` = 2 | | 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` = 2 | | 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` = 2 | | 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` = 2 | | 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` = 2 | | 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` = 2 | | 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` = 2 | | 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` = 2 | | 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 (6208, 6207, 6206, 6205, 6204, 6203, 6202, 6201, 6200, 6199, 6198, 6197, 6196, 6195, 6194, 6193, 6192, 6191, 6190, 6189) | | 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 (6208, 6207, 6206, 6205, 6204, 6203, 6202, 6201, 6200, 6199, 6198, 6197, 6196, 6195, 6194, 6193, 6192, 6191, 6190, 6189) | | 34 | 34 | 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`.`category_id` = 2 AND `Series`.`status` = '有効' AND `Product`.`series_id` = (401) | | 1 | 1 | 7 |
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`.`category_id` = 2 AND `Series`.`status` = '有効' AND `Product`.`series_id` = (401) | | 132 | 132 | 9 |
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 (6077, 6078, 6079, 6080, 6081, 6082, 6083, 6084, 6085, 6086, 6087, 6088, 6089, 6090, 6091, 6092, 6093, 6094, 6095, 6096, 6097, 6098, 6099, 6100, 6101, 6102, 6103, 6104, 6105, 6106, 6107, 6108, 6109, 6110, 6111, 6112, 6113, 6114, 6115, 6116, 6117, 6118, 6119, 6120, 6121, 6122, 6123, 6124, 6125, 6126, 6127, 6128, 6129, 6130, 6131, 6132, 6133, 6134, 6135, 6136, 6137, 6138, 6139, 6140, 6141, 6142, 6143, 6144, 6145, 6146, 6147, 6148, 6149, 6150, 6151, 6152, 6153, 6154, 6155, 6156, 6157, 6158, 6159, 6160, 6161, 6162, 6163, 6164, 6165, 6166, 6167, 6168, 6169, 6170, 6171, 6172, 6173, 6174, 6175, 6176, 6177, 6178, 6179, 6180, 6181, 6182, 6183, 6184, 6185, 6186, 6187, 6188, 6189, 6190, 6191, 6192, 6193, 6194, 6195, 6196, 6197, 6198, 6199, 6200, 6201, 6202, 6203, 6204, 6205, 6206, 6207, 6208) | | 0 | 0 | 6 |
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 (6077, 6078, 6079, 6080, 6081, 6082, 6083, 6084, 6085, 6086, 6087, 6088, 6089, 6090, 6091, 6092, 6093, 6094, 6095, 6096, 6097, 6098, 6099, 6100, 6101, 6102, 6103, 6104, 6105, 6106, 6107, 6108, 6109, 6110, 6111, 6112, 6113, 6114, 6115, 6116, 6117, 6118, 6119, 6120, 6121, 6122, 6123, 6124, 6125, 6126, 6127, 6128, 6129, 6130, 6131, 6132, 6133, 6134, 6135, 6136, 6137, 6138, 6139, 6140, 6141, 6142, 6143, 6144, 6145, 6146, 6147, 6148, 6149, 6150, 6151, 6152, 6153, 6154, 6155, 6156, 6157, 6158, 6159, 6160, 6161, 6162, 6163, 6164, 6165, 6166, 6167, 6168, 6169, 6170, 6171, 6172, 6173, 6174, 6175, 6176, 6177, 6178, 6179, 6180, 6181, 6182, 6183, 6184, 6185, 6186, 6187, 6188, 6189, 6190, 6191, 6192, 6193, 6194, 6195, 6196, 6197, 6198, 6199, 6200, 6201, 6202, 6203, 6204, 6205, 6206, 6207, 6208) | | 204 | 204 | 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`.`category_id` = 2 AND `Series`.`status` = '有効' AND `Product`.`series_id` = (401) AND NOT (`Product`.`id` IN (6077, 6078, 6079, 6080, 6081, 6082, 6083, 6084, 6085, 6086, 6087, 6088, 6089, 6090, 6091, 6092, 6093, 6094, 6095, 6096, 6097, 6098, 6099, 6100, 6101, 6102, 6103, 6104, 6105, 6106, 6107, 6108, 6109, 6110, 6111, 6112, 6113, 6114, 6115, 6116, 6117, 6118, 6119, 6120, 6121, 6122, 6123, 6124, 6125, 6126, 6127, 6128, 6129, 6130, 6131, 6132, 6133, 6134, 6135, 6136, 6137, 6138, 6139, 6140, 6141, 6142, 6143, 6144, 6145, 6146, 6147, 6148, 6149, 6150, 6151, 6152, 6153, 6154, 6155, 6156, 6157, 6158, 6159, 6160, 6161, 6162, 6163, 6164, 6165, 6166, 6167, 6168, 6169, 6170, 6171, 6172, 6173, 6174, 6175, 6176, 6177, 6178, 6179, 6180, 6181, 6182, 6183, 6184, 6185, 6186, 6187, 6188, 6189, 6190, 6191, 6192, 6193, 6194, 6195, 6196, 6197, 6198, 6199, 6200, 6201, 6202, 6203, 6204, 6205, 6206, 6207, 6208)) ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 20 | | 0 | 0 | 9 |
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 | 6 |
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 | 1 |
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 |