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 '%(S)%') OR (`Item`.`item_name` Like '%(S)%') OR (`Item`.`item_figure` Like '%(S)%') OR (`Item`.`item_color` Like '%(S)%') OR (`Item`.`item_materials` Like '%(S)%') OR (`Item`.`item_note` Like '%(S)%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 457 | 457 | 408 | 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`) LEFT JOIN `witinc_pqnavi_test`.`md_cnts` AS `Cnt` ON (`Cnt`.`item_id` = `Item`.`id`) WHERE `Item`.`id` IN (34960, 34961, 34965, 34968, 35105, 35191, 35192, 35193, 35243, 35244, 35245, 35261, 35262, 35326, 35449, 35450, 38504, 38504, 44693, 44781, 44781, 54083, 54083, 54085, 54085, 54086, 54086, 64622, 64623, 64624, 64649, 64651, 64673, 65233, 65234, 65238, 65278, 65280, 65280, 65374, 69846, 73776, 73776, 73776, 73805, 73806, 73806, 73850, 73852, 73853, 77162, 77163, 77166, 77166, 77167, 77167, 77186, 77188, 77202, 77645, 77646, 77647, 77658, 77658, 77712, 77713, 77714, 77733, 77733, 77736, 77736, 80653, 80654, 80656, 80657, 80717, 80717, 80718, 80718, 80768, 80769, 80800, 80800, 81530, 81530, 81532, 81532, 81533, 81533, 81573, 81574, 81585, 81586, 81587, 81598, 81599, 81600, 81601, 81602, 83859, 83888, 83889, 83890, 83903, 83904, 83905, 83906, 83907, 83908, 83909, 85027, 85028, 85113, 85114, 85117, 85118, 85121, 85121, 85122, 85122, 85130, 85130, 85131, 85131, 85132, 85132, 85147, 85147, 85154, 85155, 85156, 85644, 85672, 85675, 85676, 85677, 87874, 87875, 87876, 87877, 88181, 88181, 88182, 88182, 88183, 88183, 88184, 88184, 88185, 88185, 88192, 88193, 88194, 88208, 88208, 88208, 88209, 88209, 88210, 88210, 88211, 88212, 88213, 88228, 88228, 88240, 88241, 88249, 88250, 90384, 90385, 90392, 90398, 90411, 90418, 90418, 90419, 90419, 90420, 90420, 90695, 90709, 90712, 90715, 90767, 90768, 90769, 90770, 90771, 90771, 90772, 90773, 90774, 90857, 90858, 90859, 90860, 90869, 90870, 90871, 90872, 90881, 90882, 90883, 90884, 90894, 90895, 90896, 90897, 90906, 90907, 90908, 90909, 90918, 90919, 90920, 90921, 91009, 91010, 91435, 91436, 91437, 91438, 91439, 91612, 91613, 91616, 91616, 91617, 91617, 91618, 91618, 91622, 91623, 91624, 91679, 91679, 91680, 91680, 91684, 91684, 91685, 91685, 91686, 91686, 91690, 91690, 91691, 91691, 91692, 91692, 91696, 91696, 91697, 91697, 91698, 91698, 91711, 91711, 91714, 91714, 92133, 92134, 92149, 92150, 92151, 93985, 94396, 94397, 94398, 94399, 94399, 94399, 94404, 94404, 94404, 94415, 94415, 94415, 94419, 94419, 94421, 94421, 94421, 94425, 94425, 94425, 94468, 94469, 94470, 94471, 94472, 94542, 94543, 94544, 94545, 94575, 94576, 94577, 94578, 95126, 95127, 95210, 95211, 95212, 95239, 95240, 95245, 95249, 95250, 95256, 95257, 95258, 95377, 95424, 95425, 95426, 95427, 95428, 95429, 95430, 95431, 95440, 95441, 95442, 95443, 95462, 95463, 95464, 95471, 95472, 95473, 95474, 95475, 95502, 95503, 95514, 95515, 95518, 95519, 95524, 95525, 95531, 95531, 95531, 95536, 95536, 95574, 95583, 95663, 95691, 95692, 95693, 95694, 95695, 95696, 95697, 96068, 96069, 96070, 96071, 96072, 96073, 96074, 96075, 96089, 96090, 96374, 96375, 96376, 96377, 97728, 97729, 97730, 97731, 97732, 97733, 97734, 97742, 97743, 97744, 97745, 97746, 97747, 97748, 97839, 97843, 97845, 97846, 97985, 97985, 97986, 97986, 97987, 97987, 97988, 97988, 97989, 97989, 97990, 97990, 98003, 98004, 98005, 98006, 98007, 98008, 98021, 98022, 98023, 98024, 98025, 98026, 98027, 98028, 98533, 98534, 98537, 98538, 98539, 98540, 98541, 98573, 98574, 98575, 98576, 98581, 98582, 98583, 98584, 98593, 98594, 98595, 98596, 98597, 98598, 98612, 98613, 98614, 98633, 98634, 98846, 98880, 98881, 99674, 99675, 99676, 99677, 99678, 99680, 99681, 99682, 99696, 99729, 99740, 99746, 99750) AND `item_rank` <> 3 ORDER BY `Cnt`.`pagecnt` desc LIMIT 15 | 15 | 15 | 9 | 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`) LEFT JOIN `witinc_pqnavi_test`.`md_cnts` AS `Cnt` ON (`Cnt`.`item_id` = `Item`.`id`) WHERE `Item`.`id` IN (34960, 34961, 34965, 34968, 35105, 35191, 35192, 35193, 35243, 35244, 35245, 35261, 35262, 35326, 35449, 35450, 38504, 38504, 44693, 44781, 44781, 54083, 54083, 54085, 54085, 54086, 54086, 64622, 64623, 64624, 64649, 64651, 64673, 65233, 65234, 65238, 65278, 65280, 65280, 65374, 69846, 73776, 73776, 73776, 73805, 73806, 73806, 73850, 73852, 73853, 77162, 77163, 77166, 77166, 77167, 77167, 77186, 77188, 77202, 77645, 77646, 77647, 77658, 77658, 77712, 77713, 77714, 77733, 77733, 77736, 77736, 80653, 80654, 80656, 80657, 80717, 80717, 80718, 80718, 80768, 80769, 80800, 80800, 81530, 81530, 81532, 81532, 81533, 81533, 81573, 81574, 81585, 81586, 81587, 81598, 81599, 81600, 81601, 81602, 83859, 83888, 83889, 83890, 83903, 83904, 83905, 83906, 83907, 83908, 83909, 85027, 85028, 85113, 85114, 85117, 85118, 85121, 85121, 85122, 85122, 85130, 85130, 85131, 85131, 85132, 85132, 85147, 85147, 85154, 85155, 85156, 85644, 85672, 85675, 85676, 85677, 87874, 87875, 87876, 87877, 88181, 88181, 88182, 88182, 88183, 88183, 88184, 88184, 88185, 88185, 88192, 88193, 88194, 88208, 88208, 88208, 88209, 88209, 88210, 88210, 88211, 88212, 88213, 88228, 88228, 88240, 88241, 88249, 88250, 90384, 90385, 90392, 90398, 90411, 90418, 90418, 90419, 90419, 90420, 90420, 90695, 90709, 90712, 90715, 90767, 90768, 90769, 90770, 90771, 90771, 90772, 90773, 90774, 90857, 90858, 90859, 90860, 90869, 90870, 90871, 90872, 90881, 90882, 90883, 90884, 90894, 90895, 90896, 90897, 90906, 90907, 90908, 90909, 90918, 90919, 90920, 90921, 91009, 91010, 91435, 91436, 91437, 91438, 91439, 91612, 91613, 91616, 91616, 91617, 91617, 91618, 91618, 91622, 91623, 91624, 91679, 91679, 91680, 91680, 91684, 91684, 91685, 91685, 91686, 91686, 91690, 91690, 91691, 91691, 91692, 91692, 91696, 91696, 91697, 91697, 91698, 91698, 91711, 91711, 91714, 91714, 92133, 92134, 92149, 92150, 92151, 93985, 94396, 94397, 94398, 94399, 94399, 94399, 94404, 94404, 94404, 94415, 94415, 94415, 94419, 94419, 94421, 94421, 94421, 94425, 94425, 94425, 94468, 94469, 94470, 94471, 94472, 94542, 94543, 94544, 94545, 94575, 94576, 94577, 94578, 95126, 95127, 95210, 95211, 95212, 95239, 95240, 95245, 95249, 95250, 95256, 95257, 95258, 95377, 95424, 95425, 95426, 95427, 95428, 95429, 95430, 95431, 95440, 95441, 95442, 95443, 95462, 95463, 95464, 95471, 95472, 95473, 95474, 95475, 95502, 95503, 95514, 95515, 95518, 95519, 95524, 95525, 95531, 95531, 95531, 95536, 95536, 95574, 95583, 95663, 95691, 95692, 95693, 95694, 95695, 95696, 95697, 96068, 96069, 96070, 96071, 96072, 96073, 96074, 96075, 96089, 96090, 96374, 96375, 96376, 96377, 97728, 97729, 97730, 97731, 97732, 97733, 97734, 97742, 97743, 97744, 97745, 97746, 97747, 97748, 97839, 97843, 97845, 97846, 97985, 97985, 97986, 97986, 97987, 97987, 97988, 97988, 97989, 97989, 97990, 97990, 98003, 98004, 98005, 98006, 98007, 98008, 98021, 98022, 98023, 98024, 98025, 98026, 98027, 98028, 98533, 98534, 98537, 98538, 98539, 98540, 98541, 98573, 98574, 98575, 98576, 98581, 98582, 98583, 98584, 98593, 98594, 98595, 98596, 98597, 98598, 98612, 98613, 98614, 98633, 98634, 98846, 98880, 98881, 99674, 99675, 99676, 99677, 99678, 99680, 99681, 99682, 99696, 99729, 99740, 99746, 99750) 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` = 73852) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0771-006'))))) OR (((`item_id2` = 73852) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0771-006'))))) OR (((`item_id3` = 73852) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0771-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` = 73852 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 38504) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-0873-044'))))) OR (((`item_id2` = 38504) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-0873-044'))))) OR (((`item_id3` = 38504) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-0873-044')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 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` = 38504 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 77736) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0890-043'))))) OR (((`item_id2` = 77736) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0890-043'))))) OR (((`item_id3` = 77736) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0890-043')))))) 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` = 77736 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 65374) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0749-008'))))) OR (((`item_id2` = 65374) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0749-008'))))) OR (((`item_id3` = 65374) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0749-008')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 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` = 65374 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 81585) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0949-008'))))) OR (((`item_id2` = 81585) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0949-008'))))) OR (((`item_id3` = 81585) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0949-008')))))) 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` = 81585 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 64622) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0742-044'))))) OR (((`item_id2` = 64622) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0742-044'))))) OR (((`item_id3` = 64622) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0742-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` = 64622 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 77712) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0885-008'))))) OR (((`item_id2` = 77712) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0885-008'))))) OR (((`item_id3` = 77712) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0885-008')))))) 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` = 77712 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 54083) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1025-050'))))) OR (((`item_id2` = 54083) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1025-050'))))) OR (((`item_id3` = 54083) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1025-050')))))) 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` = 54083 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 44781) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-0873-050'))))) OR (((`item_id2` = 44781) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-0873-050'))))) OR (((`item_id3` = 44781) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-0873-050')))))) ORDER BY `issue_date` desc LIMIT 1 | 1 | 1 | 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` = 44781 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 35450) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-0496-044'))))) OR (((`item_id2` = 35450) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-0496-044'))))) OR (((`item_id3` = 35450) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-0496-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` = 35450 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 65233) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0749-009'))))) OR (((`item_id2` = 65233) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0749-009'))))) OR (((`item_id3` = 65233) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0749-009')))))) 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` = 65233 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 77202) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0868-008'))))) OR (((`item_id2` = 77202) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0868-008'))))) OR (((`item_id3` = 77202) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0868-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` = 77202 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 77647) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0893-009'))))) OR (((`item_id2` = 77647) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0893-009'))))) OR (((`item_id3` = 77647) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0893-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` = 77647 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 73850) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0769-008'))))) OR (((`item_id2` = 73850) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0769-008'))))) OR (((`item_id3` = 73850) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0769-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` = 73850 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80718) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0915-041'))))) OR (((`item_id2` = 80718) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0915-041'))))) OR (((`item_id3` = 80718) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0915-041')))))) 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` = 80718 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 | |