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 '%冷%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 753 | 753 | 316 | 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`.`item_speed` = 1 AND `Item`.`id` IN (28880, 35596, 35724, 35724, 35725, 35725, 35726, 35726, 44785, 44786, 44787, 44788, 45127, 54029, 54030, 64473, 64473, 64649, 64651, 64652, 64654, 69456, 73051, 73051, 73068, 73068, 73176, 73176, 73187, 73187, 73215, 73215, 73216, 73216, 73222, 73222, 73850, 73851, 75767, 77025, 77141, 77202, 77203, 77315, 77316, 78417, 79023, 79023, 79265, 80583, 80584, 80646, 80646, 80709, 80709, 80710, 80710, 80711, 80711, 80712, 80712, 80713, 80713, 80714, 80714, 80715, 80715, 80779, 80781, 80782, 80784, 80784, 80785, 80786, 80787, 80790, 80790, 80791, 80792, 80795, 80796, 80798, 80799, 80800, 80800, 80803, 80803, 81150, 81150, 81234, 81722, 81723, 82873, 82877, 83160, 83787, 83788, 83789, 84112, 84113, 84147, 84157, 84158, 84165, 84169, 84174, 84220, 84488, 84493, 84493, 84494, 84494, 84495, 84495, 84501, 84502, 84503, 84503, 84504, 84505, 84521, 84522, 84523, 84524, 84525, 84526, 84533, 84533, 84534, 84534, 84535, 84535, 84536, 84536, 84537, 84538, 84539, 84539, 84540, 85012, 85012, 85014, 85014, 85014, 85015, 85015, 85016, 85016, 85017, 85017, 85017, 85018, 85018, 85019, 85020, 85021, 85022, 85023, 85024, 85082, 85083, 85084, 85085, 85086, 85263, 85264, 85265, 85266, 85275, 85276, 85277, 85491, 85675, 85676, 85677, 85678, 85679, 85680, 85681, 85682, 85683, 85684, 85684, 85685, 85685, 85685, 85794, 85794, 86060, 86110, 86345, 87263, 87279, 87284, 87284, 87286, 87353, 87353, 87354, 87354, 87385, 87385, 87386, 87386, 87387, 87387, 87388, 87389, 87390, 87391, 87391, 87392, 87392, 87393, 87393, 87405, 87406, 87653, 87654, 87775, 87776, 87777, 87778, 87886, 87886, 87886, 87887, 87887, 87887, 87888, 87888, 87888, 87889, 87889, 87889, 87890, 87891, 87915, 87915, 87916, 87916, 88191, 88847, 88853, 88853, 88861, 88862, 88863, 88864, 89456, 89456, 89489, 89511, 90329, 90402, 90403, 90404, 90405, 90406, 90407, 90685, 90686, 90687, 90688, 90689, 90689, 90690, 90690, 90691, 90692, 90693, 90694, 90730, 90731, 90732, 90733, 90734, 90735, 90736, 90737, 90829, 90830, 90831, 90832, 90833, 90834, 90835, 91121, 91121, 91129, 91129, 91133, 91134, 91387, 91440, 91441, 91442, 91443, 91444, 91445, 91446, 91447, 91448, 91449, 91450, 91451, 91452, 91453, 91454, 91455, 91500, 91501, 91502, 91503, 91504, 91508, 91586, 91586, 91587, 91587, 91587, 91588, 91588, 91588, 91608, 91609, 91610, 91611, 91612, 91613, 91614, 91615, 91616, 91616, 91617, 91617, 91618, 91618, 91619, 91619, 91620, 91620, 91621, 91621, 91622, 91623, 91624, 91625, 91626, 91627, 91628, 91629, 91630, 91631, 91631, 91632, 91632, 91633, 91633, 91654, 91655, 91656, 91657, 91658, 91659, 91727, 91728, 91745, 91753, 92111, 92360, 92363, 92370, 92371, 92372, 92373, 92381, 92382, 92690, 92695, 92713, 92724, 92725, 93226, 93245, 93922, 93939, 93940, 93979, 94033, 94036, 94335, 94336, 94341, 94341, 94342, 94342, 94343, 94343, 94350, 94353, 94387, 94388, 94389, 94390, 94391, 94392, 94393, 94394, 94395, 94455, 94456, 94457, 94458, 94459, 94460, 94461, 94462, 94509, 94510, 94515, 94516, 94517, 94565, 94566, 94567, 94568, 94569, 94570, 94603, 94603, 94604, 94604, 94617, 94618, 94619, 94620, 94621, 94622, 94623, 94624, 94625, 94626, 94627, 94628, 94635, 94636, 94637, 94638, 94639, 94640, 94755, 94756, 94819, 94819, 94850, 94851, 94852, 94853, 95109, 95139, 95140, 95141, 95142, 95143, 95144, 95145, 95146, 95147, 95158, 95349, 95353, 95354, 95359, 95359, 95404, 95411, 95598, 95599, 95600, 95601, 95604, 95605, 95606, 95607, 95608, 95658, 95659, 95660, 95661, 95668, 95669, 95670, 95671, 95676, 95677, 95678, 95679, 95680, 95681, 95682, 95683, 95746, 95763, 95764, 95765, 95767, 95778, 95778, 95781, 95782, 95799, 95863, 95864, 95865, 95886, 95952, 96254, 96330, 96346, 96349, 96361, 96362, 96381, 96698, 96763, 96893, 96894, 96895, 96896, 96897, 96898, 96899, 96900, 96901, 96902, 96955, 96964, 96967, 97023, 97024, 97035, 97036, 97042, 97080, 97174, 97370, 97370, 97388, 97630, 97631, 97632, 97633, 97634, 97635, 97636, 97637, 97638, 97639, 97640, 97641, 97642, 97643, 97644, 97645, 97654, 97655, 97656, 97657, 97658, 97659, 97660, 97661, 97662, 97663, 97664, 97688, 97689, 97690, 97691, 97692, 97720, 97720, 97721, 97721, 97726, 97726, 97727, 97727, 97808, 97843, 98070, 98071, 98072, 98073, 98074, 98075, 98076, 98077, 98078, 98079, 98080, 98081, 98082, 98083, 98084, 98085, 98086, 98087, 98088, 98089, 98090, 98091, 98092, 98093, 98094, 98095, 98096, 98097, 98098, 98099, 98100, 98101, 98102, 98103, 98104, 98105, 98106, 98107, 98122, 98158, 98159, 98167, 98169, 98169, 98203, 98204, 98205, 98206, 98425, 98426, 98427, 98428, 98429, 98434, 98489, 98605, 98606, 98607, 98608, 98638, 98639, 98640, 98641, 98769, 98785, 98786, 98789, 98790, 98791, 98792, 98813, 98820, 98898, 98905, 98912, 98913, 98953, 98954, 98955, 98956, 98957, 98958, 98959, 98963, 98964, 98965, 98966, 98974, 98975, 98976, 98979, 98980, 98981, 98982, 98983, 98984, 98985, 98986, 98987, 98988, 98989, 98990, 98991, 98995, 98996, 98997, 98998, 99002, 99003, 99004, 99005, 99006, 99007, 99008, 99009, 99010, 99011, 99012, 99013, 99014, 99015, 99016, 99017, 99018, 99019, 99020, 99150, 99155, 99322, 99384, 99385, 99386, 99387, 99391, 99403, 99404, 99405, 99406, 99417, 99418, 99419, 99420, 99475, 99502, 99503, 99504, 99505, 99507, 99530, 99531, 99532, 99534, 99535, 99536, 99537, 99538, 99539, 99628, 99672, 99705, 99741, 99747) AND `item_rank` <> 3 ORDER BY `Item`.`item_price` asc 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_speed` = 1 AND `Item`.`id` IN (28880, 35596, 35724, 35724, 35725, 35725, 35726, 35726, 44785, 44786, 44787, 44788, 45127, 54029, 54030, 64473, 64473, 64649, 64651, 64652, 64654, 69456, 73051, 73051, 73068, 73068, 73176, 73176, 73187, 73187, 73215, 73215, 73216, 73216, 73222, 73222, 73850, 73851, 75767, 77025, 77141, 77202, 77203, 77315, 77316, 78417, 79023, 79023, 79265, 80583, 80584, 80646, 80646, 80709, 80709, 80710, 80710, 80711, 80711, 80712, 80712, 80713, 80713, 80714, 80714, 80715, 80715, 80779, 80781, 80782, 80784, 80784, 80785, 80786, 80787, 80790, 80790, 80791, 80792, 80795, 80796, 80798, 80799, 80800, 80800, 80803, 80803, 81150, 81150, 81234, 81722, 81723, 82873, 82877, 83160, 83787, 83788, 83789, 84112, 84113, 84147, 84157, 84158, 84165, 84169, 84174, 84220, 84488, 84493, 84493, 84494, 84494, 84495, 84495, 84501, 84502, 84503, 84503, 84504, 84505, 84521, 84522, 84523, 84524, 84525, 84526, 84533, 84533, 84534, 84534, 84535, 84535, 84536, 84536, 84537, 84538, 84539, 84539, 84540, 85012, 85012, 85014, 85014, 85014, 85015, 85015, 85016, 85016, 85017, 85017, 85017, 85018, 85018, 85019, 85020, 85021, 85022, 85023, 85024, 85082, 85083, 85084, 85085, 85086, 85263, 85264, 85265, 85266, 85275, 85276, 85277, 85491, 85675, 85676, 85677, 85678, 85679, 85680, 85681, 85682, 85683, 85684, 85684, 85685, 85685, 85685, 85794, 85794, 86060, 86110, 86345, 87263, 87279, 87284, 87284, 87286, 87353, 87353, 87354, 87354, 87385, 87385, 87386, 87386, 87387, 87387, 87388, 87389, 87390, 87391, 87391, 87392, 87392, 87393, 87393, 87405, 87406, 87653, 87654, 87775, 87776, 87777, 87778, 87886, 87886, 87886, 87887, 87887, 87887, 87888, 87888, 87888, 87889, 87889, 87889, 87890, 87891, 87915, 87915, 87916, 87916, 88191, 88847, 88853, 88853, 88861, 88862, 88863, 88864, 89456, 89456, 89489, 89511, 90329, 90402, 90403, 90404, 90405, 90406, 90407, 90685, 90686, 90687, 90688, 90689, 90689, 90690, 90690, 90691, 90692, 90693, 90694, 90730, 90731, 90732, 90733, 90734, 90735, 90736, 90737, 90829, 90830, 90831, 90832, 90833, 90834, 90835, 91121, 91121, 91129, 91129, 91133, 91134, 91387, 91440, 91441, 91442, 91443, 91444, 91445, 91446, 91447, 91448, 91449, 91450, 91451, 91452, 91453, 91454, 91455, 91500, 91501, 91502, 91503, 91504, 91508, 91586, 91586, 91587, 91587, 91587, 91588, 91588, 91588, 91608, 91609, 91610, 91611, 91612, 91613, 91614, 91615, 91616, 91616, 91617, 91617, 91618, 91618, 91619, 91619, 91620, 91620, 91621, 91621, 91622, 91623, 91624, 91625, 91626, 91627, 91628, 91629, 91630, 91631, 91631, 91632, 91632, 91633, 91633, 91654, 91655, 91656, 91657, 91658, 91659, 91727, 91728, 91745, 91753, 92111, 92360, 92363, 92370, 92371, 92372, 92373, 92381, 92382, 92690, 92695, 92713, 92724, 92725, 93226, 93245, 93922, 93939, 93940, 93979, 94033, 94036, 94335, 94336, 94341, 94341, 94342, 94342, 94343, 94343, 94350, 94353, 94387, 94388, 94389, 94390, 94391, 94392, 94393, 94394, 94395, 94455, 94456, 94457, 94458, 94459, 94460, 94461, 94462, 94509, 94510, 94515, 94516, 94517, 94565, 94566, 94567, 94568, 94569, 94570, 94603, 94603, 94604, 94604, 94617, 94618, 94619, 94620, 94621, 94622, 94623, 94624, 94625, 94626, 94627, 94628, 94635, 94636, 94637, 94638, 94639, 94640, 94755, 94756, 94819, 94819, 94850, 94851, 94852, 94853, 95109, 95139, 95140, 95141, 95142, 95143, 95144, 95145, 95146, 95147, 95158, 95349, 95353, 95354, 95359, 95359, 95404, 95411, 95598, 95599, 95600, 95601, 95604, 95605, 95606, 95607, 95608, 95658, 95659, 95660, 95661, 95668, 95669, 95670, 95671, 95676, 95677, 95678, 95679, 95680, 95681, 95682, 95683, 95746, 95763, 95764, 95765, 95767, 95778, 95778, 95781, 95782, 95799, 95863, 95864, 95865, 95886, 95952, 96254, 96330, 96346, 96349, 96361, 96362, 96381, 96698, 96763, 96893, 96894, 96895, 96896, 96897, 96898, 96899, 96900, 96901, 96902, 96955, 96964, 96967, 97023, 97024, 97035, 97036, 97042, 97080, 97174, 97370, 97370, 97388, 97630, 97631, 97632, 97633, 97634, 97635, 97636, 97637, 97638, 97639, 97640, 97641, 97642, 97643, 97644, 97645, 97654, 97655, 97656, 97657, 97658, 97659, 97660, 97661, 97662, 97663, 97664, 97688, 97689, 97690, 97691, 97692, 97720, 97720, 97721, 97721, 97726, 97726, 97727, 97727, 97808, 97843, 98070, 98071, 98072, 98073, 98074, 98075, 98076, 98077, 98078, 98079, 98080, 98081, 98082, 98083, 98084, 98085, 98086, 98087, 98088, 98089, 98090, 98091, 98092, 98093, 98094, 98095, 98096, 98097, 98098, 98099, 98100, 98101, 98102, 98103, 98104, 98105, 98106, 98107, 98122, 98158, 98159, 98167, 98169, 98169, 98203, 98204, 98205, 98206, 98425, 98426, 98427, 98428, 98429, 98434, 98489, 98605, 98606, 98607, 98608, 98638, 98639, 98640, 98641, 98769, 98785, 98786, 98789, 98790, 98791, 98792, 98813, 98820, 98898, 98905, 98912, 98913, 98953, 98954, 98955, 98956, 98957, 98958, 98959, 98963, 98964, 98965, 98966, 98974, 98975, 98976, 98979, 98980, 98981, 98982, 98983, 98984, 98985, 98986, 98987, 98988, 98989, 98990, 98991, 98995, 98996, 98997, 98998, 99002, 99003, 99004, 99005, 99006, 99007, 99008, 99009, 99010, 99011, 99012, 99013, 99014, 99015, 99016, 99017, 99018, 99019, 99020, 99150, 99155, 99322, 99384, 99385, 99386, 99387, 99391, 99403, 99404, 99405, 99406, 99417, 99418, 99419, 99420, 99475, 99502, 99503, 99504, 99505, 99507, 99530, 99531, 99532, 99534, 99535, 99536, 99537, 99538, 99539, 99628, 99672, 99705, 99741, 99747) 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` = 85082) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1092-006'))))) OR (((`item_id2` = 85082) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1092-006'))))) OR (((`item_id3` = 85082) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1092-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` = 85082 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 85083) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1092-009'))))) OR (((`item_id2` = 85083) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1092-009'))))) OR (((`item_id3` = 85083) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1092-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` = 85083 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 85084) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1092-044'))))) OR (((`item_id2` = 85084) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1092-044'))))) OR (((`item_id3` = 85084) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1092-044')))))) 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` = 85084 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 85085) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1092-002'))))) OR (((`item_id2` = 85085) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1092-002'))))) OR (((`item_id3` = 85085) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1092-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` = 85085 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 85086) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1092-041'))))) OR (((`item_id2` = 85086) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1092-041'))))) OR (((`item_id3` = 85086) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1092-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` = 85086 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90829) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1183-044'))))) OR (((`item_id2` = 90829) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1183-044'))))) OR (((`item_id3` = 90829) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1183-044')))))) 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` = 90829 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90830) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1183-050'))))) OR (((`item_id2` = 90830) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1183-050'))))) OR (((`item_id3` = 90830) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1183-050')))))) 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` = 90830 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90831) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1183-030'))))) OR (((`item_id2` = 90831) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1183-030'))))) OR (((`item_id3` = 90831) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1183-030')))))) 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` = 90831 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90832) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1183-002'))))) OR (((`item_id2` = 90832) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1183-002'))))) OR (((`item_id3` = 90832) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1183-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` = 90832 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90833) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1183-034'))))) OR (((`item_id2` = 90833) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1183-034'))))) OR (((`item_id3` = 90833) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1183-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` = 90833 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90834) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1183-006'))))) OR (((`item_id2` = 90834) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1183-006'))))) OR (((`item_id3` = 90834) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1183-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` = 90834 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90835) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1183-009'))))) OR (((`item_id2` = 90835) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1183-009'))))) OR (((`item_id3` = 90835) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1183-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` = 90835 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 81722) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-215445'))))) OR (((`item_id2` = 81722) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-215445'))))) OR (((`item_id3` = 81722) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-215445')))))) 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` = 81722 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 81723) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-215544'))))) OR (((`item_id2` = 81723) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-215544'))))) OR (((`item_id3` = 81723) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-215544')))))) 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` = 81723 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 85012) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1594-044'))))) OR (((`item_id2` = 85012) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1594-044'))))) OR (((`item_id3` = 85012) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1594-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` = 85012 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 | |