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 '%ポーチ%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 575 | 575 | 234 | 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 (35018, 35026, 35026, 35027, 35027, 35059, 35059, 35562, 35564, 58134, 58134, 58136, 58136, 64646, 64647, 64648, 64656, 64657, 64658, 64659, 64660, 65033, 65033, 65220, 65220, 65221, 65221, 65222, 65222, 65223, 65223, 65809, 73776, 73776, 73776, 73777, 73777, 73777, 73780, 73780, 73780, 76107, 77331, 77604, 77604, 77604, 77642, 77642, 77643, 77643, 77644, 77644, 77645, 77646, 77647, 77648, 77649, 77650, 77651, 77652, 77653, 77654, 77654, 77655, 77655, 80646, 80646, 80709, 80709, 80710, 80710, 80711, 80711, 80712, 80712, 80713, 80713, 80714, 80714, 80715, 80715, 80717, 80717, 80718, 80718, 80719, 80720, 80805, 80810, 80811, 81216, 81216, 81244, 81244, 83804, 83804, 83805, 83806, 83809, 83810, 83811, 83841, 83842, 83843, 83921, 83921, 83927, 84519, 84520, 84941, 84999, 85000, 85001, 85010, 85010, 85011, 85011, 85113, 85114, 85115, 85116, 85117, 85118, 85119, 85121, 85121, 85122, 85122, 85124, 85124, 85125, 85125, 85130, 85130, 85131, 85131, 85132, 85132, 85133, 85133, 85134, 85134, 85136, 85137, 85139, 85140, 85141, 85147, 85147, 85148, 85148, 85149, 85149, 85150, 85150, 85154, 85155, 85156, 85157, 85158, 85159, 85267, 85268, 85269, 85270, 85399, 85412, 85455, 85456, 85505, 85520, 85763, 85768, 86033, 86034, 86035, 86036, 86037, 86078, 86421, 87246, 87246, 87634, 87702, 87702, 87702, 87748, 87749, 87750, 87751, 87796, 87809, 87813, 87820, 87886, 87886, 87886, 87887, 87887, 87887, 87888, 87888, 87888, 87889, 87889, 87889, 87909, 87910, 88198, 88199, 88200, 88201, 88202, 88203, 88208, 88208, 88208, 88209, 88209, 88210, 88210, 88249, 88250, 88251, 88252, 88253, 88254, 90457, 90689, 90689, 90690, 90690, 90709, 90710, 90711, 90712, 90713, 90714, 90715, 90716, 90747, 90748, 90749, 90857, 90858, 90859, 90860, 90861, 90862, 90863, 90864, 90865, 90866, 90867, 90868, 90869, 90870, 90871, 90872, 90873, 90874, 90875, 90876, 90877, 90878, 90879, 90880, 90881, 90882, 90883, 90884, 90885, 90886, 90887, 90888, 90906, 90907, 90908, 90909, 90910, 90911, 90912, 90913, 90914, 90915, 90916, 90917, 90918, 90919, 90920, 90921, 90922, 90923, 90924, 90925, 90926, 90927, 90928, 90929, 90930, 90931, 90932, 90933, 91070, 91070, 91117, 91136, 91399, 91481, 91586, 91586, 91660, 91661, 91662, 91663, 92095, 93631, 93636, 93990, 94368, 94369, 94419, 94419, 94420, 94420, 94534, 94535, 94536, 94537, 94538, 94539, 94540, 94541, 94542, 94543, 94544, 94545, 94749, 94750, 94751, 94751, 94752, 94752, 94863, 94864, 94865, 94866, 95189, 95189, 95356, 95512, 95513, 95514, 95515, 95516, 95517, 95518, 95519, 95520, 95521, 95522, 95523, 95772, 95774, 95774, 95925, 95926, 95975, 95976, 95977, 95978, 96004, 96005, 96638, 97612, 97613, 97614, 97668, 97668, 97669, 97669, 97670, 97670, 97671, 97671, 97672, 97672, 97673, 97673, 97690, 97697, 97698, 97699, 97727, 97727, 97728, 97729, 97730, 97731, 97732, 97733, 97734, 97735, 97736, 97737, 97738, 97739, 97740, 97741, 97742, 97743, 97744, 97745, 97746, 97747, 97748, 97749, 97750, 97751, 97752, 97753, 97754, 97755, 97756, 97757, 97758, 97759, 97760, 97761, 97762, 97795, 97933, 97934, 97935, 97936, 97937, 97938, 97939, 97940, 97941, 97942, 97985, 97985, 97986, 97986, 97987, 97987, 97988, 97988, 97989, 97989, 97990, 97990, 97991, 97991, 97992, 97992, 97993, 97993, 97994, 97994, 97995, 97995, 97996, 97996, 98009, 98010, 98011, 98012, 98013, 98014, 98015, 98016, 98017, 98018, 98019, 98020, 98021, 98022, 98023, 98024, 98025, 98026, 98027, 98028, 98029, 98030, 98031, 98032, 98033, 98034, 98035, 98036, 98037, 98038, 98039, 98040, 98041, 98042, 98042, 98043, 98043, 98044, 98044, 98045, 98045, 98046, 98047, 98048, 98049, 98049, 98108, 98110, 98114, 98115, 98116, 98168, 98412, 98413, 98415, 98416, 98416, 98435, 98453, 98542, 98543, 98544, 98545, 98546, 98557, 98558, 98559, 98560, 98561, 98562, 98563, 98564, 98565, 98566, 98567, 98568, 98569, 98570, 98571, 98572, 98573, 98574, 98575, 98576, 98577, 98578, 98579, 98580, 98589, 98589, 98590, 98590, 98591, 98591, 98592, 98592, 98605, 98606, 98607, 98608, 98621, 98751, 98821, 98822, 98833, 99327, 99328, 99329, 99427, 99428) 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 (35018, 35026, 35026, 35027, 35027, 35059, 35059, 35562, 35564, 58134, 58134, 58136, 58136, 64646, 64647, 64648, 64656, 64657, 64658, 64659, 64660, 65033, 65033, 65220, 65220, 65221, 65221, 65222, 65222, 65223, 65223, 65809, 73776, 73776, 73776, 73777, 73777, 73777, 73780, 73780, 73780, 76107, 77331, 77604, 77604, 77604, 77642, 77642, 77643, 77643, 77644, 77644, 77645, 77646, 77647, 77648, 77649, 77650, 77651, 77652, 77653, 77654, 77654, 77655, 77655, 80646, 80646, 80709, 80709, 80710, 80710, 80711, 80711, 80712, 80712, 80713, 80713, 80714, 80714, 80715, 80715, 80717, 80717, 80718, 80718, 80719, 80720, 80805, 80810, 80811, 81216, 81216, 81244, 81244, 83804, 83804, 83805, 83806, 83809, 83810, 83811, 83841, 83842, 83843, 83921, 83921, 83927, 84519, 84520, 84941, 84999, 85000, 85001, 85010, 85010, 85011, 85011, 85113, 85114, 85115, 85116, 85117, 85118, 85119, 85121, 85121, 85122, 85122, 85124, 85124, 85125, 85125, 85130, 85130, 85131, 85131, 85132, 85132, 85133, 85133, 85134, 85134, 85136, 85137, 85139, 85140, 85141, 85147, 85147, 85148, 85148, 85149, 85149, 85150, 85150, 85154, 85155, 85156, 85157, 85158, 85159, 85267, 85268, 85269, 85270, 85399, 85412, 85455, 85456, 85505, 85520, 85763, 85768, 86033, 86034, 86035, 86036, 86037, 86078, 86421, 87246, 87246, 87634, 87702, 87702, 87702, 87748, 87749, 87750, 87751, 87796, 87809, 87813, 87820, 87886, 87886, 87886, 87887, 87887, 87887, 87888, 87888, 87888, 87889, 87889, 87889, 87909, 87910, 88198, 88199, 88200, 88201, 88202, 88203, 88208, 88208, 88208, 88209, 88209, 88210, 88210, 88249, 88250, 88251, 88252, 88253, 88254, 90457, 90689, 90689, 90690, 90690, 90709, 90710, 90711, 90712, 90713, 90714, 90715, 90716, 90747, 90748, 90749, 90857, 90858, 90859, 90860, 90861, 90862, 90863, 90864, 90865, 90866, 90867, 90868, 90869, 90870, 90871, 90872, 90873, 90874, 90875, 90876, 90877, 90878, 90879, 90880, 90881, 90882, 90883, 90884, 90885, 90886, 90887, 90888, 90906, 90907, 90908, 90909, 90910, 90911, 90912, 90913, 90914, 90915, 90916, 90917, 90918, 90919, 90920, 90921, 90922, 90923, 90924, 90925, 90926, 90927, 90928, 90929, 90930, 90931, 90932, 90933, 91070, 91070, 91117, 91136, 91399, 91481, 91586, 91586, 91660, 91661, 91662, 91663, 92095, 93631, 93636, 93990, 94368, 94369, 94419, 94419, 94420, 94420, 94534, 94535, 94536, 94537, 94538, 94539, 94540, 94541, 94542, 94543, 94544, 94545, 94749, 94750, 94751, 94751, 94752, 94752, 94863, 94864, 94865, 94866, 95189, 95189, 95356, 95512, 95513, 95514, 95515, 95516, 95517, 95518, 95519, 95520, 95521, 95522, 95523, 95772, 95774, 95774, 95925, 95926, 95975, 95976, 95977, 95978, 96004, 96005, 96638, 97612, 97613, 97614, 97668, 97668, 97669, 97669, 97670, 97670, 97671, 97671, 97672, 97672, 97673, 97673, 97690, 97697, 97698, 97699, 97727, 97727, 97728, 97729, 97730, 97731, 97732, 97733, 97734, 97735, 97736, 97737, 97738, 97739, 97740, 97741, 97742, 97743, 97744, 97745, 97746, 97747, 97748, 97749, 97750, 97751, 97752, 97753, 97754, 97755, 97756, 97757, 97758, 97759, 97760, 97761, 97762, 97795, 97933, 97934, 97935, 97936, 97937, 97938, 97939, 97940, 97941, 97942, 97985, 97985, 97986, 97986, 97987, 97987, 97988, 97988, 97989, 97989, 97990, 97990, 97991, 97991, 97992, 97992, 97993, 97993, 97994, 97994, 97995, 97995, 97996, 97996, 98009, 98010, 98011, 98012, 98013, 98014, 98015, 98016, 98017, 98018, 98019, 98020, 98021, 98022, 98023, 98024, 98025, 98026, 98027, 98028, 98029, 98030, 98031, 98032, 98033, 98034, 98035, 98036, 98037, 98038, 98039, 98040, 98041, 98042, 98042, 98043, 98043, 98044, 98044, 98045, 98045, 98046, 98047, 98048, 98049, 98049, 98108, 98110, 98114, 98115, 98116, 98168, 98412, 98413, 98415, 98416, 98416, 98435, 98453, 98542, 98543, 98544, 98545, 98546, 98557, 98558, 98559, 98560, 98561, 98562, 98563, 98564, 98565, 98566, 98567, 98568, 98569, 98570, 98571, 98572, 98573, 98574, 98575, 98576, 98577, 98578, 98579, 98580, 98589, 98589, 98590, 98590, 98591, 98591, 98592, 98592, 98605, 98606, 98607, 98608, 98621, 98751, 98821, 98822, 98833, 99327, 99328, 99329, 99427, 99428) 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` = 98821) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25324G9'))))) OR (((`item_id2` = 98821) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25324G9'))))) OR (((`item_id3` = 98821) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25324G9')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 1 | |
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` = 98821 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98822) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25324G12'))))) OR (((`item_id2` = 98822) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25324G12'))))) OR (((`item_id3` = 98822) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25324G12')))))) 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` = 98822 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87702) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-262449'))))) OR (((`item_id2` = 87702) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-262449'))))) OR (((`item_id3` = 87702) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-262449')))))) 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` = 87702 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80713) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0928-002'))))) OR (((`item_id2` = 80713) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0928-002'))))) OR (((`item_id3` = 80713) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0928-002')))))) 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` = 80713 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80714) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0928-006'))))) OR (((`item_id2` = 80714) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0928-006'))))) OR (((`item_id3` = 80714) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0928-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` = 80714 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80715) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0928-009'))))) OR (((`item_id2` = 80715) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0928-009'))))) OR (((`item_id3` = 80715) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0928-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` = 80715 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94419) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TZ-1021-004'))))) OR (((`item_id2` = 94419) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TZ-1021-004'))))) OR (((`item_id3` = 94419) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TZ-1021-004')))))) 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` = 94419 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 85139) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1055-008'))))) OR (((`item_id2` = 85139) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1055-008'))))) OR (((`item_id3` = 85139) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1055-008')))))) 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` = 85139 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94420) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TZ-1022-004'))))) OR (((`item_id2` = 94420) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TZ-1022-004'))))) OR (((`item_id3` = 94420) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TZ-1022-004')))))) 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` = 94420 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98012) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0014-008'))))) OR (((`item_id2` = 98012) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0014-008'))))) OR (((`item_id3` = 98012) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0014-008')))))) 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` = 98012 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80709) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0927-002'))))) OR (((`item_id2` = 80709) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0927-002'))))) OR (((`item_id3` = 80709) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0927-002')))))) 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` = 80709 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80710) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0927-006'))))) OR (((`item_id2` = 80710) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0927-006'))))) OR (((`item_id3` = 80710) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0927-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` = 80710 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80711) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0927-009'))))) OR (((`item_id2` = 80711) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0927-009'))))) OR (((`item_id3` = 80711) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0927-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` = 80711 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80712) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0927-034'))))) OR (((`item_id2` = 80712) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0927-034'))))) OR (((`item_id3` = 80712) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0927-034')))))) 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` = 80712 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 88249) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1701-009'))))) OR (((`item_id2` = 88249) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1701-009'))))) OR (((`item_id3` = 88249) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1701-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` = 88249 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 | |