Type-C対応モバイルバッテリーチャージャー10,000mAh 黒 3,375円 ⇒ 注文最小数量:10
お得な値引は08月末日まで |
350円 ⇒ 175円 注文最小数量:200
|
[折り畳みバッグ] コンパクトバッグ(L) ポーチ付 ネイビー 750円 ⇒ 注文最小数量:200 お得な値引は08月末日まで |
<アウトレット売切廃盤> キャンバスベルトライントート(S) ビビッドピンク 300円 ⇒ 150円 注文最小数量:100
|
[名入れタオル] コットンWフェイス ハンドタオル 昇華転写対応 ホワイト 280円 ⇒ 140円 注文最小数量:400
|
<アウトレット売切廃盤> デニムライクトート(S)(名入れ専用商品) ベージュ 700円 ⇒ 350円 注文最小数量:100
|
<アウトレット売切廃盤>織布A4フラットトート ビビッドピンク 140円 ⇒ 70円 注文最小数量:400
|
980円 ⇒ 299円 注文最小数量:120
|
640円 ⇒ 320円 注文最小数量:100 |
530円 ⇒ 265円 注文最小数量:100 |
2,500円 ⇒ 1,470円 注文最小数量:20
|
520円 ⇒ 260円 注文最小数量:50 |
640円 ⇒ 320円 注文最小数量:100
|
250円 ⇒ 125円 注文最小数量:300 |
980円 ⇒ 注文最小数量:30
お得な値引は08月末日まで |
660円 ⇒ 330円 注文最小数量:50
|
460円 ⇒ 注文最小数量:200
お得な値引は08月末日まで |
<アウトレット売切廃盤> [コスメポーチ] ユーティリティスクエアポーチ(S) ネイビーブルー 490円 ⇒ 150円 注文最小数量:200
|
320円 ⇒ 160円 注文最小数量:300
|
2,020円 ⇒ 注文最小数量:30 お得な値引は08月末日まで |
500円 ⇒ 294円 注文最小数量:80
|
1,220円 ⇒ 610円 注文最小数量:50
|
1,200円 ⇒ 399円 注文最小数量:96
|
260円 ⇒ 130円 注文最小数量:400
|
480円 ⇒ 240円 注文最小数量:300
|
730円 ⇒ 365円 注文最小数量:50
|
360円 ⇒ 180円 注文最小数量:400
|
700円 ⇒ 350円 注文最小数量:280
|
<アウトレット売切廃盤> 吸湿発熱ブランケット(巾着付) ブラック 1,750円 ⇒ 355円 注文最小数量:40
|
<アウトレット売切廃盤> クルリト デイリー巾着バッグ レッド 950円 ⇒ 274円 注文最小数量:100
|
オーガニックコットンキャンバスファスナーポーチ ナイトブラック 660円 ⇒ 注文最小数量:100
お得な値引は08月末日まで |
700円 ⇒ 350円 注文最小数量:280
|
[お探しの検索ワードはコチラですか?]
アロマ | 防犯ブザー | デジタルカメラ | 売切廃盤 | 保冷トート | 保存食 | マウス | アロマベア | フォトフレーム | ハロウィン | ランタン | 保存水 [特集] 特急7営業日!名入れスピード印刷、お急ぎのお客様は諦めずにご相談ください [特集] 写真も綺麗に印刷!フルカラー対応ノベルティ インクジェット、昇華転写など |
後払い・送料0円・名入れデータ作成0円 |
|
名入れ!エコバッグ・マグカップ・ボトルなど |
|
冷やし中華、うどん、調味料。最短翌日出荷! |
|
オリジナルラベル対応!33円~送料無料 |
|
時節柄を問わない新アイテム 粗品・ご挨拶 |
|
お手頃で優しい風合い |
|
名入れ対応!非常用ライト・救急セットなど |
|
クリアファイル、ウェットティッシュ、付箋など |
|
ご相談下さい!名入れ印刷、特急7営業日 |
|
厚生労働省推進!思いやりグッズで好感度アップ |
|
注目!スタンド、チャージャー、ポーチ... |
|
写真も綺麗に印刷!フルカラー対応ノベルティ |
値引き商品 リスト|人気ランキング リスト|検索キーワード リスト|お取引について|名入れについて
販促レポート|名入れ制作事例|新着レビュー|オリジナルグッズ制作|会社案内|お問合せ
真面目にひた向きに、おかげ様で20周年
Copyright (C) 1998-2025 SeasonSolution All rights reserved.
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 '%MabuストレングスミニAUTO%') OR (`Item`.`item_name` Like '%MabuストレングスミニAUTO%') OR (`Item`.`item_figure` Like '%MabuストレングスミニAUTO%') OR (`Item`.`item_color` Like '%MabuストレングスミニAUTO%') OR (`Item`.`item_materials` Like '%MabuストレングスミニAUTO%') OR (`Item`.`item_note` Like '%MabuストレングスミニAUTO%') OR (`Item`.`item_code` Like '%R%') OR (`Item`.`item_name` Like '%R%') OR (`Item`.`item_figure` Like '%R%') OR (`Item`.`item_color` Like '%R%') OR (`Item`.`item_materials` Like '%R%') OR (`Item`.`item_note` Like '%R%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 2836 | 2836 | 396 | 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 (6272, 6272, 6273, 6273, 6274, 6274, 34832, 34832, 34833, 34833, 34834, 34834, 34837, 34837, 34865, 34866, 34907, 34908, 34909, 35018, 35026, 35026, 35027, 35027, 35059, 35059, 35105, 35162, 35163, 35164, 35166, 35167, 35169, 35170, 35178, 35179, 35180, 35188, 35189, 35190, 35191, 35192, 35193, 35198, 35209, 35210, 35230, 35231, 35232, 35233, 35243, 35244, 35245, 35252, 35254, 35255, 35260, 35261, 35262, 35263, 35264, 35269, 35270, 35271, 35274, 35286, 35287, 35288, 35289, 35292, 35292, 35293, 35294, 35295, 35296, 35297, 35298, 35301, 35301, 35302, 35303, 35304, 35305, 35306, 35307, 35310, 35310, 35311, 35312, 35326, 35328, 35343, 35343, 35387, 35388, 35389, 35562, 35564, 35568, 35569, 35572, 35574, 35574, 35576, 35577, 35578, 35578, 35579, 35579, 35593, 35596, 36308, 36308, 44664, 44664, 44678, 44678, 44682, 44683, 44685, 44689, 44693, 44694, 44696, 44698, 44699, 44700, 44701, 44702, 44703, 44707, 44708, 44709, 44785, 44786, 44787, 44788, 45144, 45144, 45516, 45516, 45518, 45518, 45522, 45529, 45529, 45539, 45539, 54042, 54043, 54046, 54049, 54049, 54050, 54050, 54051, 54051, 54053, 54053, 54056, 54057, 54058, 54060, 57730, 57731, 57732, 57733, 57746, 57747, 57748, 57765, 58132, 58132, 58134, 58134, 58136, 58136, 58141, 58141, 58142, 58142, 58143, 58143, 58222, 58227, 58229, 58230, 58231, 58231, 58232, 58233, 58234, 58235, 58236, 58344, 58345, 58345, 58347, 58348, 58348, 58349, 58349, 58350, 58350, 58354, 58354, 58355, 58355, 58369, 58370, 58371, 58372, 64443, 64443, 64549, 64550, 64595, 64596, 64597, 64622, 64623, 64624, 64646, 64647, 64648, 64649, 64651, 64652, 64654, 64656, 64657, 64658, 64659, 64660, 64661, 64662, 64663, 64664, 64665, 64666, 64670, 64670, 64671, 64671, 64672, 64672, 64673, 64674, 64676, 64681, 64682, 64683, 65204, 65209, 65209, 65233, 65234, 65238, 65251, 65252, 65261, 65263, 65263, 65264, 65264, 65267, 65267, 65268, 65268, 65269, 65270, 65271, 65271, 65272, 65272, 65273, 65273, 65274, 65276, 65276, 65277, 65277, 65278, 65280, 65280, 65282, 65282, 65295, 65296, 65297, 65297, 65298, 65309, 65309, 65313, 65313, 65340, 65340, 65351, 65352, 65353, 65353, 65358, 65359, 65360, 65360, 65361, 65363, 65364, 65364, 65365, 65366, 65373, 65374, 71525, 71526, 71777, 71778, 71780, 72448, 72448, 72479, 72480, 73613, 73614, 73683, 73684, 73686, 73687, 73691, 73691, 73692, 73693, 73695, 73696, 73697, 73697, 73767, 73768, 73769, 73770, 73771, 73772, 73773, 73774, 73775, 73776, 73776, 73776, 73777, 73777, 73777, 73780, 73780, 73780, 73818, 73820, 73830, 73832, 73833, 73834, 73835, 73836, 73837, 73838, 73842, 73845, 73845, 73847, 73848, 73850, 73851, 73852, 73853, 73856, 73857, 73860, 73861, 74211, 74225, 74239, 74284, 74284, 74285, 74285, 74286, 74286, 74291, 74291, 74292, 74292, 74297, 74297, 74298, 74299, 74300, 74301, 74302, 74303, 74304, 74305, 74306, 74307, 74308, 74309, 74310, 74311, 74351, 74445, 74445, 77053, 77075, 77142, 77143, 77144, 77145, 77146, 77147, 77148, 77149, 77150, 77151, 77152, 77162, 77163, 77164, 77165, 77166, 77166, 77167, 77167, 77169, 77169, 77186, 77188, 77191, 77191, 77202, 77203, 77219, 77220, 77225, 77225, 77590, 77590, 77616, 77616, 77617, 77617, 77642, 77642, 77643, 77643, 77644, 77644, 77645, 77646, 77647, 77648, 77649, 77650, 77651, 77652, 77653, 77654, 77654, 77655, 77655, 77658, 77658, 77660, 77660, 77705, 77705, 77707, 77708, 77710, 77710, 77712, 77713, 77714, 77717, 77718, 77719, 77722, 77723, 77724, 77733, 77733, 77736, 77736, 77743, 77743, 78124, 79302, 79423, 79460, 80540, 80540, 80609, 80609, 80610, 80610, 80611, 80611, 80646, 80646, 80648, 80649, 80650, 80651, 80652, 80653, 80654, 80656, 80657, 80658, 80659, 80660, 80661, 80662, 80663, 80664, 80665, 80666, 80666, 80667, 80667, 80669, 80670, 80671, 80673, 80673, 80674, 80674, 80676, 80676, 80677, 80677, 80678, 80679, 80680, 80681, 80682, 80683, 80684, 80686, 80687, 80688, 80704, 80704, 80709, 80709, 80710, 80710, 80711, 80711, 80712, 80712, 80713, 80713, 80714, 80714, 80715, 80715, 80717, 80717, 80718, 80718, 80719, 80720, 80760, 80761, 80762, 80764, 80765, 80766, 80768, 80769, 80770, 80779, 80781, 80782, 80784, 80784, 80785, 80786, 80787, 80790, 80790, 80791, 80792, 80795, 80796, 80798, 80799, 80800, 80800, 80803, 80803, 81526, 81527, 81528, 81528, 81529, 81530, 81530, 81532, 81532, 81533, 81533, 81534, 81535, 81537, 81538, 81539, 81540, 81540, 81541, 81541, 81542, 81542, 81543, 81543, 81544, 81544, 81545, 81545, 81546, 81546, 81547, 81548, 81549, 81550, 81551, 81552, 81553, 81554, 81555, 81556, 81558, 81569, 81569, 81570, 81570, 81572, 81572, 81573, 81574, 81577, 81578, 81578, 81579, 81580, 81581, 81582, 81585, 81586, 81587, 81590, 81590, 81591, 81591, 81592, 81592, 81593, 81593, 81594, 81594, 81595, 81596, 81597, 81598, 81599, 81600, 81601, 81602, 81603, 81604, 81605, 81606, 81607, 81608, 81609, 81610, 81611, 81612, 81613, 81613, 81614, 81614, 81615, 81615, 81616, 81616, 81621, 81621, 81622, 81622, 81623, 81623, 81624, 81625, 81626, 81628, 81629, 81630, 81631, 81632, 81633, 81634, 81635, 81636, 81645, 81721, 82963, 82968, 82969, 83752, 83753, 83754, 83754, 83755, 83755, 83756, 83756, 83757, 83757, 83757, 83758, 83758, 83758, 83759, 83759, 83759, 83767, 83770, 83771, 83771, 83780, 83781, 83782, 83783, 83784, 83785, 83832, 83833, 83834, 83834, 83835, 83836, 83837, 83838, 83839, 83840, 83841, 83842, 83843, 83844, 83845, 83846, 83851, 83852, 83853, 83854, 83855, 83855, 83859, 83860, 83861, 83862, 83863, 83864, 83865, 83866, 83867, 83868, 83873, 83874, 83875, 83879, 83881, 83885, 83886, 83888, 83889, 83890, 83891, 83892, 83892, 83893, 83894, 83896, 83897, 83898, 83898, 83899, 83899, 83900, 83902, 83903, 83904, 83905, 83906, 83907, 83908, 83909, 84151, 84422, 84422, 84423, 84423, 84424, 84424, 84425, 84425, 84427, 84427, 84428, 84428, 84429, 84429, 84442, 84443, 84444, 84445, 84446, 84446, 84447, 84447, 84448, 84448, 84449, 84449, 84450, 84451, 84452, 84453, 84454, 84455, 84456, 84457, 84458, 84459, 84460, 84461, 84462, 84463, 84464, 84465, 84466, 84467, 84468, 84469, 84470, 84471, 84506, 84507, 84508, 84509, 84510, 84511, 84512, 84513, 84514, 84515, 84516, 84519, 84520, 84546, 84546, 84547, 84547, 84550, 84551, 84552, 84553, 84554, 84555, 84556, 84557, 84558, 84559, 84560, 84561, 84562, 84563, 84564, 84565, 84566, 84567, 84569, 84569, 84570, 84570, 84571, 84571, 84572, 84573, 84574, 84576, 84576, 84577, 84577, 84578, 84578, 84579, 84579, 84580, 84580, 84581, 84582, 84583, 84584, 84584, 84585, 84585, 84590, 84590, 84590, 84596, 84596, 84597, 84597, 84598, 84598, 84599, 84599, 84601, 84601, 84603, 84603, 84604, 84604, 84606, 84606, 84607, 84607, 84608, 84609, 84610, 84611, 84612, 84613, 84616, 84618, 84620, 84622, 84987, 84988, 84990, 84991, 84992, 84993, 84994, 84995, 84996, 84997, 85002, 85003, 85014, 85014, 85014, 85015, 85015, 85016, 85016, 85018, 85018, 85019, 85020, 85021, 85022, 85023, 85024, 85025, 85026, 85027, 85028, 85029, 85030, 85031, 85032, 85033, 85034, 85035, 85036, 85037, 85039, 85039, 85040, 85040, 85041, 85041, 85042, 85043, 85044, 85045, 85046, 85046, 85047, 85048, 85049, 85050, 85051, 85052, 85053, 85062, 85063, 85064, 85064, 85065, 85065, 85066, 85067, 85068, 85069, 85069, 85070, 85070, 85071, 85071, 85072, 85073, 85074, 85075, 85076, 85077, 85078, 85079, 85080, 85081, 85082, 85083, 85084, 85085, 85086, 85087, 85088, 85089, 85090, 85091, 85091, 85092, 85092, 85093, 85093, 85094, 85094, 85104, 85104, 85105, 85105, 85106, 85106, 85107, 85107, 85108, 85108, 85109, 85110, 85111, 85112, 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, 85160, 85161, 85162, 85175, 85175, 85212, 85213, 85214, 85214, 85215, 85215, 85216, 85217, 85445, 85491, 85534, 85535, 85536, 85537, 85538, 85539, 85540, 85541, 85632, 85632, 85633, 85633, 85634, 85634, 85635, 85635, 85636, 85637, 85638, 85639, 85640, 85641, 85647, 85647, 85658, 85662, 85663, 85664, 85664, 85665, 85665, 85666, 85667, 85668, 85669, 85670, 85671, 85672, 85673, 85674, 85675, 85676, 85677, 85678, 85679, 85680, 85681, 85682, 85683, 85684, 85684, 85685, 85685, 85685, 86017, 86028, 86029, 86030, 86031, 86032, 86033, 86034, 86035, 86036, 86037, 86096, 86110, 86932, 86969, 86970, 87014, 87303, 87303, 87304, 87304, 87305, 87305, 87306, 87306, 87307, 87307, 87308, 87308, 87309, 87309, 87310, 87310, 87311, 87311, 87312, 87312, 87313, 87313, 87317, 87317, 87318, 87318, 87319, 87320, 87321, 87322, 87323, 87323, 87324, 87324, 87325, 87325, 87326, 87326, 87327, 87328, 87329, 87330, 87331, 87332, 87332, 87333, 87333, 87334, 87334, 87335, 87335, 87336, 87336, 87337, 87337, 87337, 87338, 87338, 87338, 87339, 87339, 87339, 87340, 87340, 87340, 87341, 87341, 87341, 87342, 87343, 87344, 87345, 87346, 87347, 87348, 87349, 87350, 87351, 87353, 87353, 87354, 87354, 87357, 87357, 87358, 87358, 87359, 87359, 87360, 87360, 87362, 87362, 87362, 87364, 87364, 87365, 87365, 87366, 87366, 87367, 87367, 87368, 87368, 87369, 87369, 87370, 87370, 87371, 87372, 87373, 87385, 87385, 87386, 87386, 87387, 87387, 87388, 87389, 87390, 87391, 87391, 87392, 87392, 87393, 87393, 87394, 87395, 87396, 87397, 87398, 87399, 87403, 87404, 87405, 87406, 87664, 87665, 87853, 87854, 87855, 87855, 87856, 87856, 87857, 87858, 87859, 87860, 87860, 87861, 87861, 87862, 87862, 87863, 87863, 87864, 87864, 87865, 87865, 87866, 87866, 87867, 87867, 87868, 87868, 87869, 87869, 87870, 87870, 87871, 87871, 87872, 87872, 87873, 87873, 87874, 87875, 87876, 87877, 87878, 87879, 87880, 87881, 87882, 87883, 87884, 87885, 87886, 87886, 87886, 87887, 87887, 87887, 87888, 87888, 87888, 87889, 87889, 87889, 87890, 87891, 87906, 87907, 87908, 87942, 87942, 87942, 87943, 87943, 87943, 87944, 87944, 87944, 87945, 87945, 87945, 87946, 87946, 87947, 87947, 87948, 87948, 87949, 87949, 87950, 87950, 88157, 88158, 88159, 88176, 88177, 88178, 88179, 88180, 88181, 88181, 88182, 88182, 88183, 88183, 88184, 88184, 88185, 88185, 88186, 88186, 88187, 88187, 88188, 88188, 88189, 88189, 88190, 88190, 88192, 88193, 88194, 88195, 88196, 88197, 88198, 88199, 88200, 88201, 88202, 88203, 88211, 88212, 88213, 88214, 88215, 88228, 88228, 88229, 88229, 88239, 88240, 88241, 88242, 88243, 88244, 88245, 88246, 88283, 88283, 88453, 88454, 88455, 88540, 88594, 88595, 89171, 89171, 89295, 89578, 90370, 90371, 90372, 90373, 90374, 90375, 90376, 90377, 90378, 90379, 90380, 90381, 90382, 90383, 90384, 90385, 90386, 90387, 90388, 90389, 90390, 90391, 90397, 90397, 90398, 90399, 90416, 90417, 90429, 90429, 90430, 90430, 90433, 90434, 90435, 90436, 90437, 90438, 90439, 90440, 90441, 90442, 90443, 90456, 90456, 90685, 90686, 90687, 90688, 90689, 90689, 90690, 90690, 90691, 90692, 90693, 90694, 90703, 90704, 90705, 90706, 90707, 90708, 90717, 90718, 90719, 90720, 90721, 90722, 90758, 90759, 90760, 90761, 90762, 90763, 90815, 90816, 90817, 90818, 90819, 90820, 90821, 90822, 90823, 90824, 90825, 90826, 90827, 90828, 90829, 90830, 90831, 90832, 90833, 90834, 90835, 90836, 90837, 90838, 90839, 90840, 90841, 90842, 90843, 90844, 90845, 90846, 90847, 90848, 90849, 90850, 90851, 90852, 90853, 90854, 90855, 90856, 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, 90934, 90934, 90935, 90935, 90936, 90936, 90937, 90938, 90939, 90940, 90940, 90941, 90941, 90942, 90942, 90943, 90943, 90944, 90944, 90945, 90945, 90946, 90946, 90947, 90947, 90948, 90948, 90949, 90949, 90950, 90951, 90952, 90953, 90954, 90955, 91005, 91006, 91009, 91010, 91129, 91129, 91320, 91321, 91322, 91322, 91388, 91402, 91403, 91404, 91405, 91406, 91407, 91408, 91409, 91410, 91411, 91412, 91413, 91414, 91415, 91416, 91417, 91418, 91419, 91420, 91421, 91422, 91423, 91424, 91425, 91426, 91427, 91428, 91429, 91430, 91431, 91432, 91433, 91434, 91435, 91436, 91437, 91438, 91439, 91487, 91495, 91496, 91497, 91498, 91499, 91500, 91501, 91502, 91503, 91504, 91593, 91594, 91595, 91596, 91597, 91598, 91599, 91600, 91601, 91602, 91603, 91604, 91605, 91606, 91607, 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, 91634, 91635, 91636, 91637, 91638, 91639, 91640, 91641, 91642, 91679, 91679, 91680, 91680, 91681, 91681, 91682, 91682, 91683, 91683, 91684, 91684, 91685, 91685, 91686, 91686, 91687, 91687, 91688, 91688, 91689, 91689, 91690, 91690, 91691, 91691, 91692, 91692, 91693, 91693, 91694, 91694, 91695, 91695, 91696, 91696, 91697, 91697, 91698, 91698, 91699, 91699, 91700, 91700, 91701, 91701, 91702, 91702, 91703, 91703, 91704, 91704, 91705, 91705, 91706, 91706, 91707, 91707, 91708, 91708, 91709, 91709, 91710, 91710, 91711, 91711, 91712, 91712, 91713, 91713, 91714, 91714, 91715, 91715, 91716, 91716, 91720, 91744, 91745, 91785, 91835, 91839, 91840, 91841, 91891, 91948, 92286, 92389, 92390, 92391, 92395, 92396, 92397, 92471, 92513, 92514, 92515, 92516, 92747, 92749, 92771, 92804, 92820, 92829, 92904, 92905, 92906, 92907, 92991, 92995, 93185, 93280, 93284, 93319, 93346, 93347, 93348, 93359, 93492, 93534, 93536, 93539, 93543, 93544, 93545, 93547, 93548, 93549, 93550, 93551, 93591, 93631, 93636, 93768, 93769, 93770, 93771, 93772, 93789, 93790, 93791, 93792, 93793, 93794, 93982, 94037, 94287, 94288, 94289, 94296, 94297, 94298, 94299, 94300, 94301, 94302, 94303, 94304, 94305, 94306, 94307, 94308, 94309, 94310, 94311, 94319, 94319, 94339, 94352, 94375, 94375, 94376, 94376, 94377, 94377, 94378, 94378, 94379, 94379, 94380, 94380, 94381, 94382, 94383, 94384, 94385, 94386, 94387, 94388, 94389, 94390, 94391, 94392, 94393, 94394, 94395, 94396, 94397, 94398, 94427, 94427, 94427, 94428, 94428, 94428, 94431, 94431, 94432, 94432, 94433, 94433, 94434, 94434, 94435, 94435, 94455, 94456, 94457, 94458, 94459, 94460, 94461, 94462, 94463, 94464, 94465, 94466, 94467, 94468, 94469, 94470, 94471, 94472, 94473, 94474, 94475, 94476, 94477, 94478, 94479, 94480, 94481, 94482, 94483, 94484, 94485, 94486, 94487, 94488, 94489, 94490, 94491, 94492, 94522, 94523, 94524, 94525, 94526, 94527, 94528, 94529, 94530, 94531, 94532, 94533, 94534, 94535, 94536, 94537, 94538, 94539, 94540, 94541, 94542, 94543, 94544, 94545, 94555, 94556, 94557, 94558, 94562, 94571, 94572, 94573, 94574, 94575, 94576, 94577, 94578, 94579, 94580, 94581, 94582, 94583, 94584, 94585, 94586, 94587, 94588, 94589, 94590, 94591, 94592, 94593, 94594, 94595, 94595, 94596, 94596, 94597, 94597, 94600, 94600, 94601, 94601, 94603, 94603, 94604, 94604, 94607, 94608, 94609, 94610, 94611, 94612, 94677, 94678, 94679, 94680, 94681, 94682, 94683, 94684, 94685, 94703, 94704, 94705, 94706, 94707, 94708, 94709, 94710, 94711, 94712, 94713, 94714, 94715, 94716, 94717, 94718, 94719, 94720, 94721, 94722, 94723, 94724, 94761, 94812, 94842, 94846, 94866, 94868, 95052, 95053, 95054, 95055, 95056, 95057, 95058, 95059, 95060, 95061, 95062, 95063, 95120, 95122, 95123, 95124, 95125, 95126, 95127, 95128, 95129, 95171, 95173, 95175, 95177, 95180, 95205, 95206, 95207, 95208, 95209, 95210, 95211, 95212, 95213, 95214, 95215, 95216, 95217, 95218, 95219, 95220, 95221, 95222, 95223, 95224, 95225, 95226, 95227, 95228, 95229, 95230, 95231, 95232, 95233, 95234, 95235, 95236, 95247, 95248, 95249, 95250, 95251, 95252, 95253, 95254, 95255, 95256, 95257, 95258, 95259, 95260, 95261, 95262, 95263, 95264, 95265, 95266, 95267, 95268, 95269, 95270, 95271, 95272, 95273, 95274, 95362, 95363, 95367, 95390, 95411, 95412, 95413, 95414, 95429, 95430, 95431, 95434, 95435, 95436, 95437, 95462, 95463, 95464, 95465, 95466, 95467, 95468, 95469, 95470, 95471, 95472, 95473, 95474, 95475, 95476, 95477, 95478, 95479, 95480, 95481, 95482, 95483, 95484, 95485, 95486, 95487, 95488, 95489, 95490, 95491, 95492, 95493, 95494, 95495, 95496, 95497, 95498, 95499, 95500, 95501, 95502, 95503, 95504, 95505, 95506, 95507, 95508, 95509, 95512, 95513, 95514, 95515, 95516, 95517, 95518, 95519, 95520, 95521, 95522, 95523, 95524, 95525, 95526, 95527, 95528, 95529, 95598, 95599, 95600, 95601, 95611, 95614, 95618, 95619, 95620, 95662, 95663, 95664, 95665, 95666, 95667, 95668, 95669, 95670, 95671, 95672, 95673, 95674, 95675, 95676, 95677, 95678, 95679, 95680, 95681, 95682, 95683, 95712, 95713, 95714, 95715, 95716, 95717, 95718, 95719, 95720, 95721, 95722, 95723, 95724, 95725, 95726, 95727, 95728, 95729, 95730, 95731, 95732, 95733, 95734, 95735, 95736, 95737, 95738, 95791, 95792, 95793, 95799, 95851, 95898, 95899, 95939, 95944, 96194, 96195, 96196, 96333, 96334, 96335, 96356, 96387, 96388, 96389, 96390, 96410, 96411, 96412, 96413, 96419, 96420, 96421, 96430, 96445, 96448, 96529, 96538, 96539, 96540, 96542, 96543, 96561, 96567, 96577, 96639, 96660, 96661, 96664, 96667, 96684, 96719, 96731, 96767, 96771, 96772, 96781, 96782, 96783, 96812, 96813, 96818, 96819, 96829, 96830, 96833, 96834, 96835, 96836, 96843, 96846, 96852, 96853, 96854, 96855, 96856, 96872, 96949, 96950, 96951, 96968, 96978, 96979, 96980, 96981, 96999, 97026, 97034, 97035, 97038, 97041, 97053, 97057, 97058, 97115, 97146, 97147, 97148, 97161, 97165, 97177, 97203, 97204, 97205, 97220, 97221, 97222, 97223, 97224, 97225, 97296, 97297, 97366, 97366, 97378, 97620, 97621, 97622, 97763, 97764, 97765, 97766, 97767, 97768, 97769, 97770, 97771, 97772, 97773, 97774, 97775, 97776, 97777, 97778, 97779, 97780, 97781, 97782, 97783, 97792, 97798, 97827, 97845, 97846, 97847, 97848, 97849, 97850, 97851, 97852, 97853, 97854, 97855, 97856, 97857, 97858, 97859, 97860, 97861, 97862, 97863, 97864, 97865, 97866, 97867, 97868, 97869, 97870, 97871, 97872, 97873, 97874, 97875, 97876, 97877, 97878, 97879, 97880, 97881, 97882, 97883, 97884, 97885, 97886, 97887, 97888, 97889, 97890, 97891, 97892, 97893, 97894, 97895, 97896, 97897, 97898, 97899, 97900, 97901, 97902, 97903, 97904, 97905, 97906, 97907, 97908, 97909, 97910, 97911, 97912, 97913, 97914, 97915, 97916, 97917, 97918, 97919, 97920, 97921, 97922, 97923, 97923, 97924, 97924, 97925, 97925, 97926, 97926, 97927, 97927, 97928, 97928, 97929, 97930, 97931, 97932, 97933, 97934, 97935, 97936, 97937, 97938, 97939, 97940, 97941, 97942, 97943, 97943, 97944, 97944, 97945, 97945, 97946, 97946, 97947, 97948, 97949, 97950, 97951, 97952, 97953, 97954, 97955, 97956, 97957, 97958, 97959, 97960, 97961, 97962, 97963, 97964, 97965, 97966, 97967, 97968, 97969, 97970, 97971, 97972, 97973, 97974, 97975, 97976, 97977, 97978, 97979, 97980, 97981, 97982, 97983, 97984, 98021, 98022, 98023, 98024, 98025, 98026, 98027, 98028, 98029, 98030, 98031, 98032, 98033, 98034, 98035, 98036, 98037, 98038, 98039, 98040, 98041, 98070, 98071, 98072, 98073, 98074, 98075, 98076, 98077, 98078, 98129, 98130, 98131, 98137, 98529, 98530, 98531, 98532, 98593, 98594, 98595, 98596, 98597, 98598, 98599, 98600, 98601, 98602, 98603, 98604, 98605, 98606, 98607, 98608, 98609, 98610, 98611, 98612, 98613, 98614, 98615, 98616, 98617, 98618, 98619, 98620, 98628, 98639, 98649, 98658, 98659, 98660, 98661, 98667, 98687, 98688, 98689, 98708, 98731, 98732, 98733, 98734, 98736, 98737, 98760, 98769, 98778, 98795, 98797, 98818, 98819, 98867, 98882, 98883, 98884, 98885, 98915, 98916, 98935, 98943, 98955, 98956, 98967, 98968, 99033, 99034, 99035, 99036, 99037, 99068, 99069, 99070, 99071, 99072, 99083, 99084, 99106, 99107, 99108, 99118, 99119, 99125, 99126, 99127, 99138, 99227, 99228, 99229, 99245, 99246, 99249, 99250, 99271, 99283, 99287, 99288, 99289, 99290, 99293, 99294, 99295, 99296, 99330, 99331, 99332, 99333, 99334, 99335, 99449, 99495, 99502, 99503, 99504, 99506, 99551, 99624, 99625, 99626, 99627, 99629, 99630, 99631, 99632, 99633, 99634, 99635, 99636, 99637, 99638, 99639, 99640, 99671, 99680, 99681, 99682, 99710) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 32 | 32 | 32 | 8 | 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 (6272, 6272, 6273, 6273, 6274, 6274, 34832, 34832, 34833, 34833, 34834, 34834, 34837, 34837, 34865, 34866, 34907, 34908, 34909, 35018, 35026, 35026, 35027, 35027, 35059, 35059, 35105, 35162, 35163, 35164, 35166, 35167, 35169, 35170, 35178, 35179, 35180, 35188, 35189, 35190, 35191, 35192, 35193, 35198, 35209, 35210, 35230, 35231, 35232, 35233, 35243, 35244, 35245, 35252, 35254, 35255, 35260, 35261, 35262, 35263, 35264, 35269, 35270, 35271, 35274, 35286, 35287, 35288, 35289, 35292, 35292, 35293, 35294, 35295, 35296, 35297, 35298, 35301, 35301, 35302, 35303, 35304, 35305, 35306, 35307, 35310, 35310, 35311, 35312, 35326, 35328, 35343, 35343, 35387, 35388, 35389, 35562, 35564, 35568, 35569, 35572, 35574, 35574, 35576, 35577, 35578, 35578, 35579, 35579, 35593, 35596, 36308, 36308, 44664, 44664, 44678, 44678, 44682, 44683, 44685, 44689, 44693, 44694, 44696, 44698, 44699, 44700, 44701, 44702, 44703, 44707, 44708, 44709, 44785, 44786, 44787, 44788, 45144, 45144, 45516, 45516, 45518, 45518, 45522, 45529, 45529, 45539, 45539, 54042, 54043, 54046, 54049, 54049, 54050, 54050, 54051, 54051, 54053, 54053, 54056, 54057, 54058, 54060, 57730, 57731, 57732, 57733, 57746, 57747, 57748, 57765, 58132, 58132, 58134, 58134, 58136, 58136, 58141, 58141, 58142, 58142, 58143, 58143, 58222, 58227, 58229, 58230, 58231, 58231, 58232, 58233, 58234, 58235, 58236, 58344, 58345, 58345, 58347, 58348, 58348, 58349, 58349, 58350, 58350, 58354, 58354, 58355, 58355, 58369, 58370, 58371, 58372, 64443, 64443, 64549, 64550, 64595, 64596, 64597, 64622, 64623, 64624, 64646, 64647, 64648, 64649, 64651, 64652, 64654, 64656, 64657, 64658, 64659, 64660, 64661, 64662, 64663, 64664, 64665, 64666, 64670, 64670, 64671, 64671, 64672, 64672, 64673, 64674, 64676, 64681, 64682, 64683, 65204, 65209, 65209, 65233, 65234, 65238, 65251, 65252, 65261, 65263, 65263, 65264, 65264, 65267, 65267, 65268, 65268, 65269, 65270, 65271, 65271, 65272, 65272, 65273, 65273, 65274, 65276, 65276, 65277, 65277, 65278, 65280, 65280, 65282, 65282, 65295, 65296, 65297, 65297, 65298, 65309, 65309, 65313, 65313, 65340, 65340, 65351, 65352, 65353, 65353, 65358, 65359, 65360, 65360, 65361, 65363, 65364, 65364, 65365, 65366, 65373, 65374, 71525, 71526, 71777, 71778, 71780, 72448, 72448, 72479, 72480, 73613, 73614, 73683, 73684, 73686, 73687, 73691, 73691, 73692, 73693, 73695, 73696, 73697, 73697, 73767, 73768, 73769, 73770, 73771, 73772, 73773, 73774, 73775, 73776, 73776, 73776, 73777, 73777, 73777, 73780, 73780, 73780, 73818, 73820, 73830, 73832, 73833, 73834, 73835, 73836, 73837, 73838, 73842, 73845, 73845, 73847, 73848, 73850, 73851, 73852, 73853, 73856, 73857, 73860, 73861, 74211, 74225, 74239, 74284, 74284, 74285, 74285, 74286, 74286, 74291, 74291, 74292, 74292, 74297, 74297, 74298, 74299, 74300, 74301, 74302, 74303, 74304, 74305, 74306, 74307, 74308, 74309, 74310, 74311, 74351, 74445, 74445, 77053, 77075, 77142, 77143, 77144, 77145, 77146, 77147, 77148, 77149, 77150, 77151, 77152, 77162, 77163, 77164, 77165, 77166, 77166, 77167, 77167, 77169, 77169, 77186, 77188, 77191, 77191, 77202, 77203, 77219, 77220, 77225, 77225, 77590, 77590, 77616, 77616, 77617, 77617, 77642, 77642, 77643, 77643, 77644, 77644, 77645, 77646, 77647, 77648, 77649, 77650, 77651, 77652, 77653, 77654, 77654, 77655, 77655, 77658, 77658, 77660, 77660, 77705, 77705, 77707, 77708, 77710, 77710, 77712, 77713, 77714, 77717, 77718, 77719, 77722, 77723, 77724, 77733, 77733, 77736, 77736, 77743, 77743, 78124, 79302, 79423, 79460, 80540, 80540, 80609, 80609, 80610, 80610, 80611, 80611, 80646, 80646, 80648, 80649, 80650, 80651, 80652, 80653, 80654, 80656, 80657, 80658, 80659, 80660, 80661, 80662, 80663, 80664, 80665, 80666, 80666, 80667, 80667, 80669, 80670, 80671, 80673, 80673, 80674, 80674, 80676, 80676, 80677, 80677, 80678, 80679, 80680, 80681, 80682, 80683, 80684, 80686, 80687, 80688, 80704, 80704, 80709, 80709, 80710, 80710, 80711, 80711, 80712, 80712, 80713, 80713, 80714, 80714, 80715, 80715, 80717, 80717, 80718, 80718, 80719, 80720, 80760, 80761, 80762, 80764, 80765, 80766, 80768, 80769, 80770, 80779, 80781, 80782, 80784, 80784, 80785, 80786, 80787, 80790, 80790, 80791, 80792, 80795, 80796, 80798, 80799, 80800, 80800, 80803, 80803, 81526, 81527, 81528, 81528, 81529, 81530, 81530, 81532, 81532, 81533, 81533, 81534, 81535, 81537, 81538, 81539, 81540, 81540, 81541, 81541, 81542, 81542, 81543, 81543, 81544, 81544, 81545, 81545, 81546, 81546, 81547, 81548, 81549, 81550, 81551, 81552, 81553, 81554, 81555, 81556, 81558, 81569, 81569, 81570, 81570, 81572, 81572, 81573, 81574, 81577, 81578, 81578, 81579, 81580, 81581, 81582, 81585, 81586, 81587, 81590, 81590, 81591, 81591, 81592, 81592, 81593, 81593, 81594, 81594, 81595, 81596, 81597, 81598, 81599, 81600, 81601, 81602, 81603, 81604, 81605, 81606, 81607, 81608, 81609, 81610, 81611, 81612, 81613, 81613, 81614, 81614, 81615, 81615, 81616, 81616, 81621, 81621, 81622, 81622, 81623, 81623, 81624, 81625, 81626, 81628, 81629, 81630, 81631, 81632, 81633, 81634, 81635, 81636, 81645, 81721, 82963, 82968, 82969, 83752, 83753, 83754, 83754, 83755, 83755, 83756, 83756, 83757, 83757, 83757, 83758, 83758, 83758, 83759, 83759, 83759, 83767, 83770, 83771, 83771, 83780, 83781, 83782, 83783, 83784, 83785, 83832, 83833, 83834, 83834, 83835, 83836, 83837, 83838, 83839, 83840, 83841, 83842, 83843, 83844, 83845, 83846, 83851, 83852, 83853, 83854, 83855, 83855, 83859, 83860, 83861, 83862, 83863, 83864, 83865, 83866, 83867, 83868, 83873, 83874, 83875, 83879, 83881, 83885, 83886, 83888, 83889, 83890, 83891, 83892, 83892, 83893, 83894, 83896, 83897, 83898, 83898, 83899, 83899, 83900, 83902, 83903, 83904, 83905, 83906, 83907, 83908, 83909, 84151, 84422, 84422, 84423, 84423, 84424, 84424, 84425, 84425, 84427, 84427, 84428, 84428, 84429, 84429, 84442, 84443, 84444, 84445, 84446, 84446, 84447, 84447, 84448, 84448, 84449, 84449, 84450, 84451, 84452, 84453, 84454, 84455, 84456, 84457, 84458, 84459, 84460, 84461, 84462, 84463, 84464, 84465, 84466, 84467, 84468, 84469, 84470, 84471, 84506, 84507, 84508, 84509, 84510, 84511, 84512, 84513, 84514, 84515, 84516, 84519, 84520, 84546, 84546, 84547, 84547, 84550, 84551, 84552, 84553, 84554, 84555, 84556, 84557, 84558, 84559, 84560, 84561, 84562, 84563, 84564, 84565, 84566, 84567, 84569, 84569, 84570, 84570, 84571, 84571, 84572, 84573, 84574, 84576, 84576, 84577, 84577, 84578, 84578, 84579, 84579, 84580, 84580, 84581, 84582, 84583, 84584, 84584, 84585, 84585, 84590, 84590, 84590, 84596, 84596, 84597, 84597, 84598, 84598, 84599, 84599, 84601, 84601, 84603, 84603, 84604, 84604, 84606, 84606, 84607, 84607, 84608, 84609, 84610, 84611, 84612, 84613, 84616, 84618, 84620, 84622, 84987, 84988, 84990, 84991, 84992, 84993, 84994, 84995, 84996, 84997, 85002, 85003, 85014, 85014, 85014, 85015, 85015, 85016, 85016, 85018, 85018, 85019, 85020, 85021, 85022, 85023, 85024, 85025, 85026, 85027, 85028, 85029, 85030, 85031, 85032, 85033, 85034, 85035, 85036, 85037, 85039, 85039, 85040, 85040, 85041, 85041, 85042, 85043, 85044, 85045, 85046, 85046, 85047, 85048, 85049, 85050, 85051, 85052, 85053, 85062, 85063, 85064, 85064, 85065, 85065, 85066, 85067, 85068, 85069, 85069, 85070, 85070, 85071, 85071, 85072, 85073, 85074, 85075, 85076, 85077, 85078, 85079, 85080, 85081, 85082, 85083, 85084, 85085, 85086, 85087, 85088, 85089, 85090, 85091, 85091, 85092, 85092, 85093, 85093, 85094, 85094, 85104, 85104, 85105, 85105, 85106, 85106, 85107, 85107, 85108, 85108, 85109, 85110, 85111, 85112, 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, 85160, 85161, 85162, 85175, 85175, 85212, 85213, 85214, 85214, 85215, 85215, 85216, 85217, 85445, 85491, 85534, 85535, 85536, 85537, 85538, 85539, 85540, 85541, 85632, 85632, 85633, 85633, 85634, 85634, 85635, 85635, 85636, 85637, 85638, 85639, 85640, 85641, 85647, 85647, 85658, 85662, 85663, 85664, 85664, 85665, 85665, 85666, 85667, 85668, 85669, 85670, 85671, 85672, 85673, 85674, 85675, 85676, 85677, 85678, 85679, 85680, 85681, 85682, 85683, 85684, 85684, 85685, 85685, 85685, 86017, 86028, 86029, 86030, 86031, 86032, 86033, 86034, 86035, 86036, 86037, 86096, 86110, 86932, 86969, 86970, 87014, 87303, 87303, 87304, 87304, 87305, 87305, 87306, 87306, 87307, 87307, 87308, 87308, 87309, 87309, 87310, 87310, 87311, 87311, 87312, 87312, 87313, 87313, 87317, 87317, 87318, 87318, 87319, 87320, 87321, 87322, 87323, 87323, 87324, 87324, 87325, 87325, 87326, 87326, 87327, 87328, 87329, 87330, 87331, 87332, 87332, 87333, 87333, 87334, 87334, 87335, 87335, 87336, 87336, 87337, 87337, 87337, 87338, 87338, 87338, 87339, 87339, 87339, 87340, 87340, 87340, 87341, 87341, 87341, 87342, 87343, 87344, 87345, 87346, 87347, 87348, 87349, 87350, 87351, 87353, 87353, 87354, 87354, 87357, 87357, 87358, 87358, 87359, 87359, 87360, 87360, 87362, 87362, 87362, 87364, 87364, 87365, 87365, 87366, 87366, 87367, 87367, 87368, 87368, 87369, 87369, 87370, 87370, 87371, 87372, 87373, 87385, 87385, 87386, 87386, 87387, 87387, 87388, 87389, 87390, 87391, 87391, 87392, 87392, 87393, 87393, 87394, 87395, 87396, 87397, 87398, 87399, 87403, 87404, 87405, 87406, 87664, 87665, 87853, 87854, 87855, 87855, 87856, 87856, 87857, 87858, 87859, 87860, 87860, 87861, 87861, 87862, 87862, 87863, 87863, 87864, 87864, 87865, 87865, 87866, 87866, 87867, 87867, 87868, 87868, 87869, 87869, 87870, 87870, 87871, 87871, 87872, 87872, 87873, 87873, 87874, 87875, 87876, 87877, 87878, 87879, 87880, 87881, 87882, 87883, 87884, 87885, 87886, 87886, 87886, 87887, 87887, 87887, 87888, 87888, 87888, 87889, 87889, 87889, 87890, 87891, 87906, 87907, 87908, 87942, 87942, 87942, 87943, 87943, 87943, 87944, 87944, 87944, 87945, 87945, 87945, 87946, 87946, 87947, 87947, 87948, 87948, 87949, 87949, 87950, 87950, 88157, 88158, 88159, 88176, 88177, 88178, 88179, 88180, 88181, 88181, 88182, 88182, 88183, 88183, 88184, 88184, 88185, 88185, 88186, 88186, 88187, 88187, 88188, 88188, 88189, 88189, 88190, 88190, 88192, 88193, 88194, 88195, 88196, 88197, 88198, 88199, 88200, 88201, 88202, 88203, 88211, 88212, 88213, 88214, 88215, 88228, 88228, 88229, 88229, 88239, 88240, 88241, 88242, 88243, 88244, 88245, 88246, 88283, 88283, 88453, 88454, 88455, 88540, 88594, 88595, 89171, 89171, 89295, 89578, 90370, 90371, 90372, 90373, 90374, 90375, 90376, 90377, 90378, 90379, 90380, 90381, 90382, 90383, 90384, 90385, 90386, 90387, 90388, 90389, 90390, 90391, 90397, 90397, 90398, 90399, 90416, 90417, 90429, 90429, 90430, 90430, 90433, 90434, 90435, 90436, 90437, 90438, 90439, 90440, 90441, 90442, 90443, 90456, 90456, 90685, 90686, 90687, 90688, 90689, 90689, 90690, 90690, 90691, 90692, 90693, 90694, 90703, 90704, 90705, 90706, 90707, 90708, 90717, 90718, 90719, 90720, 90721, 90722, 90758, 90759, 90760, 90761, 90762, 90763, 90815, 90816, 90817, 90818, 90819, 90820, 90821, 90822, 90823, 90824, 90825, 90826, 90827, 90828, 90829, 90830, 90831, 90832, 90833, 90834, 90835, 90836, 90837, 90838, 90839, 90840, 90841, 90842, 90843, 90844, 90845, 90846, 90847, 90848, 90849, 90850, 90851, 90852, 90853, 90854, 90855, 90856, 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, 90934, 90934, 90935, 90935, 90936, 90936, 90937, 90938, 90939, 90940, 90940, 90941, 90941, 90942, 90942, 90943, 90943, 90944, 90944, 90945, 90945, 90946, 90946, 90947, 90947, 90948, 90948, 90949, 90949, 90950, 90951, 90952, 90953, 90954, 90955, 91005, 91006, 91009, 91010, 91129, 91129, 91320, 91321, 91322, 91322, 91388, 91402, 91403, 91404, 91405, 91406, 91407, 91408, 91409, 91410, 91411, 91412, 91413, 91414, 91415, 91416, 91417, 91418, 91419, 91420, 91421, 91422, 91423, 91424, 91425, 91426, 91427, 91428, 91429, 91430, 91431, 91432, 91433, 91434, 91435, 91436, 91437, 91438, 91439, 91487, 91495, 91496, 91497, 91498, 91499, 91500, 91501, 91502, 91503, 91504, 91593, 91594, 91595, 91596, 91597, 91598, 91599, 91600, 91601, 91602, 91603, 91604, 91605, 91606, 91607, 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, 91634, 91635, 91636, 91637, 91638, 91639, 91640, 91641, 91642, 91679, 91679, 91680, 91680, 91681, 91681, 91682, 91682, 91683, 91683, 91684, 91684, 91685, 91685, 91686, 91686, 91687, 91687, 91688, 91688, 91689, 91689, 91690, 91690, 91691, 91691, 91692, 91692, 91693, 91693, 91694, 91694, 91695, 91695, 91696, 91696, 91697, 91697, 91698, 91698, 91699, 91699, 91700, 91700, 91701, 91701, 91702, 91702, 91703, 91703, 91704, 91704, 91705, 91705, 91706, 91706, 91707, 91707, 91708, 91708, 91709, 91709, 91710, 91710, 91711, 91711, 91712, 91712, 91713, 91713, 91714, 91714, 91715, 91715, 91716, 91716, 91720, 91744, 91745, 91785, 91835, 91839, 91840, 91841, 91891, 91948, 92286, 92389, 92390, 92391, 92395, 92396, 92397, 92471, 92513, 92514, 92515, 92516, 92747, 92749, 92771, 92804, 92820, 92829, 92904, 92905, 92906, 92907, 92991, 92995, 93185, 93280, 93284, 93319, 93346, 93347, 93348, 93359, 93492, 93534, 93536, 93539, 93543, 93544, 93545, 93547, 93548, 93549, 93550, 93551, 93591, 93631, 93636, 93768, 93769, 93770, 93771, 93772, 93789, 93790, 93791, 93792, 93793, 93794, 93982, 94037, 94287, 94288, 94289, 94296, 94297, 94298, 94299, 94300, 94301, 94302, 94303, 94304, 94305, 94306, 94307, 94308, 94309, 94310, 94311, 94319, 94319, 94339, 94352, 94375, 94375, 94376, 94376, 94377, 94377, 94378, 94378, 94379, 94379, 94380, 94380, 94381, 94382, 94383, 94384, 94385, 94386, 94387, 94388, 94389, 94390, 94391, 94392, 94393, 94394, 94395, 94396, 94397, 94398, 94427, 94427, 94427, 94428, 94428, 94428, 94431, 94431, 94432, 94432, 94433, 94433, 94434, 94434, 94435, 94435, 94455, 94456, 94457, 94458, 94459, 94460, 94461, 94462, 94463, 94464, 94465, 94466, 94467, 94468, 94469, 94470, 94471, 94472, 94473, 94474, 94475, 94476, 94477, 94478, 94479, 94480, 94481, 94482, 94483, 94484, 94485, 94486, 94487, 94488, 94489, 94490, 94491, 94492, 94522, 94523, 94524, 94525, 94526, 94527, 94528, 94529, 94530, 94531, 94532, 94533, 94534, 94535, 94536, 94537, 94538, 94539, 94540, 94541, 94542, 94543, 94544, 94545, 94555, 94556, 94557, 94558, 94562, 94571, 94572, 94573, 94574, 94575, 94576, 94577, 94578, 94579, 94580, 94581, 94582, 94583, 94584, 94585, 94586, 94587, 94588, 94589, 94590, 94591, 94592, 94593, 94594, 94595, 94595, 94596, 94596, 94597, 94597, 94600, 94600, 94601, 94601, 94603, 94603, 94604, 94604, 94607, 94608, 94609, 94610, 94611, 94612, 94677, 94678, 94679, 94680, 94681, 94682, 94683, 94684, 94685, 94703, 94704, 94705, 94706, 94707, 94708, 94709, 94710, 94711, 94712, 94713, 94714, 94715, 94716, 94717, 94718, 94719, 94720, 94721, 94722, 94723, 94724, 94761, 94812, 94842, 94846, 94866, 94868, 95052, 95053, 95054, 95055, 95056, 95057, 95058, 95059, 95060, 95061, 95062, 95063, 95120, 95122, 95123, 95124, 95125, 95126, 95127, 95128, 95129, 95171, 95173, 95175, 95177, 95180, 95205, 95206, 95207, 95208, 95209, 95210, 95211, 95212, 95213, 95214, 95215, 95216, 95217, 95218, 95219, 95220, 95221, 95222, 95223, 95224, 95225, 95226, 95227, 95228, 95229, 95230, 95231, 95232, 95233, 95234, 95235, 95236, 95247, 95248, 95249, 95250, 95251, 95252, 95253, 95254, 95255, 95256, 95257, 95258, 95259, 95260, 95261, 95262, 95263, 95264, 95265, 95266, 95267, 95268, 95269, 95270, 95271, 95272, 95273, 95274, 95362, 95363, 95367, 95390, 95411, 95412, 95413, 95414, 95429, 95430, 95431, 95434, 95435, 95436, 95437, 95462, 95463, 95464, 95465, 95466, 95467, 95468, 95469, 95470, 95471, 95472, 95473, 95474, 95475, 95476, 95477, 95478, 95479, 95480, 95481, 95482, 95483, 95484, 95485, 95486, 95487, 95488, 95489, 95490, 95491, 95492, 95493, 95494, 95495, 95496, 95497, 95498, 95499, 95500, 95501, 95502, 95503, 95504, 95505, 95506, 95507, 95508, 95509, 95512, 95513, 95514, 95515, 95516, 95517, 95518, 95519, 95520, 95521, 95522, 95523, 95524, 95525, 95526, 95527, 95528, 95529, 95598, 95599, 95600, 95601, 95611, 95614, 95618, 95619, 95620, 95662, 95663, 95664, 95665, 95666, 95667, 95668, 95669, 95670, 95671, 95672, 95673, 95674, 95675, 95676, 95677, 95678, 95679, 95680, 95681, 95682, 95683, 95712, 95713, 95714, 95715, 95716, 95717, 95718, 95719, 95720, 95721, 95722, 95723, 95724, 95725, 95726, 95727, 95728, 95729, 95730, 95731, 95732, 95733, 95734, 95735, 95736, 95737, 95738, 95791, 95792, 95793, 95799, 95851, 95898, 95899, 95939, 95944, 96194, 96195, 96196, 96333, 96334, 96335, 96356, 96387, 96388, 96389, 96390, 96410, 96411, 96412, 96413, 96419, 96420, 96421, 96430, 96445, 96448, 96529, 96538, 96539, 96540, 96542, 96543, 96561, 96567, 96577, 96639, 96660, 96661, 96664, 96667, 96684, 96719, 96731, 96767, 96771, 96772, 96781, 96782, 96783, 96812, 96813, 96818, 96819, 96829, 96830, 96833, 96834, 96835, 96836, 96843, 96846, 96852, 96853, 96854, 96855, 96856, 96872, 96949, 96950, 96951, 96968, 96978, 96979, 96980, 96981, 96999, 97026, 97034, 97035, 97038, 97041, 97053, 97057, 97058, 97115, 97146, 97147, 97148, 97161, 97165, 97177, 97203, 97204, 97205, 97220, 97221, 97222, 97223, 97224, 97225, 97296, 97297, 97366, 97366, 97378, 97620, 97621, 97622, 97763, 97764, 97765, 97766, 97767, 97768, 97769, 97770, 97771, 97772, 97773, 97774, 97775, 97776, 97777, 97778, 97779, 97780, 97781, 97782, 97783, 97792, 97798, 97827, 97845, 97846, 97847, 97848, 97849, 97850, 97851, 97852, 97853, 97854, 97855, 97856, 97857, 97858, 97859, 97860, 97861, 97862, 97863, 97864, 97865, 97866, 97867, 97868, 97869, 97870, 97871, 97872, 97873, 97874, 97875, 97876, 97877, 97878, 97879, 97880, 97881, 97882, 97883, 97884, 97885, 97886, 97887, 97888, 97889, 97890, 97891, 97892, 97893, 97894, 97895, 97896, 97897, 97898, 97899, 97900, 97901, 97902, 97903, 97904, 97905, 97906, 97907, 97908, 97909, 97910, 97911, 97912, 97913, 97914, 97915, 97916, 97917, 97918, 97919, 97920, 97921, 97922, 97923, 97923, 97924, 97924, 97925, 97925, 97926, 97926, 97927, 97927, 97928, 97928, 97929, 97930, 97931, 97932, 97933, 97934, 97935, 97936, 97937, 97938, 97939, 97940, 97941, 97942, 97943, 97943, 97944, 97944, 97945, 97945, 97946, 97946, 97947, 97948, 97949, 97950, 97951, 97952, 97953, 97954, 97955, 97956, 97957, 97958, 97959, 97960, 97961, 97962, 97963, 97964, 97965, 97966, 97967, 97968, 97969, 97970, 97971, 97972, 97973, 97974, 97975, 97976, 97977, 97978, 97979, 97980, 97981, 97982, 97983, 97984, 98021, 98022, 98023, 98024, 98025, 98026, 98027, 98028, 98029, 98030, 98031, 98032, 98033, 98034, 98035, 98036, 98037, 98038, 98039, 98040, 98041, 98070, 98071, 98072, 98073, 98074, 98075, 98076, 98077, 98078, 98129, 98130, 98131, 98137, 98529, 98530, 98531, 98532, 98593, 98594, 98595, 98596, 98597, 98598, 98599, 98600, 98601, 98602, 98603, 98604, 98605, 98606, 98607, 98608, 98609, 98610, 98611, 98612, 98613, 98614, 98615, 98616, 98617, 98618, 98619, 98620, 98628, 98639, 98649, 98658, 98659, 98660, 98661, 98667, 98687, 98688, 98689, 98708, 98731, 98732, 98733, 98734, 98736, 98737, 98760, 98769, 98778, 98795, 98797, 98818, 98819, 98867, 98882, 98883, 98884, 98885, 98915, 98916, 98935, 98943, 98955, 98956, 98967, 98968, 99033, 99034, 99035, 99036, 99037, 99068, 99069, 99070, 99071, 99072, 99083, 99084, 99106, 99107, 99108, 99118, 99119, 99125, 99126, 99127, 99138, 99227, 99228, 99229, 99245, 99246, 99249, 99250, 99271, 99283, 99287, 99288, 99289, 99290, 99293, 99294, 99295, 99296, 99330, 99331, 99332, 99333, 99334, 99335, 99449, 99495, 99502, 99503, 99504, 99506, 99551, 99624, 99625, 99626, 99627, 99629, 99630, 99631, 99632, 99633, 99634, 99635, 99636, 99637, 99638, 99639, 99640, 99671, 99680, 99681, 99682, 99710) AND `item_rank` <> 3 | 1 | 1 | 6 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94558) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-298844'))))) OR (((`item_id2` = 94558) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-298844'))))) OR (((`item_id3` = 94558) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-298844')))))) 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` = 94558 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
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 | 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` = 98529 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
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` = 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` = 95429) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1318-044'))))) OR (((`item_id2` = 95429) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1318-044'))))) OR (((`item_id3` = 95429) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1318-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` = 95429 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91680) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1233-028'))))) OR (((`item_id2` = 91680) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1233-028'))))) OR (((`item_id3` = 91680) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1233-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` = 91680 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 65353) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0435-043'))))) OR (((`item_id2` = 65353) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0435-043'))))) OR (((`item_id3` = 65353) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0435-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` = 65353 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95362) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2325070'))))) OR (((`item_id2` = 95362) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2325070'))))) OR (((`item_id3` = 95362) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2325070')))))) 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` = 95362 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 35170) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0105-009'))))) OR (((`item_id2` = 35170) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0105-009'))))) OR (((`item_id3` = 35170) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0105-009')))))) 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` = 35170 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 35169) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0105-008'))))) OR (((`item_id2` = 35169) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0105-008'))))) OR (((`item_id3` = 35169) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0105-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` = 35169 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92995) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2535G5'))))) OR (((`item_id2` = 92995) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2535G5'))))) OR (((`item_id3` = 92995) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2535G5')))))) 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` = 92995 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84454) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1005-028'))))) OR (((`item_id2` = 84454) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1005-028'))))) OR (((`item_id3` = 84454) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1005-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` = 84454 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 81609) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0962-028'))))) OR (((`item_id2` = 81609) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0962-028'))))) OR (((`item_id3` = 81609) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0962-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` = 81609 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 35166) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0102-008'))))) OR (((`item_id2` = 35166) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0102-008'))))) OR (((`item_id3` = 35166) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0102-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` = 35166 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90703) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1187-028'))))) OR (((`item_id2` = 90703) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1187-028'))))) OR (((`item_id3` = 90703) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1187-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` = 90703 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 81625) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0952-009'))))) OR (((`item_id2` = 81625) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0952-009'))))) OR (((`item_id3` = 81625) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0952-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` = 81625 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95233) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1300-008'))))) OR (((`item_id2` = 95233) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1300-008'))))) OR (((`item_id3` = 95233) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1300-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` = 95233 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` = 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` = 83844) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0990-006'))))) OR (((`item_id2` = 83844) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0990-006'))))) OR (((`item_id3` = 83844) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0990-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` = 83844 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92516) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25277G9D'))))) OR (((`item_id2` = 92516) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25277G9D'))))) OR (((`item_id3` = 92516) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25277G9D')))))) 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` = 92516 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 64665) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0737-009'))))) OR (((`item_id2` = 64665) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0737-009'))))) OR (((`item_id3` = 64665) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0737-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` = 64665 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
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 | 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` = 97378 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98594) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1366-008'))))) OR (((`item_id2` = 98594) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1366-008'))))) OR (((`item_id3` = 98594) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1366-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` = 98594 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98609) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1369-006'))))) OR (((`item_id2` = 98609) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1369-006'))))) OR (((`item_id3` = 98609) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1369-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` = 98609 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 57748) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0301-006'))))) OR (((`item_id2` = 57748) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0301-006'))))) OR (((`item_id3` = 57748) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0301-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` = 57748 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98593) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1366-006'))))) OR (((`item_id2` = 98593) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1366-006'))))) OR (((`item_id3` = 98593) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1366-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` = 98593 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` = 84580) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1023-009'))))) OR (((`item_id2` = 84580) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1023-009'))))) OR (((`item_id3` = 84580) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1023-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` = 84580 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 84547) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1038-002'))))) OR (((`item_id2` = 84547) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1038-002'))))) OR (((`item_id3` = 84547) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1038-002')))))) 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` = 84547 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` = 98607) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1368-011'))))) OR (((`item_id2` = 98607) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1368-011'))))) OR (((`item_id3` = 98607) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1368-011')))))) 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` = 98607 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 |
Peak Memory Use 10.93 MB
Message | Memory use |
---|---|
Component initialization | 3.68 MB |
Controller action start | 5.12 MB |
Controller render start | 6.12 MB |
View render complete | 7.85 MB |
Total Request Time: 1138 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 621.96 | |
Event: Controller.initialize | 16.06 | |
Event: Controller.startup | 0.44 | |
Controller action | 446.81 | |
Event: Controller.beforeRender | 5.37 | |
» Processing toolbar data | 5.30 | |
Rendering View | 19.74 | |
» Event: View.beforeRender | 0.02 | |
» Rendering APP/View/Items/searchpicture.ctp | 19.14 | |
» » Rendering APP/View/Elements/Head_menu.ctp | 0.06 | |
» » Rendering APP/View/Elements/Head_txt.ctp | 0.05 | |
» » Rendering APP/View/Elements/picturelist.ctp | 12.57 | |
» » » Rendering APP/View/Elements/price.ctp | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #2 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #2 | 0.08 | |
» » » Rendering APP/View/Elements/price.ctp #3 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #3 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #4 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #4 | 0.08 | |
» » » Rendering APP/View/Elements/price.ctp #5 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #5 | 0.08 | |
» » » Rendering APP/View/Elements/price.ctp #6 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #6 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #7 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #7 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #8 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #8 | 0.08 | |
» » » Rendering APP/View/Elements/price.ctp #9 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #9 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #10 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #10 | 0.08 | |
» » » Rendering APP/View/Elements/price.ctp #11 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #11 | 0.08 | |
» » » Rendering APP/View/Elements/price.ctp #12 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #12 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #13 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #13 | 0.08 | |
» » » Rendering APP/View/Elements/price.ctp #14 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #14 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #15 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #15 | 0.08 | |
» » » Rendering APP/View/Elements/price.ctp #16 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #16 | 0.08 | |
» » » Rendering APP/View/Elements/price.ctp #17 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #17 | 0.08 | |
» » » Rendering APP/View/Elements/price.ctp #18 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #18 | 0.08 | |
» » » Rendering APP/View/Elements/price.ctp #19 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #19 | 0.08 | |
» » » Rendering APP/View/Elements/price.ctp #20 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #20 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #21 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #21 | 0.08 | |
» » » Rendering APP/View/Elements/price.ctp #22 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #22 | 0.08 | |
» » » Rendering APP/View/Elements/price.ctp #23 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #23 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #24 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #24 | 0.08 | |
» » » Rendering APP/View/Elements/price.ctp #25 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #25 | 0.10 | |
» » » Rendering APP/View/Elements/price.ctp #26 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #26 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #27 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #27 | 0.08 | |
» » » Rendering APP/View/Elements/price.ctp #28 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #28 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #29 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #29 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #30 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #30 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #31 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #31 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #32 | 0.08 | |
» » » Rendering APP/View/Elements/icon_set.ctp #32 | 0.09 | |
» » Rendering APP/View/Elements/icon.ctp | 0.06 | |
» » Rendering APP/View/Elements/prlink.ctp | 0.52 | |
» » Rendering APP/View/Elements/Area_left.ctp | 3.16 | |
» » » Rendering APP/View/Elements/serchlink.ctp | 1.26 | |
» » » Rendering APP/View/Elements/speciallink.ctp | 0.12 | |
» » » Rendering APP/View/Elements/pricelink.ctp | 0.45 | |
» » » Rendering APP/View/Elements/cataloglink.ctp | 0.05 | |
» » Rendering APP/View/Elements/footlink.ctp | 0.27 | |
» » Rendering APP/View/Elements/Analyticslink.ctp | 0.05 | |
» Event: View.afterRender | 0.01 | |
» Event: View.beforeLayout | 0.01 | |
» Rendering APP/View/Layouts/default.ctp | 0.06 | |
Event: View.afterLayout | 0.00 |
Constant | Value |
---|---|
CAKEPHP2_HOST_NAME_REGEX | (?:[_\p{L}0-9][-_\p{L}0-9]*\.)*(?:[\p{L}0-9][-\p{L}0-9]{0,62})\.(?:(?:[a-z]{2}\.)?[a-z]{2,}) |
CAKEPHP2_EMAIL_REGEX | /^[\p{L}0-9!#$%&'*+\/=?^_`{|}~-]+(?:\.[\p{L}0-9!#$%&'*+\/=?^_`{|}~-]+)*@(?:[_\p{L}0-9][-_\p{L}0-9]*\.)*(?:[\p{L}0-9][-\p{L}0-9]{0,62})\.(?:(?:[a-z]{2}\.)?[a-z]{2,})$/ui |
USER_AGENT_TYPE_DEFAULT | 1 |
USER_AGENT_TYPE_SMART_PHONE | 2 |
QUERY_NAME_VIEW_MODE | viewmode |
VIEW_MODE_DEFAULT | 1 |
VIEW_MODE_SMART_PHONE | 2 |
STATUS_NO | 0 |
STATUS_OK | 2 |
STATUS_PROCESS | 1 |
LISTBYCATEGORY_SEARCH_RANK_TYPE_ALL | 1 |
LISTBYCATEGORY_SEARCH_RANK_TYPE_EXCLUDE_HIDE | 2 |
LISTBYCATEGORY_SEARCH_RANK_TYPE_HIDE_ONLY | 3 |
CAMPAIGNS_ADD_DISCOUNT_TYPE_2 | 2 |
CAMPAIGNS_ADD_DISCOUNT_TYPE_1 | 1 |
CAMPAIGNS_ADD_DISCOUNT_TYPE_DEFAULT | 0 |
ESTIMATE_EXPIRATION_TYPE_30_DAYS | 1 |
ESTIMATE_EXPIRATION_TYPE_60_DAYS | 2 |
ESTIMATE_EXPIRATION_TYPE_90_DAYS | 3 |
ESTIMATE_DELIVERY_LOCATION_TYPE_1 | 1 |
ESTIMATE_DELIVERY_LOCATION_TYPE_2 | 2 |
ESTIMATE_DELIVERY_LOCATION_TYPE_3 | 3 |
ESTIMATE_PAYMENT_TYPE_BANK_SAKI | 1 |
ESTIMATE_PAYMENT_TYPE_BANK_ATO | 2 |
ESTIMATE_PAYMENT_TYPE_BANK | 3 |
ESTIMATE_PAYMENT_TYPE_CASH_ON_DELIVERY | 4 |
ESTIMATE_PAYMENT_TYPE_CREDIT | 5 |
HANKAN_SUBJECT | 販促ノベルティ卸売りセンター |
RECOMMENDED_ITEMS | 8 |
NEW_ARRIVAL_ITEMS | 7 |
CAMPAIGN_ITEMS | 8 |
TEXTCAMPAIGN_ITEMS | 7 |
REPORT_ITEMS | 6 |
ITEMS_SHOW_WIDTH_LIMIT | 4 |
ITEMS_SHOW_WIDTH_LIMIT2 | 4 |
WATCHLIST_ITEMS | 4 |
WATCHLIST_ITEMS2 | 8 |
WATCHLIST_RANK_CONDITION_TYPE | 1 |
WATCHLIST_RANK_CONDITION_TYPE2 | 3 |
GALLARY_RANDOM_ITEMS | 4 |
ITEM_PICS_EXT | .jpg |
WHOLESALE_PRICE_NULL | お見積り |
CANPAIGN_PRICE_NULL | 特価 |
ITEM | item |
ESTIMATE_PDF | estimate_pdf |
IMG_SEARCH_PATH | /var/www/vhosts/test.pqnavi.com/httpdocs/app/webroot/img/item/ |
REPORT_SEARCH_PATH | /var/www/vhosts/test.pqnavi.com/httpdocs/app/webroot/img/report/ |
REPORT | /img/report |
SENDMAIL_PATH | /user/sbin/sendmail |
URL_ROOT | http://test.pqnavi.com |
ZIP_SEARCH_PATH | /var/www/vhosts/test.pqnavi.com/httpdocs/app/tmp/unzip/ |
UNZIP | /usr/bin/unzip |
HTMLMAIL_SIGNATURE_PC | [特別企画] <特急7営業日> 名入れスピード印刷、お急ぎのお客様はご相談を <新着レビュー> 既にご利用になったお客様からの声をご紹介 <SALE品 在庫売切廃盤> 約200商品が追加され更に充実、益々お得 無料サンプル差し上げます!ボールペン・付箋・ウェットティッシュ ━━━━━━━━━━━━━━━━━━━━━━━ 販促ノベルティ卸売りセンター http://www.pqnavi.com/ http://www.twitter.com/pqnavi http://www.facebook.com/pqnavicom ━━━━━━━━━━━━━━━━━━━━━━━ 電子POP卸売りモニター http://www.seasonsolution.jp/pop/ …………………………………………………… 文房具名入れ館 http://www.ccq.jp/ …………………………………………………… エコバッグ制作センター http://www.psps.jp/ …………………………………………………… 販促支援のシーズンソリューション株式会社 http://www.seasonsolution.jp/ 横浜市都筑区茅ヶ崎中央42-21第2佐藤ビル4F TEL:045-949-2557 FAX:045-949-4626 |
EMAIL_SIGNATURE_PC | [特集] <特急7営業日> 名入れスピード印刷、お急ぎのお客様はご相談を http://www.pqnavi.com/items/search?key=スピード印刷 <新着レビュー> 既にご利用になったお客様からの声をご紹介 http://www.pqnavi.com/questionnaires/newlist <SALE品 在庫売切廃盤> 約200商品が追加され更に充実、益々お得 http://www.pqnavi.com/items/categorylist/category_id:36 無料サンプル差し上げます!ボールペン・付箋・ウェットティッシュ http://www.pqnavi.com/reports/view/939 ━━━━━━━━━━━━━━━━━━━━━━━ 販促ノベルティ卸売りセンター http://www.pqnavi.com/ http://www.twitter.com/pqnavi http://www.facebook.com/pqnavicom ━━━━━━━━━━━━━━━━━━━━━━━ 電子POP卸売りセンター http://www.seasonsolution.jp/pop/ …………………………………………………… 文房具名入れ館 http://www.ccq.jp/ …………………………………………………… エコバッグ制作センター http://www.psps.jp/ …………………………………………………… 販促支援のシーズンソリューション株式会社 http://www.seasonsolution.jp/ 横浜市都筑区茅ヶ崎中央42-21第2佐藤ビル4F TEL:045-949-2557 FAX:045-949-4626 |
EMAIL_DOMAIN | localhost |
EMAIL_BCC_ADMIN | fujita@pqnavi.com |
EMAIL_FROM | fujita@pqnavi.com |
EMAIL_FROM_NAME | 販促ノベルティ卸売りセンター |
EMAIL_ESTIMATE_REGIST_SUBJ | [販促ノベルティ卸売りセンター]お見積り依頼 |
EMAIL_SAMPLE_REGIST_SUBJ | [販促ノベルティ卸売りセンター]有料サンプル請求 |
EMAIL_CATALOG_REGIST_SUBJ | [販促ノベルティ卸売りセンター]カタログ請求 |
EMAIL_ESTIMATE_ALL_SUBJ | [販促ノベルティ卸売りセンター]お見積書のお届け |
EMAIL_CLEARFILE_SUBJ | [販促ノベルティ卸売りセンター]お見積り依頼(A4クリアファイル) |
EMAIL_OTOIAWASE_SUBJ | [販促ノベルティ卸売りセンター]お問合わせ |
EMAIL_ESTIMATE_REGIST_SUBJ_ORDER | [販促ノベルティ卸売りセンター]ご注文完了 |
REPORT_BACKNUMBER_LIMIT | 20 |
REPORT_BACKNUMBER_SMART_PHONE_LIMIT | 30 |
USER_LINES_LIMIT | 15 |
USER_SMART_PHONE_LINES_LIMIT | 20 |
ADMIN_LINES_LIMIT | 30 |
ITEMS_SHOW_WIDTH_LIMIT_PICTURE | 4 |
ITEMS_SHOW_HEIGHT_LIMIT_PICTURE | 8 |
LIST_MODE | 1 |
PICTURE_MODE | 0 |
GALLERY_BACKNUMBER_LIMIT | 15 |
GALLARY_ITEMS | 6 |
GALLERY_BACKNUMBER_SMART_PHONE_LIMIT | 30 |
MAIL_RESERVATION_STATUS_WAIT | 1 |
MAIL_RESERVATION_STATUS_SENT | 2 |
MAIL_RESERVATION_STATUS_CANCEL | 3 |
MAIL_SEND_TYPE_TO | 1 |
MAIL_MAX_SEND_COUNT | 30 |
USE_MYSQL | 1 |
UPLOADDIR | /tmp |
EMAIL_QUESTIONNAIRE_SUBJ | [販促ノベルティ卸売りセンター]アンケートのお願い |
EMAIL_QUESTIONNAIRE170_SUBJ | [販促ノベルティ卸売りセンター] ニュースレター |
EMAIL_QUESTIONNAIRE350_SUBJ | [販促ノベルティ卸売りセンター] ニュースレター |
EMAIL_QUESTIONNAIRE710_SUBJ | [販促ノベルティ卸売りセンター] ニュースレター |
APP_NEWICON_SHOW_DAYS | 14 |
QUESTIONNAIRE_ITEMS | 5 |
QUESTIONNAIRE170_ITEMS | 12 |
QUESTIONNAIRE350_ITEMS | 16 |
QUESTIONNAIRE710_ITEMS | 20 |
MAIL_SEND_BY_SMTP | 0 |
RELATE_REPORT_COUNT | 7 |
MAIL_TEST_MAILTO | toyofuku@witinc.co.jp |
MAIL_TEST_MODE | 1 |
DBBACKUP_ON | 1 |
DBUPDATE_ON | ON |
SVNUPDATE_ON | ON |
SVN_CONFIG_DIR | /var/www/vhosts/.subversion/ |
SVN_USERNAME | season |
SVN_PASSWORD | wit150813 |
COOKIE_VIEW_PERIOD | +4 weeks |
RANDOM_CATEGORY | 25 |
Constant | Value |
---|---|
APP | /var/www/vhosts/test.pqnavi.com/httpdocs/app/ |
APP_DIR | app |
APPLIBS | /var/www/vhosts/test.pqnavi.com/httpdocs/app/Lib/ |
CACHE | /var/www/vhosts/test.pqnavi.com/httpdocs/app/tmp/cache/ |
CAKE | /var/www/vhosts/test.pqnavi.com/httpdocs/lib/Cake/ |
CAKE_CORE_INCLUDE_PATH | /var/www/vhosts/test.pqnavi.com/httpdocs/lib |
CORE_PATH | /var/www/vhosts/test.pqnavi.com/httpdocs/lib/ |
CAKE_VERSION | 2.8.4 |
CSS | /var/www/vhosts/test.pqnavi.com/httpdocs/app/webroot/css/ |
CSS_URL | css/ |
DS | / |
FULL_BASE_URL | http://test.pqnavi.com |
IMAGES | /var/www/vhosts/test.pqnavi.com/httpdocs/app/webroot/img/ |
IMAGES_URL | img/ |
JS | /var/www/vhosts/test.pqnavi.com/httpdocs/app/webroot/js/ |
JS_URL | js/ |
LOGS | /var/www/vhosts/test.pqnavi.com/httpdocs/app/tmp/logs/ |
ROOT | /var/www/vhosts/test.pqnavi.com/httpdocs |
TESTS | /var/www/vhosts/test.pqnavi.com/httpdocs/app/Test/ |
TMP | /var/www/vhosts/test.pqnavi.com/httpdocs/app/tmp/ |
VENDORS | /var/www/vhosts/test.pqnavi.com/httpdocs/vendors/ |
WEBROOT_DIR | webroot |
WWW_ROOT | /var/www/vhosts/test.pqnavi.com/httpdocs/app/webroot/ |
Environment Variable | Value |
---|---|
Php Version | 7.0.7 |
Redirect Redirect Status | 200 |
Redirect Status | 200 |
Http Accept | */* |
Http User Agent | Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Http Cookie | CAKEPHP=2v3imqd5slcgr7unahn4n07614; CakeCookie[mode]=Q2FrZQ%3D%3D.ig%3D%3D |
Http Accept Encoding | gzip, br, zstd, deflate |
Http Host | test.pqnavi.com |
Http Via | 1.1 squid-proxy-5b5d847c96-r2g5x (squid/6.10) |
Http X Forwarded For | 10.2.9.239 |
Http Cache Control | max-age=0 |
Http Connection | keep-alive |
Path | /sbin:/usr/sbin:/bin:/usr/bin |
Server Signature | <address>Apache/2.2.15 (CentOS) Server at test.pqnavi.com Port 80</address> |
Server Software | Apache/2.2.15 (CentOS) |
Server Name | test.pqnavi.com |
Server Addr | 153.120.157.97 |
Server Port | 80 |
Remote Addr | 216.73.216.98 |
Document Root | /var/www/vhosts/test.pqnavi.com/httpdocs |
Server Admin | wadmin@pqnavi.com |
Script Filename | /var/www/vhosts/test.pqnavi.com/httpdocs/app/webroot/index.php |
Remote Port | 17144 |
Redirect Query String | key=%5B%E6%8A%98%E3%82%8A%E3%81%9F%E3%81%9F%E3%81%BF%E5%82%98%5D+Mabu%E3%82%B9%E3%83%88%E3%83%AC%E3%83%B3%E3%82%B0%E3%82%B9%E3%83%9F%E3%83%8BAUTO+R |
Redirect Url | /app/webroot/items/search |
Gateway Interface | CGI/1.1 |
Server Protocol | HTTP/1.1 |
Request Method | GET |
Query String | key=%5B%E6%8A%98%E3%82%8A%E3%81%9F%E3%81%9F%E3%81%BF%E5%82%98%5D+Mabu%E3%82%B9%E3%83%88%E3%83%AC%E3%83%B3%E3%82%B0%E3%82%B9%E3%83%9F%E3%83%8BAUTO+R |
Request Uri | /items/search?key=%5B%E6%8A%98%E3%82%8A%E3%81%9F%E3%81%9F%E3%81%BF%E5%82%98%5D+Mabu%E3%82%B9%E3%83%88%E3%83%AC%E3%83%B3%E3%82%B0%E3%82%B9%E3%83%9F%E3%83%8BAUTO+R |
Script Name | /app/webroot/index.php |
Php Self | /app/webroot/index.php |
Request Time Float | 1755115493.802 |
Request Time | 1755115493 |