[名入れタオル] コットンWフェイス ハンドタオル 昇華転写対応 ホワイト 280円 ⇒ 140円 注文最小数量:400
|
1,880円 ⇒ 940円 注文最小数量:50
|
480円 ⇒ 240円 注文最小数量:30
|
1,980円 ⇒ 990円 注文最小数量:30
|
250円 ⇒ 100円 注文最小数量:100 |
130円 ⇒ 85円 注文最小数量:100 |
520円 ⇒ 260円 注文最小数量:50 |
[粗品(キッチン)] ミルクカートン再生キッチンペーパー ポリ入10W 50円 ⇒ 30円 注文最小数量:250
|
980円 ⇒ 注文最小数量:30
お得な値引は06月末日まで |
600円 ⇒ 188円 注文最小数量:100
|
660円 ⇒ 330円 注文最小数量:50
|
460円 ⇒ 注文最小数量:200
お得な値引は06月末日まで |
<アウトレット売切廃盤> [コスメポーチ] ユーティリティスクエアポーチ(S) ネイビーブルー 490円 ⇒ 150円 注文最小数量:200
|
1,020円 ⇒ 注文最小数量:60 お得な値引は06月末日まで |
320円 ⇒ 160円 注文最小数量:300
|
<アウトレット売切廃盤> [事務用品/オフィス用品] コンパクトブラシ&ダストパン ブラック 300円 ⇒ 75円 注文最小数量:50
|
<アウトレット売切廃盤> [事務用品/オフィス用品] コンパクトブラシ&ダストパン ホワイト 300円 ⇒ 75円 注文最小数量:50
|
250円 ⇒ 100円 注文最小数量:100 |
60円 ⇒ 30円 注文最小数量:1,000
|
850円 ⇒ 425円 注文最小数量:48
|
1,200円 ⇒ 399円 注文最小数量:96
|
100円 ⇒ 50円 注文最小数量:1,000
|
A4クリアファイル フルカラー両面印刷 (送料無料、印刷0円) 150円 ⇒ 99円 注文最小数量:1,000 |
480円 ⇒ 240円 注文最小数量:300
|
[アウトドア/レジャー] コンパクトスタジアムクッション グレー 580円 ⇒ 290円 注文最小数量:50
|
700円 ⇒ 350円 注文最小数量:280
|
[アウトドア/レジャー] コンパクトスタジアムクッション ブラック 580円 ⇒ 290円 注文最小数量:50
|
<アウトレット売切廃盤> 吸湿発熱ブランケット(巾着付) ブラック 1,750円 ⇒ 355円 注文最小数量:40
|
<アウトレット売切廃盤> クルリト デイリー巾着バッグ レッド 950円 ⇒ 274円 注文最小数量:100
|
オーガニックコットンキャンバスファスナーポーチ ナイトブラック 660円 ⇒ 注文最小数量:100
お得な値引は06月末日まで |
キャンプス 保冷温スタイルボトル600ml アソート/3色取混 2,300円 ⇒ 748円 注文最小数量:30
|
700円 ⇒ 350円 注文最小数量:280
|
[お探しの検索ワードはコチラですか?]
フォトスタンド | メタルペン | 造花 | リングノート | カードホルダー | スマホポーチ | 三菱鉛筆 | 粗品(保存容器) | 事務用品 | 手提げバッグ | AV機器 | キングジム [特集] 特急7営業日!名入れスピード印刷、お急ぎのお客様は諦めずにご相談ください [特集] 写真も綺麗に印刷!フルカラー対応ノベルティ インクジェット、昇華転写など |
後払い・送料0円・名入れデータ作成0円 |
|
名入れ!エコバッグ・マグカップ・ボトルなど |
|
冷やし中華、うどん、調味料。最短翌日出荷! |
|
オリジナルラベル対応!33円~送料無料 |
|
時節柄を問わない新アイテム 粗品・ご挨拶 |
|
お手頃で優しい風合い |
|
名入れ対応!非常用ライト・救急セットなど |
|
クリアファイル、ウェットティッシュ、付箋など |
|
ご相談下さい!名入れ印刷、特急7営業日 |
|
厚生労働省推進!思いやりグッズで好感度アップ |
|
注目!スタンド、チャージャー、ポーチ... |
|
写真も綺麗に印刷!フルカラー対応ノベルティ |
値引き商品 リスト|人気ランキング リスト|検索キーワード リスト|お取引について|名入れについて
販促レポート|名入れ制作事例|新着レビュー|オリジナルグッズ制作|会社案内|お問合せ
真面目にひた向きに、おかげ様で20周年
Copyright (C) 1998-2025 SeasonSolution All rights reserved.
No querystring data.
Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`category_sort_order`, `Category`.`words`, `Category`.`flg_hidden`, `Category`.`created`, `Category`.`modified` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`flg_hidden` = 0 ORDER BY `Category`.`category_sort_order` ASC | 38 | 38 | 0 | |
SELECT `Category`.`id`, `Category`.`words` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`flg_hidden` = 0 ORDER BY `Category`.`category_sort_order` ASC | 38 | 38 | 0 | |
SELECT `ItemsCategory`.`id`, `ItemsCategory`.`item_id` FROM `witinc_pqnavi_test`.`md_items_categories` AS `ItemsCategory` LEFT JOIN `witinc_pqnavi_test`.`md_items` AS `Item` ON (`ItemsCategory`.`item_id` = `Item`.`id`) WHERE ((`Item`.`item_code` Like '%フルカラー印刷%') OR (`Item`.`item_name` Like '%フルカラー印刷%') OR (`Item`.`item_figure` Like '%フルカラー印刷%') OR (`Item`.`item_color` Like '%フルカラー印刷%') OR (`Item`.`item_materials` Like '%フルカラー印刷%') OR (`Item`.`item_note` Like '%フルカラー印刷%')) AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 2912 | 2912 | 1 | |
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 (6516, 6775, 6776, 6778, 6778, 6779, 6779, 35192, 35209, 35260, 35261, 35263, 35625, 35626, 35651, 35652, 35699, 35760, 35760, 35764, 35764, 35783, 35783, 35785, 35785, 35786, 35786, 35787, 35788, 35788, 36242, 36243, 36244, 36245, 36246, 36770, 38489, 38489, 38504, 38504, 44760, 44760, 44781, 44781, 45127, 57684, 57684, 57685, 57685, 57686, 57686, 57687, 57687, 57688, 57688, 57706, 57707, 58128, 58129, 58130, 58131, 58324, 64622, 64623, 64624, 64686, 65278, 65329, 65331, 65331, 65337, 65338, 65338, 65358, 65366, 65373, 65374, 73557, 73734, 73734, 73737, 73737, 73747, 73747, 73781, 73781, 74424, 74424, 74427, 74428, 74432, 74439, 74440, 74445, 74445, 74446, 74450, 74753, 74753, 74753, 74754, 74754, 74754, 74787, 74788, 77040, 77041, 77042, 77043, 77044, 77045, 77046, 77048, 77049, 77050, 77051, 77052, 77053, 77054, 77055, 77056, 77057, 77058, 77059, 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, 77270, 77271, 77601, 77611, 77617, 77617, 77631, 77631, 77651, 77698, 77705, 77705, 77707, 77712, 77717, 77718, 77722, 78058, 78159, 80587, 80588, 80589, 80593, 80595, 80596, 80597, 80598, 80607, 80608, 80609, 80609, 80610, 80610, 80611, 80611, 80612, 80613, 80614, 80614, 80614, 80615, 80615, 80615, 80616, 80616, 80616, 80617, 80617, 80617, 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, 80729, 80730, 80734, 80735, 80736, 80737, 80760, 80761, 80762, 80764, 80765, 80766, 80768, 80769, 80770, 80779, 80781, 80782, 80784, 80784, 80791, 80792, 80795, 80796, 80798, 80799, 80800, 80800, 80803, 80803, 81471, 81471, 81472, 81472, 81473, 81474, 81474, 81506, 81506, 81509, 81509, 81510, 81510, 81511, 81512, 81513, 81514, 81515, 81516, 81517, 81518, 81520, 81521, 81521, 81522, 81522, 81523, 81523, 81524, 81524, 81552, 81553, 81554, 81555, 81556, 81558, 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, 81621, 81621, 81622, 81622, 81623, 81623, 81624, 81625, 81626, 81628, 81629, 81630, 81667, 81667, 81722, 81723, 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, 83787, 83788, 83789, 83790, 83791, 83792, 83792, 83793, 83800, 83801, 83802, 83812, 83813, 83814, 83814, 83815, 83815, 83818, 83819, 83820, 83821, 83822, 83823, 83824, 83825, 83826, 83827, 83832, 83833, 83834, 83834, 83835, 83836, 83837, 83838, 83839, 83840, 83841, 83842, 83843, 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, 83938, 83938, 84343, 84343, 84344, 84344, 84345, 84345, 84350, 84351, 84352, 84353, 84354, 84355, 84356, 84357, 84358, 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, 84476, 84477, 84478, 84479, 84480, 84480, 84481, 84481, 84482, 84482, 84483, 84483, 84488, 84489, 84490, 84491, 84492, 84492, 84517, 84518, 84524, 84525, 84526, 84546, 84546, 84547, 84547, 84550, 84551, 84552, 84553, 84557, 84558, 84559, 84560, 84569, 84569, 84570, 84570, 84571, 84571, 84576, 84576, 84577, 84577, 84578, 84578, 84579, 84579, 84580, 84580, 84581, 84582, 84583, 84584, 84584, 84585, 84585, 84590, 84590, 84590, 84591, 84592, 84593, 84593, 84594, 84594, 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, 85010, 85010, 85011, 85011, 85012, 85012, 85014, 85014, 85014, 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, 85163, 85164, 85165, 85166, 85167, 85168, 85169, 85170, 85170, 85171, 85171, 85172, 85172, 85175, 85175, 85178, 85178, 85179, 85179, 85180, 85180, 85181, 85181, 85182, 85182, 85183, 85183, 85184, 85184, 85185, 85185, 85186, 85186, 85187, 85187, 85188, 85188, 85202, 85208, 85208, 85209, 85209, 85212, 85213, 85214, 85214, 85215, 85215, 85216, 85217, 85218, 85219, 85220, 85220, 85222, 85223, 85226, 85259, 85260, 85261, 85262, 85263, 85264, 85265, 85266, 85275, 85276, 85277, 85288, 85290, 85342, 85398, 85534, 85535, 85536, 85537, 85538, 85539, 85540, 85541, 85632, 85632, 85633, 85633, 85634, 85634, 85635, 85635, 85636, 85637, 85638, 85639, 85640, 85641, 85642, 85643, 85644, 85645, 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, 85687, 85688, 85689, 85690, 85691, 85692, 85693, 85694, 85695, 85696, 85696, 85696, 85697, 85697, 85698, 85698, 85699, 85699, 85709, 85709, 85710, 85719, 85720, 85721, 85723, 85723, 85814, 85815, 86096, 86097, 86109, 86110, 87303, 87303, 87304, 87304, 87305, 87305, 87306, 87306, 87307, 87307, 87308, 87308, 87309, 87309, 87310, 87310, 87315, 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, 87362, 87362, 87362, 87364, 87364, 87374, 87374, 87375, 87375, 87376, 87377, 87383, 87383, 87384, 87384, 87391, 87391, 87392, 87392, 87393, 87393, 87398, 87399, 87400, 87401, 87402, 87407, 87408, 87450, 87844, 87845, 87852, 87853, 87854, 87855, 87855, 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, 87909, 87910, 87911, 87912, 87915, 87915, 87916, 87916, 87917, 87918, 87919, 87942, 87942, 87942, 87943, 87943, 87943, 87944, 87944, 87944, 87945, 87945, 87945, 87946, 87946, 87947, 87947, 87948, 87948, 87949, 87949, 87950, 87950, 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, 88206, 88207, 88208, 88208, 88208, 88209, 88209, 88210, 88210, 88211, 88212, 88213, 88214, 88215, 88219, 88220, 88221, 88222, 88223, 88225, 88227, 88228, 88228, 88229, 88229, 88239, 88240, 88241, 88242, 88243, 88244, 88245, 88246, 88249, 88250, 88251, 88252, 88253, 88254, 88396, 88537, 88537, 89286, 89316, 89456, 89456, 90368, 90369, 90370, 90371, 90372, 90373, 90374, 90375, 90376, 90377, 90378, 90379, 90380, 90381, 90382, 90383, 90384, 90385, 90386, 90387, 90388, 90389, 90390, 90391, 90392, 90393, 90394, 90397, 90397, 90398, 90399, 90402, 90403, 90404, 90405, 90406, 90407, 90411, 90412, 90413, 90414, 90414, 90415, 90415, 90416, 90417, 90418, 90418, 90419, 90419, 90420, 90420, 90421, 90421, 90422, 90422, 90423, 90423, 90424, 90424, 90425, 90425, 90426, 90426, 90427, 90428, 90429, 90429, 90430, 90430, 90431, 90432, 90436, 90437, 90438, 90439, 90450, 90674, 90675, 90676, 90677, 90678, 90679, 90680, 90681, 90689, 90689, 90690, 90690, 90691, 90692, 90693, 90694, 90695, 90696, 90697, 90698, 90699, 90700, 90701, 90702, 90703, 90704, 90705, 90706, 90707, 90708, 90709, 90710, 90711, 90712, 90713, 90714, 90715, 90716, 90717, 90718, 90719, 90720, 90721, 90722, 90723, 90724, 90725, 90726, 90727, 90728, 90729, 90730, 90731, 90732, 90733, 90734, 90735, 90736, 90737, 90747, 90748, 90749, 90750, 90750, 90750, 90751, 90751, 90751, 90752, 90752, 90752, 90753, 90753, 90753, 90758, 90759, 90760, 90761, 90762, 90763, 90767, 90768, 90769, 90770, 90771, 90771, 90772, 90773, 90774, 90775, 90776, 90777, 90778, 90779, 90780, 90781, 90782, 90783, 90784, 90785, 90786, 90787, 90788, 90789, 90790, 90791, 90792, 90793, 90794, 90795, 90796, 90797, 90798, 90799, 90800, 90801, 90802, 90803, 90804, 90805, 90806, 90807, 90808, 90809, 90810, 90811, 90812, 90813, 90814, 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, 90857, 90858, 90859, 90860, 90861, 90862, 90863, 90864, 90865, 90866, 90867, 90868, 90869, 90870, 90871, 90872, 90873, 90874, 90875, 90876, 90877, 90878, 90879, 90880, 90881, 90882, 90883, 90884, 90885, 90886, 90887, 90888, 90889, 90890, 90891, 90892, 90893, 90894, 90895, 90896, 90897, 90898, 90899, 90900, 90901, 90902, 90903, 90904, 90905, 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, 90950, 90951, 90952, 90953, 90954, 90955, 90956, 90957, 90958, 90959, 90960, 90961, 90962, 90963, 90964, 90965, 90966, 90967, 90968, 90969, 90970, 90971, 90992, 90993, 90996, 90997, 90998, 90999, 91000, 91001, 91001, 91002, 91003, 91003, 91003, 91004, 91004, 91004, 91005, 91006, 91009, 91010, 91011, 91012, 91013, 91022, 91023, 91024, 91025, 91026, 91028, 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, 91471, 91472, 91473, 91474, 91475, 91476, 91477, 91478, 91479, 91718, 91718, 91719, 91720, 91739, 91739, 91744, 91745, 92676, 92677, 92678, 92828, 93189, 93226, 93256, 93259, 93264, 93320, 93321, 93322, 93323, 93324, 93325, 93371, 93636, 93933, 93936, 93936, 93937, 93939, 93940, 93941, 93942, 93944, 93945, 93949, 93951, 93952, 93955, 93976, 93976, 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, 94399, 94399, 94399, 94400, 94400, 94400, 94401, 94401, 94401, 94402, 94402, 94402, 94403, 94403, 94403, 94404, 94404, 94404, 94405, 94405, 94405, 94406, 94406, 94406, 94407, 94407, 94407, 94408, 94408, 94408, 94409, 94409, 94409, 94410, 94410, 94410, 94411, 94411, 94411, 94412, 94412, 94412, 94413, 94413, 94413, 94414, 94414, 94414, 94415, 94415, 94415, 94416, 94416, 94416, 94417, 94417, 94417, 94418, 94418, 94419, 94419, 94420, 94420, 94421, 94421, 94421, 94422, 94422, 94422, 94423, 94423, 94423, 94424, 94424, 94424, 94425, 94425, 94425, 94426, 94426, 94426, 94455, 94456, 94457, 94458, 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, 94501, 94502, 94502, 94503, 94504, 94505, 94506, 94506, 94507, 94508, 94555, 94556, 94557, 94558, 94563, 94564, 94575, 94576, 94577, 94578, 94579, 94580, 94581, 94582, 94583, 94584, 94585, 94586, 94587, 94588, 94589, 94590, 94591, 94592, 94593, 94594, 94595, 94595, 94596, 94596, 94602, 94602, 94613, 94614, 94615, 94616, 94641, 94642, 94643, 94644, 94645, 94646, 94647, 94648, 94649, 94650, 94651, 94652, 94653, 94654, 94655, 94656, 94657, 94658, 94664, 94665, 94666, 94667, 94668, 94669, 94670, 94671, 94672, 94673, 94674, 94675, 94676, 94680, 94681, 94682, 94686, 94687, 94688, 94689, 94690, 94691, 94692, 94693, 94694, 94695, 94696, 94697, 94698, 94699, 94700, 94701, 94702, 94703, 94704, 94705, 94706, 94707, 94708, 94721, 94722, 94723, 94724, 94725, 94725, 94725, 94726, 94726, 94726, 94731, 94731, 94731, 94732, 94732, 94732, 94733, 94733, 94733, 94734, 94734, 94734, 94735, 94735, 94735, 94736, 94736, 94736, 94737, 94737, 94737, 94749, 94750, 94772, 94818, 94828, 94828, 94830, 94830, 94842, 94843, 94844, 94845, 94846, 94847, 94848, 94849, 95052, 95053, 95054, 95055, 95056, 95057, 95058, 95059, 95060, 95061, 95062, 95063, 95122, 95123, 95124, 95125, 95126, 95127, 95128, 95129, 95135, 95135, 95136, 95136, 95156, 95164, 95182, 95183, 95184, 95186, 95186, 95187, 95190, 95190, 95191, 95191, 95192, 95192, 95193, 95193, 95194, 95194, 95195, 95196, 95197, 95198, 95199, 95200, 95201, 95202, 95203, 95204, 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, 95237, 95238, 95239, 95240, 95241, 95242, 95243, 95244, 95245, 95246, 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, 95275, 95276, 95277, 95278, 95279, 95280, 95281, 95282, 95283, 95284, 95285, 95286, 95287, 95288, 95289, 95290, 95291, 95292, 95293, 95294, 95295, 95296, 95297, 95298, 95299, 95300, 95301, 95302, 95303, 95304, 95305, 95306, 95307, 95308, 95309, 95309, 95310, 95310, 95311, 95311, 95312, 95312, 95313, 95314, 95315, 95316, 95317, 95317, 95318, 95318, 95319, 95320, 95321, 95322, 95323, 95324, 95325, 95326, 95327, 95328, 95329, 95330, 95331, 95332, 95333, 95334, 95335, 95336, 95337, 95338, 95339, 95424, 95425, 95426, 95427, 95428, 95429, 95430, 95431, 95432, 95432, 95434, 95435, 95436, 95437, 95438, 95439, 95440, 95441, 95442, 95443, 95444, 95445, 95446, 95447, 95448, 95449, 95450, 95451, 95452, 95453, 95454, 95455, 95456, 95457, 95458, 95459, 95460, 95461, 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, 95510, 95511, 95512, 95513, 95514, 95515, 95516, 95517, 95518, 95519, 95520, 95521, 95522, 95523, 95530, 95530, 95531, 95531, 95531, 95532, 95532, 95532, 95533, 95533, 95534, 95534, 95535, 95535, 95536, 95536, 95537, 95537, 95538, 95538, 95539, 95539, 95540, 95540, 95555, 95556, 95557, 95558, 95560, 95574, 95575, 95576, 95577, 95578, 95579, 95580, 95581, 95582, 95583, 95584, 95585, 95586, 95595, 95596, 95597, 95598, 95599, 95600, 95601, 95602, 95603, 95622, 95623, 95624, 95625, 95626, 95642, 95643, 95644, 95645, 95646, 95647, 95648, 95649, 95650, 95651, 95652, 95653, 95662, 95663, 95664, 95665, 95666, 95667, 95668, 95669, 95670, 95671, 95672, 95673, 95674, 95675, 95676, 95677, 95678, 95679, 95680, 95681, 95682, 95683, 95684, 95685, 95686, 95687, 95688, 95689, 95690, 95691, 95692, 95693, 95694, 95695, 95696, 95697, 95698, 95699, 95700, 95701, 95702, 95703, 95704, 95705, 95706, 95707, 95708, 95709, 95710, 95711, 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, 95759, 95770, 95775, 95775, 95780, 95781, 95782, 95786, 95830, 96006, 96024, 96025, 96209, 96301, 96310, 96336, 96338, 96339, 96340, 96341, 96342, 96343, 96344, 96352, 96353, 97377, 97377, 97378, 97382, 97382, 97605, 97606, 97609, 97610, 97611, 97615, 97615, 97616, 97616, 97617, 97620, 97621, 97622, 97626, 97627, 97628, 97629, 97630, 97631, 97632, 97633, 97634, 97635, 97636, 97637, 97638, 97639, 97640, 97641, 97642, 97643, 97644, 97645, 97662, 97663, 97664, 97665, 97666, 97667, 97682, 97683, 97684, 97685, 97693, 97694, 97695, 97696, 97697, 97698, 97699, 97700, 97700, 97701, 97701, 97702, 97702, 97703, 97703, 97716, 97716, 97717, 97717, 97718, 97718, 97719, 97722, 97723, 97724, 97725, 97727, 97727, 97728, 97729, 97730, 97731, 97732, 97733, 97734, 97735, 97736, 97737, 97738, 97739, 97740, 97741, 97742, 97743, 97744, 97745, 97746, 97747, 97748, 97749, 97750, 97751, 97752, 97753, 97754, 97755, 97763, 97764, 97765, 97766, 97767, 97768, 97769, 97770, 97771, 97772, 97773, 97774, 97775, 97776, 97777, 97778, 97779, 97780, 97781, 97782, 97783, 97840, 97841, 97842, 97843, 97844, 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, 97985, 97985, 97986, 97986, 97987, 97987, 97988, 97988, 97989, 97989, 97990, 97990, 97991, 97991, 97992, 97992, 97993, 97993, 97994, 97994, 97995, 97995, 97996, 97996, 97997, 97998, 97999, 98000, 98001, 98002, 98003, 98004, 98005, 98006, 98007, 98008, 98009, 98010, 98011, 98012, 98013, 98014, 98015, 98016, 98017, 98018, 98019, 98020, 98021, 98022, 98023, 98024, 98025, 98026, 98027, 98028, 98029, 98030, 98031, 98032, 98033, 98034, 98035, 98036, 98037, 98038, 98039, 98040, 98041, 98052, 98052, 98052, 98057, 98057, 98057, 98058, 98058, 98058, 98059, 98059, 98059, 98060, 98060, 98060, 98061, 98061, 98061, 98062, 98062, 98062, 98063, 98063, 98063, 98064, 98064, 98064, 98065, 98066, 98067, 98068, 98069, 98070, 98071, 98072, 98073, 98074, 98075, 98076, 98077, 98078, 98085, 98086, 98087, 98088, 98089, 98098, 98099, 98100, 98101, 98102, 98103, 98104, 98105, 98106, 98107, 98112, 98113, 98123, 98125, 98125, 98127, 98148, 98148, 98149, 98149, 98152, 98158, 98159, 98160, 98161, 98162, 98181, 98186, 98186, 98414, 98418, 98418, 98419, 98420, 98423, 98425, 98426, 98427, 98428, 98429, 98430, 98439, 98441, 98492, 98492, 98493, 98493, 98601, 98602, 98603, 98604, 98605, 98606, 98607, 98608, 98609, 98610, 98611, 98612, 98613, 98614, 98615, 98616, 98617, 98618, 98619, 98620, 98621, 98622, 98623, 98624, 98625, 98736, 98737, 98764, 98765, 98833, 98963, 99312, 99723, 99724, 99725, 99736, 99749) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 32 | 32 | 32 | 15 | 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 (6516, 6775, 6776, 6778, 6778, 6779, 6779, 35192, 35209, 35260, 35261, 35263, 35625, 35626, 35651, 35652, 35699, 35760, 35760, 35764, 35764, 35783, 35783, 35785, 35785, 35786, 35786, 35787, 35788, 35788, 36242, 36243, 36244, 36245, 36246, 36770, 38489, 38489, 38504, 38504, 44760, 44760, 44781, 44781, 45127, 57684, 57684, 57685, 57685, 57686, 57686, 57687, 57687, 57688, 57688, 57706, 57707, 58128, 58129, 58130, 58131, 58324, 64622, 64623, 64624, 64686, 65278, 65329, 65331, 65331, 65337, 65338, 65338, 65358, 65366, 65373, 65374, 73557, 73734, 73734, 73737, 73737, 73747, 73747, 73781, 73781, 74424, 74424, 74427, 74428, 74432, 74439, 74440, 74445, 74445, 74446, 74450, 74753, 74753, 74753, 74754, 74754, 74754, 74787, 74788, 77040, 77041, 77042, 77043, 77044, 77045, 77046, 77048, 77049, 77050, 77051, 77052, 77053, 77054, 77055, 77056, 77057, 77058, 77059, 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, 77270, 77271, 77601, 77611, 77617, 77617, 77631, 77631, 77651, 77698, 77705, 77705, 77707, 77712, 77717, 77718, 77722, 78058, 78159, 80587, 80588, 80589, 80593, 80595, 80596, 80597, 80598, 80607, 80608, 80609, 80609, 80610, 80610, 80611, 80611, 80612, 80613, 80614, 80614, 80614, 80615, 80615, 80615, 80616, 80616, 80616, 80617, 80617, 80617, 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, 80729, 80730, 80734, 80735, 80736, 80737, 80760, 80761, 80762, 80764, 80765, 80766, 80768, 80769, 80770, 80779, 80781, 80782, 80784, 80784, 80791, 80792, 80795, 80796, 80798, 80799, 80800, 80800, 80803, 80803, 81471, 81471, 81472, 81472, 81473, 81474, 81474, 81506, 81506, 81509, 81509, 81510, 81510, 81511, 81512, 81513, 81514, 81515, 81516, 81517, 81518, 81520, 81521, 81521, 81522, 81522, 81523, 81523, 81524, 81524, 81552, 81553, 81554, 81555, 81556, 81558, 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, 81621, 81621, 81622, 81622, 81623, 81623, 81624, 81625, 81626, 81628, 81629, 81630, 81667, 81667, 81722, 81723, 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, 83787, 83788, 83789, 83790, 83791, 83792, 83792, 83793, 83800, 83801, 83802, 83812, 83813, 83814, 83814, 83815, 83815, 83818, 83819, 83820, 83821, 83822, 83823, 83824, 83825, 83826, 83827, 83832, 83833, 83834, 83834, 83835, 83836, 83837, 83838, 83839, 83840, 83841, 83842, 83843, 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, 83938, 83938, 84343, 84343, 84344, 84344, 84345, 84345, 84350, 84351, 84352, 84353, 84354, 84355, 84356, 84357, 84358, 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, 84476, 84477, 84478, 84479, 84480, 84480, 84481, 84481, 84482, 84482, 84483, 84483, 84488, 84489, 84490, 84491, 84492, 84492, 84517, 84518, 84524, 84525, 84526, 84546, 84546, 84547, 84547, 84550, 84551, 84552, 84553, 84557, 84558, 84559, 84560, 84569, 84569, 84570, 84570, 84571, 84571, 84576, 84576, 84577, 84577, 84578, 84578, 84579, 84579, 84580, 84580, 84581, 84582, 84583, 84584, 84584, 84585, 84585, 84590, 84590, 84590, 84591, 84592, 84593, 84593, 84594, 84594, 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, 85010, 85010, 85011, 85011, 85012, 85012, 85014, 85014, 85014, 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, 85163, 85164, 85165, 85166, 85167, 85168, 85169, 85170, 85170, 85171, 85171, 85172, 85172, 85175, 85175, 85178, 85178, 85179, 85179, 85180, 85180, 85181, 85181, 85182, 85182, 85183, 85183, 85184, 85184, 85185, 85185, 85186, 85186, 85187, 85187, 85188, 85188, 85202, 85208, 85208, 85209, 85209, 85212, 85213, 85214, 85214, 85215, 85215, 85216, 85217, 85218, 85219, 85220, 85220, 85222, 85223, 85226, 85259, 85260, 85261, 85262, 85263, 85264, 85265, 85266, 85275, 85276, 85277, 85288, 85290, 85342, 85398, 85534, 85535, 85536, 85537, 85538, 85539, 85540, 85541, 85632, 85632, 85633, 85633, 85634, 85634, 85635, 85635, 85636, 85637, 85638, 85639, 85640, 85641, 85642, 85643, 85644, 85645, 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, 85687, 85688, 85689, 85690, 85691, 85692, 85693, 85694, 85695, 85696, 85696, 85696, 85697, 85697, 85698, 85698, 85699, 85699, 85709, 85709, 85710, 85719, 85720, 85721, 85723, 85723, 85814, 85815, 86096, 86097, 86109, 86110, 87303, 87303, 87304, 87304, 87305, 87305, 87306, 87306, 87307, 87307, 87308, 87308, 87309, 87309, 87310, 87310, 87315, 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, 87362, 87362, 87362, 87364, 87364, 87374, 87374, 87375, 87375, 87376, 87377, 87383, 87383, 87384, 87384, 87391, 87391, 87392, 87392, 87393, 87393, 87398, 87399, 87400, 87401, 87402, 87407, 87408, 87450, 87844, 87845, 87852, 87853, 87854, 87855, 87855, 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, 87909, 87910, 87911, 87912, 87915, 87915, 87916, 87916, 87917, 87918, 87919, 87942, 87942, 87942, 87943, 87943, 87943, 87944, 87944, 87944, 87945, 87945, 87945, 87946, 87946, 87947, 87947, 87948, 87948, 87949, 87949, 87950, 87950, 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, 88206, 88207, 88208, 88208, 88208, 88209, 88209, 88210, 88210, 88211, 88212, 88213, 88214, 88215, 88219, 88220, 88221, 88222, 88223, 88225, 88227, 88228, 88228, 88229, 88229, 88239, 88240, 88241, 88242, 88243, 88244, 88245, 88246, 88249, 88250, 88251, 88252, 88253, 88254, 88396, 88537, 88537, 89286, 89316, 89456, 89456, 90368, 90369, 90370, 90371, 90372, 90373, 90374, 90375, 90376, 90377, 90378, 90379, 90380, 90381, 90382, 90383, 90384, 90385, 90386, 90387, 90388, 90389, 90390, 90391, 90392, 90393, 90394, 90397, 90397, 90398, 90399, 90402, 90403, 90404, 90405, 90406, 90407, 90411, 90412, 90413, 90414, 90414, 90415, 90415, 90416, 90417, 90418, 90418, 90419, 90419, 90420, 90420, 90421, 90421, 90422, 90422, 90423, 90423, 90424, 90424, 90425, 90425, 90426, 90426, 90427, 90428, 90429, 90429, 90430, 90430, 90431, 90432, 90436, 90437, 90438, 90439, 90450, 90674, 90675, 90676, 90677, 90678, 90679, 90680, 90681, 90689, 90689, 90690, 90690, 90691, 90692, 90693, 90694, 90695, 90696, 90697, 90698, 90699, 90700, 90701, 90702, 90703, 90704, 90705, 90706, 90707, 90708, 90709, 90710, 90711, 90712, 90713, 90714, 90715, 90716, 90717, 90718, 90719, 90720, 90721, 90722, 90723, 90724, 90725, 90726, 90727, 90728, 90729, 90730, 90731, 90732, 90733, 90734, 90735, 90736, 90737, 90747, 90748, 90749, 90750, 90750, 90750, 90751, 90751, 90751, 90752, 90752, 90752, 90753, 90753, 90753, 90758, 90759, 90760, 90761, 90762, 90763, 90767, 90768, 90769, 90770, 90771, 90771, 90772, 90773, 90774, 90775, 90776, 90777, 90778, 90779, 90780, 90781, 90782, 90783, 90784, 90785, 90786, 90787, 90788, 90789, 90790, 90791, 90792, 90793, 90794, 90795, 90796, 90797, 90798, 90799, 90800, 90801, 90802, 90803, 90804, 90805, 90806, 90807, 90808, 90809, 90810, 90811, 90812, 90813, 90814, 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, 90857, 90858, 90859, 90860, 90861, 90862, 90863, 90864, 90865, 90866, 90867, 90868, 90869, 90870, 90871, 90872, 90873, 90874, 90875, 90876, 90877, 90878, 90879, 90880, 90881, 90882, 90883, 90884, 90885, 90886, 90887, 90888, 90889, 90890, 90891, 90892, 90893, 90894, 90895, 90896, 90897, 90898, 90899, 90900, 90901, 90902, 90903, 90904, 90905, 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, 90950, 90951, 90952, 90953, 90954, 90955, 90956, 90957, 90958, 90959, 90960, 90961, 90962, 90963, 90964, 90965, 90966, 90967, 90968, 90969, 90970, 90971, 90992, 90993, 90996, 90997, 90998, 90999, 91000, 91001, 91001, 91002, 91003, 91003, 91003, 91004, 91004, 91004, 91005, 91006, 91009, 91010, 91011, 91012, 91013, 91022, 91023, 91024, 91025, 91026, 91028, 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, 91471, 91472, 91473, 91474, 91475, 91476, 91477, 91478, 91479, 91718, 91718, 91719, 91720, 91739, 91739, 91744, 91745, 92676, 92677, 92678, 92828, 93189, 93226, 93256, 93259, 93264, 93320, 93321, 93322, 93323, 93324, 93325, 93371, 93636, 93933, 93936, 93936, 93937, 93939, 93940, 93941, 93942, 93944, 93945, 93949, 93951, 93952, 93955, 93976, 93976, 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, 94399, 94399, 94399, 94400, 94400, 94400, 94401, 94401, 94401, 94402, 94402, 94402, 94403, 94403, 94403, 94404, 94404, 94404, 94405, 94405, 94405, 94406, 94406, 94406, 94407, 94407, 94407, 94408, 94408, 94408, 94409, 94409, 94409, 94410, 94410, 94410, 94411, 94411, 94411, 94412, 94412, 94412, 94413, 94413, 94413, 94414, 94414, 94414, 94415, 94415, 94415, 94416, 94416, 94416, 94417, 94417, 94417, 94418, 94418, 94419, 94419, 94420, 94420, 94421, 94421, 94421, 94422, 94422, 94422, 94423, 94423, 94423, 94424, 94424, 94424, 94425, 94425, 94425, 94426, 94426, 94426, 94455, 94456, 94457, 94458, 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, 94501, 94502, 94502, 94503, 94504, 94505, 94506, 94506, 94507, 94508, 94555, 94556, 94557, 94558, 94563, 94564, 94575, 94576, 94577, 94578, 94579, 94580, 94581, 94582, 94583, 94584, 94585, 94586, 94587, 94588, 94589, 94590, 94591, 94592, 94593, 94594, 94595, 94595, 94596, 94596, 94602, 94602, 94613, 94614, 94615, 94616, 94641, 94642, 94643, 94644, 94645, 94646, 94647, 94648, 94649, 94650, 94651, 94652, 94653, 94654, 94655, 94656, 94657, 94658, 94664, 94665, 94666, 94667, 94668, 94669, 94670, 94671, 94672, 94673, 94674, 94675, 94676, 94680, 94681, 94682, 94686, 94687, 94688, 94689, 94690, 94691, 94692, 94693, 94694, 94695, 94696, 94697, 94698, 94699, 94700, 94701, 94702, 94703, 94704, 94705, 94706, 94707, 94708, 94721, 94722, 94723, 94724, 94725, 94725, 94725, 94726, 94726, 94726, 94731, 94731, 94731, 94732, 94732, 94732, 94733, 94733, 94733, 94734, 94734, 94734, 94735, 94735, 94735, 94736, 94736, 94736, 94737, 94737, 94737, 94749, 94750, 94772, 94818, 94828, 94828, 94830, 94830, 94842, 94843, 94844, 94845, 94846, 94847, 94848, 94849, 95052, 95053, 95054, 95055, 95056, 95057, 95058, 95059, 95060, 95061, 95062, 95063, 95122, 95123, 95124, 95125, 95126, 95127, 95128, 95129, 95135, 95135, 95136, 95136, 95156, 95164, 95182, 95183, 95184, 95186, 95186, 95187, 95190, 95190, 95191, 95191, 95192, 95192, 95193, 95193, 95194, 95194, 95195, 95196, 95197, 95198, 95199, 95200, 95201, 95202, 95203, 95204, 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, 95237, 95238, 95239, 95240, 95241, 95242, 95243, 95244, 95245, 95246, 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, 95275, 95276, 95277, 95278, 95279, 95280, 95281, 95282, 95283, 95284, 95285, 95286, 95287, 95288, 95289, 95290, 95291, 95292, 95293, 95294, 95295, 95296, 95297, 95298, 95299, 95300, 95301, 95302, 95303, 95304, 95305, 95306, 95307, 95308, 95309, 95309, 95310, 95310, 95311, 95311, 95312, 95312, 95313, 95314, 95315, 95316, 95317, 95317, 95318, 95318, 95319, 95320, 95321, 95322, 95323, 95324, 95325, 95326, 95327, 95328, 95329, 95330, 95331, 95332, 95333, 95334, 95335, 95336, 95337, 95338, 95339, 95424, 95425, 95426, 95427, 95428, 95429, 95430, 95431, 95432, 95432, 95434, 95435, 95436, 95437, 95438, 95439, 95440, 95441, 95442, 95443, 95444, 95445, 95446, 95447, 95448, 95449, 95450, 95451, 95452, 95453, 95454, 95455, 95456, 95457, 95458, 95459, 95460, 95461, 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, 95510, 95511, 95512, 95513, 95514, 95515, 95516, 95517, 95518, 95519, 95520, 95521, 95522, 95523, 95530, 95530, 95531, 95531, 95531, 95532, 95532, 95532, 95533, 95533, 95534, 95534, 95535, 95535, 95536, 95536, 95537, 95537, 95538, 95538, 95539, 95539, 95540, 95540, 95555, 95556, 95557, 95558, 95560, 95574, 95575, 95576, 95577, 95578, 95579, 95580, 95581, 95582, 95583, 95584, 95585, 95586, 95595, 95596, 95597, 95598, 95599, 95600, 95601, 95602, 95603, 95622, 95623, 95624, 95625, 95626, 95642, 95643, 95644, 95645, 95646, 95647, 95648, 95649, 95650, 95651, 95652, 95653, 95662, 95663, 95664, 95665, 95666, 95667, 95668, 95669, 95670, 95671, 95672, 95673, 95674, 95675, 95676, 95677, 95678, 95679, 95680, 95681, 95682, 95683, 95684, 95685, 95686, 95687, 95688, 95689, 95690, 95691, 95692, 95693, 95694, 95695, 95696, 95697, 95698, 95699, 95700, 95701, 95702, 95703, 95704, 95705, 95706, 95707, 95708, 95709, 95710, 95711, 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, 95759, 95770, 95775, 95775, 95780, 95781, 95782, 95786, 95830, 96006, 96024, 96025, 96209, 96301, 96310, 96336, 96338, 96339, 96340, 96341, 96342, 96343, 96344, 96352, 96353, 97377, 97377, 97378, 97382, 97382, 97605, 97606, 97609, 97610, 97611, 97615, 97615, 97616, 97616, 97617, 97620, 97621, 97622, 97626, 97627, 97628, 97629, 97630, 97631, 97632, 97633, 97634, 97635, 97636, 97637, 97638, 97639, 97640, 97641, 97642, 97643, 97644, 97645, 97662, 97663, 97664, 97665, 97666, 97667, 97682, 97683, 97684, 97685, 97693, 97694, 97695, 97696, 97697, 97698, 97699, 97700, 97700, 97701, 97701, 97702, 97702, 97703, 97703, 97716, 97716, 97717, 97717, 97718, 97718, 97719, 97722, 97723, 97724, 97725, 97727, 97727, 97728, 97729, 97730, 97731, 97732, 97733, 97734, 97735, 97736, 97737, 97738, 97739, 97740, 97741, 97742, 97743, 97744, 97745, 97746, 97747, 97748, 97749, 97750, 97751, 97752, 97753, 97754, 97755, 97763, 97764, 97765, 97766, 97767, 97768, 97769, 97770, 97771, 97772, 97773, 97774, 97775, 97776, 97777, 97778, 97779, 97780, 97781, 97782, 97783, 97840, 97841, 97842, 97843, 97844, 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, 97985, 97985, 97986, 97986, 97987, 97987, 97988, 97988, 97989, 97989, 97990, 97990, 97991, 97991, 97992, 97992, 97993, 97993, 97994, 97994, 97995, 97995, 97996, 97996, 97997, 97998, 97999, 98000, 98001, 98002, 98003, 98004, 98005, 98006, 98007, 98008, 98009, 98010, 98011, 98012, 98013, 98014, 98015, 98016, 98017, 98018, 98019, 98020, 98021, 98022, 98023, 98024, 98025, 98026, 98027, 98028, 98029, 98030, 98031, 98032, 98033, 98034, 98035, 98036, 98037, 98038, 98039, 98040, 98041, 98052, 98052, 98052, 98057, 98057, 98057, 98058, 98058, 98058, 98059, 98059, 98059, 98060, 98060, 98060, 98061, 98061, 98061, 98062, 98062, 98062, 98063, 98063, 98063, 98064, 98064, 98064, 98065, 98066, 98067, 98068, 98069, 98070, 98071, 98072, 98073, 98074, 98075, 98076, 98077, 98078, 98085, 98086, 98087, 98088, 98089, 98098, 98099, 98100, 98101, 98102, 98103, 98104, 98105, 98106, 98107, 98112, 98113, 98123, 98125, 98125, 98127, 98148, 98148, 98149, 98149, 98152, 98158, 98159, 98160, 98161, 98162, 98181, 98186, 98186, 98414, 98418, 98418, 98419, 98420, 98423, 98425, 98426, 98427, 98428, 98429, 98430, 98439, 98441, 98492, 98492, 98493, 98493, 98601, 98602, 98603, 98604, 98605, 98606, 98607, 98608, 98609, 98610, 98611, 98612, 98613, 98614, 98615, 98616, 98617, 98618, 98619, 98620, 98621, 98622, 98623, 98624, 98625, 98736, 98737, 98764, 98765, 98833, 98963, 99312, 99723, 99724, 99725, 99736, 99749) AND `item_rank` <> 3 | 1 | 1 | 15 | maybe slow |
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 | 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` = 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` = 90736) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1696-040'))))) OR (((`item_id2` = 90736) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1696-040'))))) OR (((`item_id3` = 90736) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1696-040')))))) 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` = 90736 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95575) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1883-044'))))) OR (((`item_id2` = 95575) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1883-044'))))) OR (((`item_id3` = 95575) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1883-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` = 95575 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94652) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1824-044'))))) OR (((`item_id2` = 94652) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1824-044'))))) OR (((`item_id3` = 94652) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1824-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` = 94652 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 6776) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h166-041846'))))) OR (((`item_id2` = 6776) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h166-041846'))))) OR (((`item_id3` = 6776) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h166-041846')))))) 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` = 6776 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
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 | 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` = 74432 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` = 93189) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25332G10'))))) OR (((`item_id2` = 93189) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25332G10'))))) OR (((`item_id3` = 93189) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25332G10')))))) 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` = 93189 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
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` = 81667) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-219146'))))) OR (((`item_id2` = 81667) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-219146'))))) OR (((`item_id3` = 81667) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-219146')))))) 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` = 81667 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` = 35699) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-0453-008'))))) OR (((`item_id2` = 35699) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-0453-008'))))) OR (((`item_id3` = 35699) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-0453-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` = 35699 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 | 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` = 87383) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1641-009'))))) OR (((`item_id2` = 87383) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1641-009'))))) OR (((`item_id3` = 87383) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1641-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` = 87383 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 87384) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1641-044'))))) OR (((`item_id2` = 87384) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1641-044'))))) OR (((`item_id3` = 87384) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1641-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` = 87384 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 6775) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h166-041747'))))) OR (((`item_id2` = 6775) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h166-041747'))))) OR (((`item_id3` = 6775) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h166-041747')))))) 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` = 6775 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95645) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0138-044'))))) OR (((`item_id2` = 95645) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0138-044'))))) OR (((`item_id3` = 95645) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0138-044')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 95645 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97627) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-313844'))))) OR (((`item_id2` = 97627) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-313844'))))) OR (((`item_id3` = 97627) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-313844')))))) 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` = 97627 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` = 95311) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0122-009'))))) OR (((`item_id2` = 95311) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0122-009'))))) OR (((`item_id3` = 95311) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0122-009')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 95311 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 6516) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'S-N0001'))))) OR (((`item_id2` = 6516) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'S-N0001'))))) OR (((`item_id3` = 6516) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'S-N0001')))))) 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` = 6516 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
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 | 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` = 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` = 98624) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TX-0012-011'))))) OR (((`item_id2` = 98624) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TX-0012-011'))))) OR (((`item_id3` = 98624) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TX-0012-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` = 98624 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` = 98623) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TX-0012-009'))))) OR (((`item_id2` = 98623) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TX-0012-009'))))) OR (((`item_id3` = 98623) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TX-0012-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` = 98623 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` = 98426) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MT-36209'))))) OR (((`item_id2` = 98426) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MT-36209'))))) OR (((`item_id3` = 98426) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MT-36209')))))) 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` = 98426 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 1 | |
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 11.30 MB
Message | Memory use |
---|---|
Component initialization | 3.66 MB |
Controller action start | 5.13 MB |
Controller render start | 6.13 MB |
View render complete | 7.86 MB |
Total Request Time: 202 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 32.22 | |
Event: Controller.initialize | 10.26 | |
Event: Controller.startup | 0.57 | |
Controller action | 99.78 | |
Event: Controller.beforeRender | 6.39 | |
» Processing toolbar data | 6.31 | |
Rendering View | 21.88 | |
» Event: View.beforeRender | 0.02 | |
» Rendering APP/View/Items/searchpicture.ctp | 21.21 | |
» » Rendering APP/View/Elements/Head_menu.ctp | 0.06 | |
» » Rendering APP/View/Elements/Head_txt.ctp | 0.05 | |
» » Rendering APP/View/Elements/picturelist.ctp | 13.81 | |
» » » Rendering APP/View/Elements/price.ctp | 0.10 | |
» » » Rendering APP/View/Elements/icon_set.ctp | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #2 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #2 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #3 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #3 | 0.12 | |
» » » Rendering APP/View/Elements/price.ctp #4 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #4 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #5 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #5 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #6 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #6 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #7 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #7 | 0.10 | |
» » » Rendering APP/View/Elements/price.ctp #8 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #8 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #9 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #9 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #10 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #10 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #11 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #11 | 0.09 | |
» » » 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.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #13 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #14 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #14 | 0.10 | |
» » » Rendering APP/View/Elements/price.ctp #15 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #15 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #16 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #16 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #17 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #17 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #18 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #18 | 0.10 | |
» » » Rendering APP/View/Elements/price.ctp #19 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #19 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #20 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #20 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #21 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #21 | 0.10 | |
» » » Rendering APP/View/Elements/price.ctp #22 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #22 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #23 | 0.10 | |
» » » Rendering APP/View/Elements/icon_set.ctp #23 | 0.10 | |
» » » Rendering APP/View/Elements/price.ctp #24 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #24 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #25 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #25 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #26 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #26 | 0.10 | |
» » » Rendering APP/View/Elements/price.ctp #27 | 0.10 | |
» » » Rendering APP/View/Elements/icon_set.ctp #27 | 0.10 | |
» » » Rendering APP/View/Elements/price.ctp #28 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #28 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #29 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #29 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #30 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #30 | 0.09 | |
» » » Rendering APP/View/Elements/price.ctp #31 | 0.09 | |
» » » Rendering APP/View/Elements/icon_set.ctp #31 | 0.10 | |
» » » Rendering APP/View/Elements/price.ctp #32 | 0.09 | |
» » » 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.60 | |
» » Rendering APP/View/Elements/Area_left.ctp | 3.58 | |
» » » Rendering APP/View/Elements/serchlink.ctp | 1.47 | |
» » » Rendering APP/View/Elements/speciallink.ctp | 0.13 | |
» » » Rendering APP/View/Elements/pricelink.ctp | 0.52 | |
» » » Rendering APP/View/Elements/cataloglink.ctp | 0.06 | |
» » Rendering APP/View/Elements/footlink.ctp | 0.29 | |
» » Rendering APP/View/Elements/Analyticslink.ctp | 0.06 | |
» Event: View.afterRender | 0.01 | |
» Event: View.beforeLayout | 0.01 | |
» Rendering APP/View/Layouts/default.ctp | 0.07 | |
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 | CakeCookie[mode]=Q2FrZQ%3D%3D.ig%3D%3D; CakeCookie[watch_list]=Q2FrZQ%3D%3D.4U4ITfKxf9tzy7DyIrPt1nzpTo5PD5ev88GkeFFw2n4uY9fS5FlEg0wMD8GulU7odscYvwxLy%2FqNnlCjcZo%3D; CAKEPHP=jum7k8jrh34n1lllmhhob0lnm3 |
Http Accept Encoding | gzip, br, zstd, deflate |
Http Referer | http://test.pqnavi.com/items/m_search |
Http Host | test.pqnavi.com |
Http Via | 1.1 squid-proxy-5b5d847c96-pk9s8 (squid/6.10) |
Http X Forwarded For | 10.2.56.69 |
Http Cache Control | max-age=259200 |
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.159 |
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 | 60523 |
Redirect Url | /app/webroot/items/search |
Gateway Interface | CGI/1.1 |
Server Protocol | HTTP/1.1 |
Request Method | GET |
Query String | |
Request Uri | /items/search |
Script Name | /app/webroot/index.php |
Php Self | /app/webroot/index.php |
Request Time Float | 1750694821.273 |
Request Time | 1750694821 |