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 '%小%') 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 | 713 | 713 | 412 | 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 (3829, 3829, 35191, 35192, 35193, 35261, 35262, 35416, 35417, 35420, 35577, 36308, 36308, 44174, 44174, 44794, 44794, 44794, 54049, 54049, 54050, 54050, 54051, 54051, 54053, 54053, 58324, 64547, 64547, 64673, 64686, 68606, 68607, 73051, 73051, 73056, 73187, 73187, 74215, 74217, 74219, 74220, 74256, 74257, 74259, 74262, 74284, 74284, 74285, 74285, 74286, 74286, 74291, 74291, 74292, 74292, 74297, 74297, 74326, 74327, 74328, 74329, 74330, 74331, 74332, 74357, 74359, 74360, 74361, 74362, 74363, 74364, 74368, 74369, 74372, 74373, 74375, 74376, 74377, 74382, 74383, 74384, 74385, 74392, 74393, 74395, 74396, 74397, 74402, 74424, 74424, 74427, 74428, 74432, 74439, 74440, 74446, 74450, 74753, 74753, 74753, 74754, 74754, 74754, 74948, 75898, 77713, 77714, 77717, 77718, 77719, 77722, 77723, 77724, 78106, 78107, 78108, 78111, 78112, 78115, 78122, 78123, 78124, 78159, 80470, 80471, 80550, 80588, 80589, 80593, 80595, 80692, 80692, 80693, 80693, 80717, 80717, 80718, 80718, 80719, 80720, 80810, 80811, 81229, 81244, 81244, 81568, 81568, 81568, 81731, 83385, 83757, 83757, 83757, 83758, 83758, 83758, 83759, 83759, 83759, 83841, 83842, 83843, 83851, 83852, 83860, 83900, 83902, 83927, 83936, 84081, 84148, 84353, 84354, 84355, 84450, 84451, 84452, 84519, 84520, 84521, 84522, 84523, 84528, 84529, 84530, 84531, 84532, 84593, 84593, 84594, 84594, 84612, 84613, 84616, 84618, 84620, 84622, 84907, 84908, 84941, 85042, 85043, 85044, 85051, 85052, 85053, 85066, 85067, 85068, 85136, 85137, 85154, 85155, 85156, 85157, 85158, 85159, 85455, 85531, 85534, 85535, 85536, 85537, 85647, 85647, 85668, 85669, 85768, 85815, 86047, 86078, 86421, 87332, 87332, 87333, 87333, 87334, 87334, 87335, 87335, 87336, 87336, 87347, 87348, 87349, 87350, 87351, 87365, 87365, 87366, 87366, 87367, 87367, 87368, 87368, 87369, 87369, 87370, 87370, 87748, 87749, 87750, 87751, 87760, 87796, 87925, 88157, 88158, 88159, 88181, 88181, 88182, 88182, 88183, 88183, 88184, 88184, 88185, 88185, 88192, 88193, 88194, 88201, 88202, 88203, 88228, 88228, 88251, 88252, 89011, 89089, 89295, 89578, 89766, 89766, 90376, 90377, 90461, 90461, 90462, 90674, 90675, 90676, 90677, 90678, 90679, 90680, 90681, 90972, 90973, 90974, 90975, 90976, 90977, 90978, 90979, 90980, 90981, 91045, 91329, 91440, 91441, 91442, 91443, 91444, 91445, 91446, 91447, 91448, 91449, 91450, 91451, 91452, 91453, 91454, 91455, 91484, 91631, 91631, 91632, 91632, 91633, 91633, 91690, 91690, 91691, 91691, 91692, 91692, 91693, 91693, 91694, 91694, 91695, 91695, 91829, 91830, 92060, 92065, 92073, 92309, 92318, 92334, 92359, 92471, 92496, 92517, 92518, 92519, 92520, 92522, 92524, 92535, 92536, 92539, 92547, 92548, 92550, 92552, 92553, 92583, 92659, 92771, 92772, 92880, 92893, 92961, 93506, 93682, 93683, 93945, 93955, 93989, 94036, 94264, 94264, 94269, 94270, 94272, 94275, 94281, 94282, 94283, 94360, 94361, 94368, 94560, 94561, 94562, 94762, 94763, 94818, 95071, 95071, 95074, 95075, 95076, 95077, 95078, 95079, 95081, 95082, 95083, 95120, 95170, 95171, 95172, 95173, 95174, 95175, 95176, 95177, 95178, 95179, 95187, 95210, 95211, 95212, 95243, 95246, 95251, 95252, 95347, 95348, 95349, 95356, 95377, 95399, 95412, 95574, 95610, 95613, 95621, 95638, 95639, 95640, 95641, 95684, 95685, 95686, 95687, 95688, 95689, 95690, 95772, 95774, 95774, 95786, 95794, 95952, 95953, 95984, 95985, 95986, 95987, 95988, 95998, 95999, 96027, 96028, 96029, 96030, 96031, 96034, 96038, 96043, 96046, 96066, 96067, 96121, 96122, 96271, 96275, 96311, 96355, 96403, 96404, 96431, 96432, 96570, 96579, 96628, 96640, 96664, 96671, 96747, 96761, 96763, 96767, 96784, 96812, 96819, 96955, 96957, 96960, 96965, 96970, 97001, 97023, 97036, 97042, 97048, 97103, 97151, 97163, 97217, 97218, 97219, 97358, 97359, 97368, 97368, 97378, 97394, 97429, 97612, 97668, 97668, 97669, 97669, 97670, 97670, 97693, 97694, 97695, 97696, 97697, 97698, 97699, 97728, 97729, 97730, 97731, 97732, 97733, 97734, 97742, 97743, 97744, 97745, 97746, 97747, 97748, 97756, 97757, 97758, 97759, 97760, 97761, 97762, 97788, 97806, 97850, 97851, 97852, 97876, 97877, 97878, 97879, 97880, 97881, 97903, 97904, 97905, 97906, 97907, 97908, 97909, 97910, 97911, 97912, 97913, 97914, 97915, 97916, 97917, 97918, 97919, 97920, 97921, 97922, 97943, 97943, 97944, 97944, 97945, 97945, 97946, 97946, 97997, 97998, 97999, 98000, 98001, 98002, 98108, 98116, 98118, 98118, 98162, 98168, 98169, 98169, 98177, 98177, 98223, 98433, 98433, 98444, 98471, 98503, 98504, 98505, 98506, 98529, 98530, 98531, 98532, 98569, 98570, 98571, 98572, 98581, 98582, 98583, 98584, 98630, 98637, 98653, 98666, 98701, 98724, 98763, 98790, 98797, 98868, 98869, 98870, 98880, 98881, 98882, 98883, 98884, 98885, 98906, 98907, 98971, 98972, 98973, 99002, 99003, 99004, 99005, 99006, 99209, 99210, 99211, 99274, 99275, 99287, 99288, 99289, 99290, 99300, 99318, 99327, 99328, 99329, 99340, 99341, 99342, 99343, 99344, 99345, 99398, 99410, 99412, 99427, 99459, 99460, 99461, 99462, 99474, 99513, 99569, 99583, 99618, 99619, 99652, 99708, 99717, 99718) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 15 | 15 | 15 | 5 | 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 (3829, 3829, 35191, 35192, 35193, 35261, 35262, 35416, 35417, 35420, 35577, 36308, 36308, 44174, 44174, 44794, 44794, 44794, 54049, 54049, 54050, 54050, 54051, 54051, 54053, 54053, 58324, 64547, 64547, 64673, 64686, 68606, 68607, 73051, 73051, 73056, 73187, 73187, 74215, 74217, 74219, 74220, 74256, 74257, 74259, 74262, 74284, 74284, 74285, 74285, 74286, 74286, 74291, 74291, 74292, 74292, 74297, 74297, 74326, 74327, 74328, 74329, 74330, 74331, 74332, 74357, 74359, 74360, 74361, 74362, 74363, 74364, 74368, 74369, 74372, 74373, 74375, 74376, 74377, 74382, 74383, 74384, 74385, 74392, 74393, 74395, 74396, 74397, 74402, 74424, 74424, 74427, 74428, 74432, 74439, 74440, 74446, 74450, 74753, 74753, 74753, 74754, 74754, 74754, 74948, 75898, 77713, 77714, 77717, 77718, 77719, 77722, 77723, 77724, 78106, 78107, 78108, 78111, 78112, 78115, 78122, 78123, 78124, 78159, 80470, 80471, 80550, 80588, 80589, 80593, 80595, 80692, 80692, 80693, 80693, 80717, 80717, 80718, 80718, 80719, 80720, 80810, 80811, 81229, 81244, 81244, 81568, 81568, 81568, 81731, 83385, 83757, 83757, 83757, 83758, 83758, 83758, 83759, 83759, 83759, 83841, 83842, 83843, 83851, 83852, 83860, 83900, 83902, 83927, 83936, 84081, 84148, 84353, 84354, 84355, 84450, 84451, 84452, 84519, 84520, 84521, 84522, 84523, 84528, 84529, 84530, 84531, 84532, 84593, 84593, 84594, 84594, 84612, 84613, 84616, 84618, 84620, 84622, 84907, 84908, 84941, 85042, 85043, 85044, 85051, 85052, 85053, 85066, 85067, 85068, 85136, 85137, 85154, 85155, 85156, 85157, 85158, 85159, 85455, 85531, 85534, 85535, 85536, 85537, 85647, 85647, 85668, 85669, 85768, 85815, 86047, 86078, 86421, 87332, 87332, 87333, 87333, 87334, 87334, 87335, 87335, 87336, 87336, 87347, 87348, 87349, 87350, 87351, 87365, 87365, 87366, 87366, 87367, 87367, 87368, 87368, 87369, 87369, 87370, 87370, 87748, 87749, 87750, 87751, 87760, 87796, 87925, 88157, 88158, 88159, 88181, 88181, 88182, 88182, 88183, 88183, 88184, 88184, 88185, 88185, 88192, 88193, 88194, 88201, 88202, 88203, 88228, 88228, 88251, 88252, 89011, 89089, 89295, 89578, 89766, 89766, 90376, 90377, 90461, 90461, 90462, 90674, 90675, 90676, 90677, 90678, 90679, 90680, 90681, 90972, 90973, 90974, 90975, 90976, 90977, 90978, 90979, 90980, 90981, 91045, 91329, 91440, 91441, 91442, 91443, 91444, 91445, 91446, 91447, 91448, 91449, 91450, 91451, 91452, 91453, 91454, 91455, 91484, 91631, 91631, 91632, 91632, 91633, 91633, 91690, 91690, 91691, 91691, 91692, 91692, 91693, 91693, 91694, 91694, 91695, 91695, 91829, 91830, 92060, 92065, 92073, 92309, 92318, 92334, 92359, 92471, 92496, 92517, 92518, 92519, 92520, 92522, 92524, 92535, 92536, 92539, 92547, 92548, 92550, 92552, 92553, 92583, 92659, 92771, 92772, 92880, 92893, 92961, 93506, 93682, 93683, 93945, 93955, 93989, 94036, 94264, 94264, 94269, 94270, 94272, 94275, 94281, 94282, 94283, 94360, 94361, 94368, 94560, 94561, 94562, 94762, 94763, 94818, 95071, 95071, 95074, 95075, 95076, 95077, 95078, 95079, 95081, 95082, 95083, 95120, 95170, 95171, 95172, 95173, 95174, 95175, 95176, 95177, 95178, 95179, 95187, 95210, 95211, 95212, 95243, 95246, 95251, 95252, 95347, 95348, 95349, 95356, 95377, 95399, 95412, 95574, 95610, 95613, 95621, 95638, 95639, 95640, 95641, 95684, 95685, 95686, 95687, 95688, 95689, 95690, 95772, 95774, 95774, 95786, 95794, 95952, 95953, 95984, 95985, 95986, 95987, 95988, 95998, 95999, 96027, 96028, 96029, 96030, 96031, 96034, 96038, 96043, 96046, 96066, 96067, 96121, 96122, 96271, 96275, 96311, 96355, 96403, 96404, 96431, 96432, 96570, 96579, 96628, 96640, 96664, 96671, 96747, 96761, 96763, 96767, 96784, 96812, 96819, 96955, 96957, 96960, 96965, 96970, 97001, 97023, 97036, 97042, 97048, 97103, 97151, 97163, 97217, 97218, 97219, 97358, 97359, 97368, 97368, 97378, 97394, 97429, 97612, 97668, 97668, 97669, 97669, 97670, 97670, 97693, 97694, 97695, 97696, 97697, 97698, 97699, 97728, 97729, 97730, 97731, 97732, 97733, 97734, 97742, 97743, 97744, 97745, 97746, 97747, 97748, 97756, 97757, 97758, 97759, 97760, 97761, 97762, 97788, 97806, 97850, 97851, 97852, 97876, 97877, 97878, 97879, 97880, 97881, 97903, 97904, 97905, 97906, 97907, 97908, 97909, 97910, 97911, 97912, 97913, 97914, 97915, 97916, 97917, 97918, 97919, 97920, 97921, 97922, 97943, 97943, 97944, 97944, 97945, 97945, 97946, 97946, 97997, 97998, 97999, 98000, 98001, 98002, 98108, 98116, 98118, 98118, 98162, 98168, 98169, 98169, 98177, 98177, 98223, 98433, 98433, 98444, 98471, 98503, 98504, 98505, 98506, 98529, 98530, 98531, 98532, 98569, 98570, 98571, 98572, 98581, 98582, 98583, 98584, 98630, 98637, 98653, 98666, 98701, 98724, 98763, 98790, 98797, 98868, 98869, 98870, 98880, 98881, 98882, 98883, 98884, 98885, 98906, 98907, 98971, 98972, 98973, 99002, 99003, 99004, 99005, 99006, 99209, 99210, 99211, 99274, 99275, 99287, 99288, 99289, 99290, 99300, 99318, 99327, 99328, 99329, 99340, 99341, 99342, 99343, 99344, 99345, 99398, 99410, 99412, 99427, 99459, 99460, 99461, 99462, 99474, 99513, 99569, 99583, 99618, 99619, 99652, 99708, 99717, 99718) AND `item_rank` <> 3 | 1 | 1 | 5 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92517) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25285G9A'))))) OR (((`item_id2` = 92517) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25285G9A'))))) OR (((`item_id3` = 92517) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25285G9A')))))) 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` = 92517 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 74432) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-033445FC'))))) OR (((`item_id2` = 74432) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-033445FC'))))) OR (((`item_id3` = 74432) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-033445FC')))))) 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` = 74432 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
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 | 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` = 80811 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
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` = 94281) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-289446'))))) OR (((`item_id2` = 94281) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-289446'))))) OR (((`item_id3` = 94281) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-289446')))))) 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` = 94281 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
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 | 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` = 85156 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97359) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2325220'))))) OR (((`item_id2` = 97359) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2325220'))))) OR (((`item_id3` = 97359) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2325220')))))) 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` = 97359 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98529) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0146-001'))))) OR (((`item_id2` = 98529) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0146-001'))))) OR (((`item_id3` = 98529) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0146-001')))))) 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` = 98529 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97378) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2392250'))))) OR (((`item_id2` = 97378) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2392250'))))) OR (((`item_id3` = 97378) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2392250')))))) 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` = 97378 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98504) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0145-011'))))) OR (((`item_id2` = 98504) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0145-011'))))) OR (((`item_id3` = 98504) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0145-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` = 98504 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95179) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-35735'))))) OR (((`item_id2` = 95179) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-35735'))))) OR (((`item_id3` = 95179) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-35735')))))) 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` = 95179 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92539) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25318G3'))))) OR (((`item_id2` = 92539) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25318G3'))))) OR (((`item_id3` = 92539) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25318G3')))))) 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` = 92539 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98503) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0145-008'))))) OR (((`item_id2` = 98503) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0145-008'))))) OR (((`item_id3` = 98503) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0145-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` = 98503 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98532) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0147-008'))))) OR (((`item_id2` = 98532) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0147-008'))))) OR (((`item_id3` = 98532) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0147-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` = 98532 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 | |