★ My 注目リスト
1.数量入力→2.会社情報入力→3.受付完了
検索メニュー
No post data.
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 `Cnt`.`id`, `Cnt`.`item_id`, `Cnt`.`pagecnt`, `Cnt`.`listcnt`, `Cnt`.`estimatecnt`, `Cnt`.`created`, `Cnt`.`modified`, `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_unit`, `Item`.`item_naming`, `Item`.`item_fullcolor`, `Item`.`item_speed`, `Item`.`item_naming_detail`, `Item`.`item_figure`, `Item`.`item_boxsize`, `Item`.`item_size`, `Item`.`item_color`, `Item`.`item_materials`, `Item`.`item_note`, `Item`.`item_rank`, `Item`.`item_stock_id`, `Item`.`item_stock_price`, `Item`.`item_stock_wholesale_price`, `Item`.`file1_name`, `Item`.`file2_name`, `Item`.`item_memo`, `Item`.`koushinbi`, `Item`.`min_amount`, `Item`.`created`, `Item`.`modified` FROM `witinc_pqnavi_test`.`md_cnts` AS `Cnt` LEFT JOIN `witinc_pqnavi_test`.`md_items` AS `Item` ON (`Cnt`.`item_id` = `Item`.`id`) WHERE `Cnt`.`item_id` = 57748 LIMIT 1 | 1 | 1 | 0 | |
BEGIN | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_cnts` AS `Cnt` WHERE `Cnt`.`id` = 45031 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_cnts` AS `Cnt` WHERE `Cnt`.`id` = 45031 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_cnts` AS `Cnt` WHERE `Cnt`.`id` = 45031 | 1 | 1 | 0 | |
UPDATE `witinc_pqnavi_test`.`md_cnts` SET `id` = 45031, `item_id` = 57748, `pagecnt` = 3750, `listcnt` = 2078, `estimatecnt` = 3, `created` = '2014-03-27 03:42:35', `modified` = '2015-11-09 19:37:20' WHERE `witinc_pqnavi_test`.`md_cnts`.`id` = '45031' | 1 | 1 | 0 | |
COMMIT | 1 | 1 | 0 | |
SELECT `Cntym`.`id`, `Cntym`.`yearmonth`, `Cntym`.`item_id`, `Cntym`.`pagecnt`, `Cntym`.`listcnt`, `Cntym`.`estimatecnt`, `Cntym`.`created`, `Cntym`.`modified`, `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_unit`, `Item`.`item_naming`, `Item`.`item_fullcolor`, `Item`.`item_speed`, `Item`.`item_naming_detail`, `Item`.`item_figure`, `Item`.`item_boxsize`, `Item`.`item_size`, `Item`.`item_color`, `Item`.`item_materials`, `Item`.`item_note`, `Item`.`item_rank`, `Item`.`item_stock_id`, `Item`.`item_stock_price`, `Item`.`item_stock_wholesale_price`, `Item`.`file1_name`, `Item`.`file2_name`, `Item`.`item_memo`, `Item`.`koushinbi`, `Item`.`min_amount`, `Item`.`created`, `Item`.`modified` FROM `witinc_pqnavi_test`.`md_cntyms` AS `Cntym` LEFT JOIN `witinc_pqnavi_test`.`md_items` AS `Item` ON (`Cntym`.`item_id` = `Item`.`id`) WHERE `Cntym`.`yearmonth` = '202506' AND `Cntym`.`item_id` = 57748 LIMIT 1 | 1 | 1 | 344 | maybe slow |
BEGIN | 1 | 1 | 344 | maybe slow |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_cntyms` AS `Cntym` WHERE `Cntym`.`id` = 5472656 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_cntyms` AS `Cntym` WHERE `Cntym`.`id` = 5472656 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_cntyms` AS `Cntym` WHERE `Cntym`.`id` = 5472656 | 1 | 1 | 0 | |
UPDATE `witinc_pqnavi_test`.`md_cntyms` SET `id` = 5472656, `yearmonth` = '202506', `item_id` = 57748, `pagecnt` = 3, `listcnt` = 1, `estimatecnt` = 0, `created` = '2025-06-14 16:09:01', `modified` = '2025-06-14 16:09:01' WHERE `witinc_pqnavi_test`.`md_cntyms`.`id` = '5472656' | 1 | 1 | 0 | |
COMMIT | 1 | 1 | 0 | |
SELECT `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_naming`, `Item`.`item_unit`, `Item`.`item_color`, `Item`.`item_stock_wholesale_price`, `Campaign`.`id`, `Campaign`.`campaign_price`, `Item`.`item_rank`, `Item`.`item_fullcolor`, `Item`.`item_speed`, `Item`.`file1_name` 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 (NULL, 80612, 74217, 90433, 96788, 97618, 90895, 98906, 95957, 91423, 97792, 97814, 94517, 92697, 96639, 97786, 91409, 97896, 90823, 89034, 97815, 57748) AND `Item`.`item_rank` < 3 AND `item_rank` <> 3 ORDER BY `Item`.`id` ASC | 21 | 21 | 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` = 74217) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'LC0550AE'))))) OR (((`item_id2` = 74217) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'LC0550AE'))))) OR (((`item_id3` = 74217) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'LC0550AE')))))) 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` = 74217 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 80612) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'FB-FC-A'))))) OR (((`item_id2` = 80612) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'FB-FC-A'))))) OR (((`item_id3` = 80612) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'FB-FC-A')))))) 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` = 80612 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 89034) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25277G5B'))))) OR (((`item_id2` = 89034) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25277G5B'))))) OR (((`item_id3` = 89034) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25277G5B')))))) 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` = 89034 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90433) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'MO-3009-044'))))) OR (((`item_id2` = 90433) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'MO-3009-044'))))) OR (((`item_id3` = 90433) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'MO-3009-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` = 90433 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90823) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1200-050'))))) OR (((`item_id2` = 90823) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1200-050'))))) OR (((`item_id3` = 90823) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1200-050')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 90823 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 90895) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TF-0005-006'))))) OR (((`item_id2` = 90895) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TF-0005-006'))))) OR (((`item_id3` = 90895) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TF-0005-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` = 90895 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91409) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1203-006'))))) OR (((`item_id2` = 91409) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1203-006'))))) OR (((`item_id3` = 91409) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1203-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` = 91409 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91423) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1220-009'))))) OR (((`item_id2` = 91423) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1220-009'))))) OR (((`item_id3` = 91423) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1220-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` = 91423 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92697) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25101G5A'))))) OR (((`item_id2` = 92697) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25101G5A'))))) OR (((`item_id3` = 92697) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25101G5A')))))) 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` = 92697 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 94517) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TS-1510-025'))))) OR (((`item_id2` = 94517) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TS-1510-025'))))) OR (((`item_id3` = 94517) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TS-1510-025')))))) 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` = 94517 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95957) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25301G1A'))))) OR (((`item_id2` = 95957) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25301G1A'))))) OR (((`item_id3` = 95957) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25301G1A')))))) 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` = 95957 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96639) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2521G8'))))) OR (((`item_id2` = 96639) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2521G8'))))) OR (((`item_id3` = 96639) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2521G8')))))) 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` = 96639 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 96788) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25282G7'))))) OR (((`item_id2` = 96788) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25282G7'))))) OR (((`item_id3` = 96788) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25282G7')))))) 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` = 96788 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97618) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'h-313547'))))) OR (((`item_id2` = 97618) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'h-313547'))))) OR (((`item_id3` = 97618) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'h-313547')))))) 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` = 97618 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97786) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2374831'))))) OR (((`item_id2` = 97786) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2374831'))))) OR (((`item_id3` = 97786) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2374831')))))) 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` = 97786 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97792) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2374971'))))) OR (((`item_id2` = 97792) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2374971'))))) OR (((`item_id3` = 97792) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2374971')))))) 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` = 97792 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97814) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2374891'))))) OR (((`item_id2` = 97814) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2374891'))))) OR (((`item_id3` = 97814) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2374891')))))) 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` = 97814 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97815) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2374871'))))) OR (((`item_id2` = 97815) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2374871'))))) OR (((`item_id3` = 97815) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2374871')))))) 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` = 97815 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97896) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-0872-034'))))) OR (((`item_id2` = 97896) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-0872-034'))))) OR (((`item_id3` = 97896) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-0872-034')))))) 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` = 97896 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98906) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '2580G5'))))) OR (((`item_id2` = 98906) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '2580G5'))))) OR (((`item_id3` = 98906) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '2580G5')))))) 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` = 98906 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 |
6 duplicate queries run.
Peak Memory Use 9.60 MB
Message | Memory use |
---|---|
Component initialization | 3.68 MB |
Controller action start | 5.12 MB |
Controller render start | 5.93 MB |
View render complete | 7.23 MB |
Total Request Time: 461 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 40.33 | |
Event: Controller.initialize | 10.21 | |
Event: Controller.startup | 0.42 | |
Controller action | 364.51 | |
Event: Controller.beforeRender | 6.69 | |
» Processing toolbar data | 6.59 | |
Rendering View | 11.89 | |
» Event: View.beforeRender | 0.02 | |
» Rendering APP/View/Items/m_addlist.ctp | 11.21 | |
» » Rendering APP/View/Elements/m_header.ctp | 0.08 | |
» » Rendering APP/View/Elements/m_item_icon.ctp | 0.10 | |
» » Rendering APP/View/Elements/m_item_icon.ctp #2 | 0.09 | |
» » Rendering APP/View/Elements/m_item_icon.ctp #3 | 0.10 | |
» » Rendering APP/View/Elements/m_item_icon.ctp #4 | 0.09 | |
» » Rendering APP/View/Elements/m_item_icon.ctp #5 | 0.09 | |
» » Rendering APP/View/Elements/m_item_icon.ctp #6 | 0.11 | |
» » Rendering APP/View/Elements/m_item_icon.ctp #7 | 0.09 | |
» » Rendering APP/View/Elements/m_item_icon.ctp #8 | 0.09 | |
» » Rendering APP/View/Elements/m_item_icon.ctp #9 | 0.09 | |
» » Rendering APP/View/Elements/m_item_icon.ctp #10 | 0.11 | |
» » Rendering APP/View/Elements/m_item_icon.ctp #11 | 0.09 | |
» » Rendering APP/View/Elements/m_item_icon.ctp #12 | 0.09 | |
» » Rendering APP/View/Elements/m_item_icon.ctp #13 | 0.09 | |
» » Rendering APP/View/Elements/m_item_icon.ctp #14 | 0.10 | |
» » Rendering APP/View/Elements/m_item_icon.ctp #15 | 0.09 | |
» » Rendering APP/View/Elements/m_item_icon.ctp #16 | 0.09 | |
» » Rendering APP/View/Elements/m_item_icon.ctp #17 | 0.09 | |
» » Rendering APP/View/Elements/m_item_icon.ctp #18 | 0.10 | |
» » Rendering APP/View/Elements/m_item_icon.ctp #19 | 0.09 | |
» » Rendering APP/View/Elements/m_item_icon.ctp #20 | 0.13 | |
» » Rendering APP/View/Elements/m_item_icon.ctp #21 | 0.13 | |
» » Rendering APP/View/Elements/m_menu.ctp | 0.09 | |
» » Rendering APP/View/Elements/m_search.ctp | 0.34 | |
» » Rendering APP/View/Elements/m_footer.ctp | 0.09 | |
» » Rendering APP/View/Elements/m_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 | CAKEPHP=okdsnlk66dga5cv5a5c4k7r7q1; CakeCookie[watch_list]=Q2FrZQ%3D%3D.4U4ITfKxf9pwyLLzIrPt2H3iTYBPD5ev9sKjf1Fw2n4pZ93d5FlEgkMMD86ulU7ofssSswxLy%2FSGkFKsceurIRDtL3fYTB9%2BEWFkWWH%2BEJs10P6152VfqZU%2FdVrMqV7oBTxaTDp5%2FEXJzZac9QBwNOuOk9m0QIcBOYEiQkwHzw3maA5gwCNHvDAqrQnHMaK0%2FPi494Cz7kSu6GLdvWCgeFW9fWzpEg%3D%3D; CakeCookie[mode]=Q2FrZQ%3D%3D.iw%3D%3D |
Http Accept Encoding | gzip, br, zstd, deflate |
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 | 18176 |
Redirect Url | /app/webroot/items/m_addlist/57748/add |
Gateway Interface | CGI/1.1 |
Server Protocol | HTTP/1.1 |
Request Method | GET |
Query String | |
Request Uri | /items/m_addlist/57748/add |
Script Name | /app/webroot/index.php |
Php Self | /app/webroot/index.php |
Request Time Float | 1750703837.071 |
Request Time | 1750703837 |