| Query |  Affected |  Num. rows |  Took (ms) |  Actions | 
|---|
| SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`category_sort_order`, `Category`.`words`, `Category`.`flg_hidden`, `Category`.`created`, `Category`.`modified` FROM `witinc_pqnavi_test`.`md_categories` AS `Category`   WHERE `Category`.`flg_hidden` = 0   ORDER BY `Category`.`category_sort_order` ASC |  38 |  38 |  0 |   | 
| SELECT `Category`.`id`, `Category`.`words` FROM `witinc_pqnavi_test`.`md_categories` AS `Category`   WHERE `Category`.`flg_hidden` = 0   ORDER BY `Category`.`category_sort_order` ASC |  38 |  38 |  0 |   | 
| SELECT `ItemsCategory`.`id`, `ItemsCategory`.`item_id` FROM `witinc_pqnavi_test`.`md_items_categories` AS `ItemsCategory` LEFT JOIN `witinc_pqnavi_test`.`md_items` AS `Item` ON (`ItemsCategory`.`item_id` = `Item`.`id`)  WHERE ((`Item`.`item_code` Like '%USBメモリ%') OR (`Item`.`item_name` Like '%USBメモリ%') OR (`Item`.`item_figure` Like '%USBメモリ%') OR (`Item`.`item_color` Like '%USBメモリ%') OR (`Item`.`item_materials` Like '%USBメモリ%') OR (`Item`.`item_note` Like '%USBメモリ%')) AND `Item`.`item_rank` < 3   ORDER BY `ItemsCategory`.`item_id` ASC |  31 |  31 |  0 |   | 
| SELECT `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_stock_wholesale_price`, `Item`.`item_unit`, `Item`.`koushinbi`, `Item`.`item_color`, `Item`.`item_rank`, `Item`.`item_naming`, `Item`.`item_note`, `Item`.`file1_name`, `Campaign`.`id`, `Campaign`.`campaign_price`, `Item`.`item_fullcolor`, `Item`.`item_speed` FROM `witinc_pqnavi_test`.`md_items` AS `Item` LEFT JOIN `witinc_pqnavi_test`.`md_campaigns` AS `Campaign` ON (`Campaign`.`item_id` = `Item`.`id`)  WHERE `Item`.`id` IN (80587, 80588, 80589, 80593, 80595, 80596, 80597, 80598, 80607, 80608, 80609, 80609, 80610, 80610, 80611, 80611, 80612, 80613, 80614, 80614, 80614, 80615, 80615, 80615, 80616, 80616, 80616, 80617, 80617, 80617, 91759) AND `item_rank` <> 3   ORDER BY `Item`.`item_price` asc  LIMIT 15 |  15 |  15 |  2 |  maybe slow | 
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_items` AS `Item` LEFT JOIN `witinc_pqnavi_test`.`md_campaigns` AS `Campaign` ON (`Campaign`.`item_id` = `Item`.`id`)  WHERE `Item`.`id` IN (80587, 80588, 80589, 80593, 80595, 80596, 80597, 80598, 80607, 80608, 80609, 80609, 80610, 80610, 80611, 80611, 80612, 80613, 80614, 80614, 80614, 80615, 80615, 80615, 80616, 80616, 80616, 80617, 80617, 80617, 91759) AND `item_rank` <> 3 |  1 |  1 |  1 |   | 
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery`   WHERE ((((`item_id1` = 80587) OR ((((item_id1 IS NULL OR item_id1 = ''))  AND  (`item_code1` = 'FB-WA'))))) OR (((`item_id2` = 80587) OR ((((item_id2 IS NULL OR item_id2 = ''))  AND  (`item_code2` = 'FB-WA'))))) OR (((`item_id3` = 80587) OR ((((item_id3 IS NULL OR item_id3 = ''))  AND  (`item_code3` = 'FB-WA'))))))   ORDER BY `issue_date` desc  LIMIT 1 |  0 |  0 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`)  WHERE `QuestionnaireItem`.`item_id` = 80587 AND `Questionnaire`.`publish_flg` = 1 |  1 |  1 |  0 |   | 
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery`   WHERE ((((`item_id1` = 80588) OR ((((item_id1 IS NULL OR item_id1 = ''))  AND  (`item_code1` = 'FB-TW-A'))))) OR (((`item_id2` = 80588) OR ((((item_id2 IS NULL OR item_id2 = ''))  AND  (`item_code2` = 'FB-TW-A'))))) OR (((`item_id3` = 80588) OR ((((item_id3 IS NULL OR item_id3 = ''))  AND  (`item_code3` = 'FB-TW-A'))))))   ORDER BY `issue_date` desc  LIMIT 1 |  0 |  0 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`)  WHERE `QuestionnaireItem`.`item_id` = 80588 AND `Questionnaire`.`publish_flg` = 1 |  1 |  1 |  0 |   | 
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery`   WHERE ((((`item_id1` = 80589) OR ((((item_id1 IS NULL OR item_id1 = ''))  AND  (`item_code1` = 'FB-TW-B'))))) OR (((`item_id2` = 80589) OR ((((item_id2 IS NULL OR item_id2 = ''))  AND  (`item_code2` = 'FB-TW-B'))))) OR (((`item_id3` = 80589) OR ((((item_id3 IS NULL OR item_id3 = ''))  AND  (`item_code3` = 'FB-TW-B'))))))   ORDER BY `issue_date` desc  LIMIT 1 |  0 |  0 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`)  WHERE `QuestionnaireItem`.`item_id` = 80589 AND `Questionnaire`.`publish_flg` = 1 |  1 |  1 |  0 |   | 
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery`   WHERE ((((`item_id1` = 80593) OR ((((item_id1 IS NULL OR item_id1 = ''))  AND  (`item_code1` = 'FB-TW-F'))))) OR (((`item_id2` = 80593) OR ((((item_id2 IS NULL OR item_id2 = ''))  AND  (`item_code2` = 'FB-TW-F'))))) OR (((`item_id3` = 80593) OR ((((item_id3 IS NULL OR item_id3 = ''))  AND  (`item_code3` = 'FB-TW-F'))))))   ORDER BY `issue_date` desc  LIMIT 1 |  0 |  0 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`)  WHERE `QuestionnaireItem`.`item_id` = 80593 AND `Questionnaire`.`publish_flg` = 1 |  1 |  1 |  0 |   | 
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery`   WHERE ((((`item_id1` = 80595) OR ((((item_id1 IS NULL OR item_id1 = ''))  AND  (`item_code1` = 'FB-TW-H'))))) OR (((`item_id2` = 80595) OR ((((item_id2 IS NULL OR item_id2 = ''))  AND  (`item_code2` = 'FB-TW-H'))))) OR (((`item_id3` = 80595) OR ((((item_id3 IS NULL OR item_id3 = ''))  AND  (`item_code3` = 'FB-TW-H'))))))   ORDER BY `issue_date` desc  LIMIT 1 |  0 |  0 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`)  WHERE `QuestionnaireItem`.`item_id` = 80595 AND `Questionnaire`.`publish_flg` = 1 |  1 |  1 |  0 |   | 
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery`   WHERE ((((`item_id1` = 80612) OR ((((item_id1 IS NULL OR item_id1 = ''))  AND  (`item_code1` = 'FB-FC-A'))))) OR (((`item_id2` = 80612) OR ((((item_id2 IS NULL OR item_id2 = ''))  AND  (`item_code2` = 'FB-FC-A'))))) OR (((`item_id3` = 80612) OR ((((item_id3 IS NULL OR item_id3 = ''))  AND  (`item_code3` = 'FB-FC-A'))))))   ORDER BY `issue_date` desc  LIMIT 1 |  0 |  0 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`)  WHERE `QuestionnaireItem`.`item_id` = 80612 AND `Questionnaire`.`publish_flg` = 1 |  1 |  1 |  0 |   | 
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery`   WHERE ((((`item_id1` = 80613) OR ((((item_id1 IS NULL OR item_id1 = ''))  AND  (`item_code1` = 'FB-FC-B'))))) OR (((`item_id2` = 80613) OR ((((item_id2 IS NULL OR item_id2 = ''))  AND  (`item_code2` = 'FB-FC-B'))))) OR (((`item_id3` = 80613) OR ((((item_id3 IS NULL OR item_id3 = ''))  AND  (`item_code3` = 'FB-FC-B'))))))   ORDER BY `issue_date` desc  LIMIT 1 |  0 |  0 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`)  WHERE `QuestionnaireItem`.`item_id` = 80613 AND `Questionnaire`.`publish_flg` = 1 |  1 |  1 |  0 |   | 
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery`   WHERE ((((`item_id1` = 80596) OR ((((item_id1 IS NULL OR item_id1 = ''))  AND  (`item_code1` = 'FB-EX-A'))))) OR (((`item_id2` = 80596) OR ((((item_id2 IS NULL OR item_id2 = ''))  AND  (`item_code2` = 'FB-EX-A'))))) OR (((`item_id3` = 80596) OR ((((item_id3 IS NULL OR item_id3 = ''))  AND  (`item_code3` = 'FB-EX-A'))))))   ORDER BY `issue_date` desc  LIMIT 1 |  0 |  0 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`)  WHERE `QuestionnaireItem`.`item_id` = 80596 AND `Questionnaire`.`publish_flg` = 1 |  1 |  1 |  0 |   | 
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery`   WHERE ((((`item_id1` = 80597) OR ((((item_id1 IS NULL OR item_id1 = ''))  AND  (`item_code1` = 'FB-EX-B'))))) OR (((`item_id2` = 80597) OR ((((item_id2 IS NULL OR item_id2 = ''))  AND  (`item_code2` = 'FB-EX-B'))))) OR (((`item_id3` = 80597) OR ((((item_id3 IS NULL OR item_id3 = ''))  AND  (`item_code3` = 'FB-EX-B'))))))   ORDER BY `issue_date` desc  LIMIT 1 |  0 |  0 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`)  WHERE `QuestionnaireItem`.`item_id` = 80597 AND `Questionnaire`.`publish_flg` = 1 |  1 |  1 |  0 |   | 
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery`   WHERE ((((`item_id1` = 80598) OR ((((item_id1 IS NULL OR item_id1 = ''))  AND  (`item_code1` = 'FB-EX-C'))))) OR (((`item_id2` = 80598) OR ((((item_id2 IS NULL OR item_id2 = ''))  AND  (`item_code2` = 'FB-EX-C'))))) OR (((`item_id3` = 80598) OR ((((item_id3 IS NULL OR item_id3 = ''))  AND  (`item_code3` = 'FB-EX-C'))))))   ORDER BY `issue_date` desc  LIMIT 1 |  0 |  0 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`)  WHERE `QuestionnaireItem`.`item_id` = 80598 AND `Questionnaire`.`publish_flg` = 1 |  1 |  1 |  0 |   | 
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery`   WHERE ((((`item_id1` = 80607) OR ((((item_id1 IS NULL OR item_id1 = ''))  AND  (`item_code1` = 'FB-NA'))))) OR (((`item_id2` = 80607) OR ((((item_id2 IS NULL OR item_id2 = ''))  AND  (`item_code2` = 'FB-NA'))))) OR (((`item_id3` = 80607) OR ((((item_id3 IS NULL OR item_id3 = ''))  AND  (`item_code3` = 'FB-NA'))))))   ORDER BY `issue_date` desc  LIMIT 1 |  0 |  0 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`)  WHERE `QuestionnaireItem`.`item_id` = 80607 AND `Questionnaire`.`publish_flg` = 1 |  1 |  1 |  0 |   | 
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery`   WHERE ((((`item_id1` = 80608) OR ((((item_id1 IS NULL OR item_id1 = ''))  AND  (`item_code1` = 'FB-NX'))))) OR (((`item_id2` = 80608) OR ((((item_id2 IS NULL OR item_id2 = ''))  AND  (`item_code2` = 'FB-NX'))))) OR (((`item_id3` = 80608) OR ((((item_id3 IS NULL OR item_id3 = ''))  AND  (`item_code3` = 'FB-NX'))))))   ORDER BY `issue_date` desc  LIMIT 1 |  0 |  0 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`)  WHERE `QuestionnaireItem`.`item_id` = 80608 AND `Questionnaire`.`publish_flg` = 1 |  1 |  1 |  0 |   | 
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery`   WHERE ((((`item_id1` = 80609) OR ((((item_id1 IS NULL OR item_id1 = ''))  AND  (`item_code1` = 'FB-ST-A'))))) OR (((`item_id2` = 80609) OR ((((item_id2 IS NULL OR item_id2 = ''))  AND  (`item_code2` = 'FB-ST-A'))))) OR (((`item_id3` = 80609) OR ((((item_id3 IS NULL OR item_id3 = ''))  AND  (`item_code3` = 'FB-ST-A'))))))   ORDER BY `issue_date` desc  LIMIT 1 |  0 |  0 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`)  WHERE `QuestionnaireItem`.`item_id` = 80609 AND `Questionnaire`.`publish_flg` = 1 |  1 |  1 |  0 |   | 
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery`   WHERE ((((`item_id1` = 80610) OR ((((item_id1 IS NULL OR item_id1 = ''))  AND  (`item_code1` = 'FB-ST-B'))))) OR (((`item_id2` = 80610) OR ((((item_id2 IS NULL OR item_id2 = ''))  AND  (`item_code2` = 'FB-ST-B'))))) OR (((`item_id3` = 80610) OR ((((item_id3 IS NULL OR item_id3 = ''))  AND  (`item_code3` = 'FB-ST-B'))))))   ORDER BY `issue_date` desc  LIMIT 1 |  0 |  0 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`)  WHERE `QuestionnaireItem`.`item_id` = 80610 AND `Questionnaire`.`publish_flg` = 1 |  1 |  1 |  0 |   | 
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery`   WHERE ((((`item_id1` = 80611) OR ((((item_id1 IS NULL OR item_id1 = ''))  AND  (`item_code1` = 'FB-ST-C'))))) OR (((`item_id2` = 80611) OR ((((item_id2 IS NULL OR item_id2 = ''))  AND  (`item_code2` = 'FB-ST-C'))))) OR (((`item_id3` = 80611) OR ((((item_id3 IS NULL OR item_id3 = ''))  AND  (`item_code3` = 'FB-ST-C'))))))   ORDER BY `issue_date` desc  LIMIT 1 |  0 |  0 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`)  WHERE `QuestionnaireItem`.`item_id` = 80611 AND `Questionnaire`.`publish_flg` = 1 |  1 |  1 |  0 |   | 
| SELECT `Category`.`id`, `Category`.`category_name` FROM `witinc_pqnavi_test`.`md_categories` AS `Category`   WHERE `Category`.`flg_hidden` = 0   ORDER BY `Category`.`category_sort_order` ASC |  38 |  38 |  0 |   |