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 '%除菌ウェットティッシュ%') OR (`Item`.`item_name` Like '%除菌ウェットティッシュ%') OR (`Item`.`item_figure` Like '%除菌ウェットティッシュ%') OR (`Item`.`item_color` Like '%除菌ウェットティッシュ%') OR (`Item`.`item_materials` Like '%除菌ウェットティッシュ%') OR (`Item`.`item_note` Like '%除菌ウェットティッシュ%') OR (`Item`.`item_code` Like '%アルコールタイプ%') OR (`Item`.`item_name` Like '%アルコールタイプ%') OR (`Item`.`item_figure` Like '%アルコールタイプ%') OR (`Item`.`item_color` Like '%アルコールタイプ%') OR (`Item`.`item_materials` Like '%アルコールタイプ%') OR (`Item`.`item_note` Like '%アルコールタイプ%') OR (`Item`.`item_code` Like '%10枚%') OR (`Item`.`item_name` Like '%10枚%') OR (`Item`.`item_figure` Like '%10枚%') OR (`Item`.`item_color` Like '%10枚%') OR (`Item`.`item_materials` Like '%10枚%') OR (`Item`.`item_note` Like '%10枚%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 322 | 322 | 399 | maybe slow |
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 (57747, 57748, 71928, 72913, 72914, 72915, 72916, 72917, 72918, 72919, 72920, 73029, 73030, 73031, 76813, 76890, 79229, 79229, 79239, 79239, 81670, 81671, 81672, 83726, 84984, 84984, 84984, 85814, 85815, 86708, 87291, 87291, 87664, 89089, 92052, 92549, 93040, 93041, 93185, 93186, 93189, 93216, 93236, 93241, 93243, 93244, 93261, 94036, 94812, 95120, 95712, 95713, 95714, 95715, 95716, 95717, 95718, 95719, 95720, 95721, 95722, 95723, 95724, 95725, 95726, 95727, 95728, 95729, 95730, 95731, 95732, 95733, 95734, 95735, 95736, 95737, 95738, 95901, 96014, 96040, 96186, 96330, 96336, 96638, 96771, 96772, 96794, 96813, 97039, 97052, 97700, 97700, 97701, 97701, 97702, 97702, 97703, 97703, 97812, 97845, 97846, 97847, 97848, 97849, 97850, 97851, 97852, 97853, 97854, 97855, 97856, 97857, 97858, 97859, 97860, 97861, 97862, 97863, 97864, 97865, 97866, 97867, 97868, 97869, 97870, 97871, 97872, 97873, 97874, 97875, 97876, 97877, 97878, 97879, 97880, 97881, 97882, 97883, 97884, 97885, 97886, 97887, 97888, 97889, 97890, 97891, 97892, 97893, 97894, 97895, 97896, 97897, 97898, 97899, 97900, 97901, 97902, 97903, 97904, 97905, 97906, 97907, 97908, 97909, 97910, 97911, 97912, 97913, 97914, 97915, 97916, 97917, 97918, 97919, 97920, 97921, 97922, 97923, 97923, 97924, 97924, 97925, 97925, 97926, 97926, 97927, 97927, 97928, 97928, 97929, 97930, 97931, 97932, 97933, 97934, 97935, 97936, 97937, 97938, 97939, 97940, 97941, 97942, 97943, 97943, 97944, 97944, 97945, 97945, 97946, 97946, 97947, 97948, 97949, 97950, 97951, 97952, 97953, 97954, 97955, 97956, 97960, 97961, 97962, 97963, 97964, 97965, 97966, 97967, 97968, 97969, 97970, 97971, 97972, 97973, 97974, 97975, 97976, 97977, 97978, 97979, 97980, 97981, 97982, 97983, 97984, 98021, 98022, 98023, 98024, 98025, 98026, 98027, 98028, 98029, 98030, 98031, 98032, 98033, 98034, 98035, 98036, 98037, 98038, 98039, 98040, 98041, 98129, 98132, 98177, 98177, 98215, 98215, 98215, 98216, 98547, 98548, 98549, 98550, 98551, 98552, 98553, 98554, 98555, 98556, 98569, 98570, 98571, 98572, 98573, 98574, 98575, 98576, 98577, 98578, 98579, 98580, 98605, 98606, 98607, 98608, 98609, 98610, 98611, 98612, 98613, 98614, 98615, 98616, 98617, 98618, 98619, 98620, 98622, 98623, 98624, 98625, 98818, 98821, 98822, 99187, 99650) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 15 | 15 | 15 | 3 | 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 (57747, 57748, 71928, 72913, 72914, 72915, 72916, 72917, 72918, 72919, 72920, 73029, 73030, 73031, 76813, 76890, 79229, 79229, 79239, 79239, 81670, 81671, 81672, 83726, 84984, 84984, 84984, 85814, 85815, 86708, 87291, 87291, 87664, 89089, 92052, 92549, 93040, 93041, 93185, 93186, 93189, 93216, 93236, 93241, 93243, 93244, 93261, 94036, 94812, 95120, 95712, 95713, 95714, 95715, 95716, 95717, 95718, 95719, 95720, 95721, 95722, 95723, 95724, 95725, 95726, 95727, 95728, 95729, 95730, 95731, 95732, 95733, 95734, 95735, 95736, 95737, 95738, 95901, 96014, 96040, 96186, 96330, 96336, 96638, 96771, 96772, 96794, 96813, 97039, 97052, 97700, 97700, 97701, 97701, 97702, 97702, 97703, 97703, 97812, 97845, 97846, 97847, 97848, 97849, 97850, 97851, 97852, 97853, 97854, 97855, 97856, 97857, 97858, 97859, 97860, 97861, 97862, 97863, 97864, 97865, 97866, 97867, 97868, 97869, 97870, 97871, 97872, 97873, 97874, 97875, 97876, 97877, 97878, 97879, 97880, 97881, 97882, 97883, 97884, 97885, 97886, 97887, 97888, 97889, 97890, 97891, 97892, 97893, 97894, 97895, 97896, 97897, 97898, 97899, 97900, 97901, 97902, 97903, 97904, 97905, 97906, 97907, 97908, 97909, 97910, 97911, 97912, 97913, 97914, 97915, 97916, 97917, 97918, 97919, 97920, 97921, 97922, 97923, 97923, 97924, 97924, 97925, 97925, 97926, 97926, 97927, 97927, 97928, 97928, 97929, 97930, 97931, 97932, 97933, 97934, 97935, 97936, 97937, 97938, 97939, 97940, 97941, 97942, 97943, 97943, 97944, 97944, 97945, 97945, 97946, 97946, 97947, 97948, 97949, 97950, 97951, 97952, 97953, 97954, 97955, 97956, 97960, 97961, 97962, 97963, 97964, 97965, 97966, 97967, 97968, 97969, 97970, 97971, 97972, 97973, 97974, 97975, 97976, 97977, 97978, 97979, 97980, 97981, 97982, 97983, 97984, 98021, 98022, 98023, 98024, 98025, 98026, 98027, 98028, 98029, 98030, 98031, 98032, 98033, 98034, 98035, 98036, 98037, 98038, 98039, 98040, 98041, 98129, 98132, 98177, 98177, 98215, 98215, 98215, 98216, 98547, 98548, 98549, 98550, 98551, 98552, 98553, 98554, 98555, 98556, 98569, 98570, 98571, 98572, 98573, 98574, 98575, 98576, 98577, 98578, 98579, 98580, 98605, 98606, 98607, 98608, 98609, 98610, 98611, 98612, 98613, 98614, 98615, 98616, 98617, 98618, 98619, 98620, 98622, 98623, 98624, 98625, 98818, 98821, 98822, 99187, 99650) AND `item_rank` <> 3 | 1 | 1 | 2 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84984) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 's-wt1A-a'))))) OR (((`item_id2` = 84984) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 's-wt1A-a'))))) OR (((`item_id3` = 84984) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 's-wt1A-a')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
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` = 84984 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 93189) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25332G10'))))) OR (((`item_id2` = 93189) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25332G10'))))) OR (((`item_id3` = 93189) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25332G10')))))) 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` = 93189 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 79229) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25332G11'))))) OR (((`item_id2` = 79229) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25332G11'))))) OR (((`item_id3` = 79229) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25332G11')))))) 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` = 79229 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98579) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0030-034'))))) OR (((`item_id2` = 98579) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0030-034'))))) OR (((`item_id3` = 98579) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0030-034')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
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` = 98579 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98609) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1369-006'))))) OR (((`item_id2` = 98609) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1369-006'))))) OR (((`item_id3` = 98609) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1369-006')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
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` = 98609 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98624) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TX-0012-011'))))) OR (((`item_id2` = 98624) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TX-0012-011'))))) OR (((`item_id3` = 98624) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TX-0012-011')))))) 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` = 98624 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98549) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0021-011'))))) OR (((`item_id2` = 98549) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0021-011'))))) OR (((`item_id3` = 98549) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0021-011')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
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` = 98549 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 57748) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0301-006'))))) OR (((`item_id2` = 57748) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0301-006'))))) OR (((`item_id3` = 57748) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0301-006')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
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` = 57748 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98578) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0030-028'))))) OR (((`item_id2` = 98578) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0030-028'))))) OR (((`item_id3` = 98578) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0030-028')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
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` = 98578 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98608) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1368-028'))))) OR (((`item_id2` = 98608) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1368-028'))))) OR (((`item_id3` = 98608) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1368-028')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
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` = 98608 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98623) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TX-0012-009'))))) OR (((`item_id2` = 98623) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TX-0012-009'))))) OR (((`item_id3` = 98623) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TX-0012-009')))))) 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` = 98623 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98548) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0021-009'))))) OR (((`item_id2` = 98548) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0021-009'))))) OR (((`item_id3` = 98548) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0021-009')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
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` = 98548 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 83726) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25272G7'))))) OR (((`item_id2` = 83726) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25272G7'))))) OR (((`item_id3` = 83726) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25272G7')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
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` = 83726 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98577) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0030-009'))))) OR (((`item_id2` = 98577) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0030-009'))))) OR (((`item_id3` = 98577) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0030-009')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
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` = 98577 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98607) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1368-011'))))) OR (((`item_id2` = 98607) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1368-011'))))) OR (((`item_id3` = 98607) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1368-011')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
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` = 98607 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
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 | |