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 | 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`.`item_naming` = 1 AND `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`.`koushinbi` desc LIMIT 15 | 15 | 15 | 4 | 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`.`item_naming` = 1 AND `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 | 4 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 64657) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0728-006'))))) OR (((`item_id2` = 64657) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0728-006'))))) OR (((`item_id3` = 64657) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0728-006')))))) 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` = 64657 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80811) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-206443'))))) OR (((`item_id2` = 80811) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-206443'))))) OR (((`item_id3` = 80811) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-206443')))))) 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` = 80811 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80810) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-206542'))))) OR (((`item_id2` = 80810) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-206542'))))) OR (((`item_id3` = 80810) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-206542')))))) 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` = 80810 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 85147) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1063-006'))))) OR (((`item_id2` = 85147) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1063-006'))))) OR (((`item_id3` = 85147) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1063-006')))))) 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` = 85147 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95774) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-35859'))))) OR (((`item_id2` = 95774) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-35859'))))) OR (((`item_id3` = 95774) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-35859')))))) 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` = 95774 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 85156) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1061-006'))))) OR (((`item_id2` = 85156) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1061-006'))))) OR (((`item_id3` = 85156) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1061-006')))))) 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` = 85156 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98564) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0026-044'))))) OR (((`item_id2` = 98564) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0026-044'))))) OR (((`item_id3` = 98564) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0026-044')))))) 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` = 98564 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 | 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` = 98579 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98563) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0026-034'))))) OR (((`item_id2` = 98563) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0026-034'))))) OR (((`item_id3` = 98563) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0026-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` = 98563 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
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 | 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` = 98578 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
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 | 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` = 98608 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95522) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1309-009'))))) OR (((`item_id2` = 95522) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1309-009'))))) OR (((`item_id3` = 95522) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1309-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` = 95522 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98562) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0026-028'))))) OR (((`item_id2` = 98562) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0026-028'))))) OR (((`item_id3` = 98562) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0026-028')))))) 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` = 98562 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
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 | 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` = 98577 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98592) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TP-0033-044'))))) OR (((`item_id2` = 98592) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TP-0033-044'))))) OR (((`item_id3` = 98592) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TP-0033-044')))))) 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` = 98592 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 | |