SELECT popup_id,popup_key,popup_title,popup_img,popup_link,popup_start,popup_expired,popup_time_delay,popup_time_show,popup_frequency,popup_page,coupon_code_text FROM popup AS p WHERE p.popup_status = 1 AND p.popup_start IS NOT NULL AND p.popup_expired IS NOT NULL ORDER BY popup_id DESCConnection name: default Speed: 3.333 ms Query analysis: · Query: SIMPLE on p · Possible keys: popup_status · Key Used: popup_status · Type: ref · Rows: 1 (Using where) Call trace for this query:File: PKGPATH/pvh/classes/model/core/base.php, line 531File: PKGPATH/pvh/classes/model/core/base.php, line 674File: APPPATH/classes/core/controller/front.php, line 867File: APPPATH/classes/core/controller/front.php, line 128File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 92 |
SELECT ads_json FROM ads AS a WHERE a.ads_key = 'ads_slider' AND a.ads_status = 1 LIMIT 1Connection name: default Speed: 1.004 ms Query analysis: · Query: SIMPLE on a · Possible keys: ads_key · Key Used: ads_key · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/pvh/classes/model/core/base.php, line 275File: PKGPATH/pvh/classes/model/core/base.php, line 353File: PKGPATH/pvh/classes/model/ads.php, line 257File: PKGPATH/pvh/classes/model/ads.php, line 400File: APPPATH/classes/controller/welcome.php, line 43File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 92 |
SELECT ads_id,ads_name,ads_key,ads_status,ads_json,ads_type,ads_view_more,ads_img,ads_img_mobile,ads_about,ads_link,ads_categories FROM ads AS a WHERE a.ads_type = 'banner' AND a.ads_status = 1 LIMIT 50Connection name: default Speed: 0.902 ms Query analysis: · Query: SIMPLE on a · Type: ALL · Rows: 9 (Using where) Call trace for this query:File: PKGPATH/pvh/classes/model/core/base.php, line 576File: PKGPATH/pvh/classes/model/ads.php, line 115File: PKGPATH/pvh/classes/model/core/base.php, line 674File: PKGPATH/pvh/classes/model/ads.php, line 284File: PKGPATH/pvh/classes/model/ads.php, line 431File: APPPATH/classes/controller/welcome.php, line 44File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 92 |
SELECT news_id,news_title,news_slug,news_image_thumb,news_date_created FROM news AS news ORDER BY news_id DESC LIMIT 10Connection name: default Speed: 0.629 ms Query analysis: · Query: SIMPLE on news · Key Used: PRIMARY · Type: index · Rows: 4 Call trace for this query:File: PKGPATH/pvh/classes/model/core/base.php, line 576File: PKGPATH/pvh/classes/model/core/base.php, line 674File: PKGPATH/pvh/classes/model/ads.php, line 308File: PKGPATH/pvh/classes/model/ads.php, line 431File: APPPATH/classes/controller/welcome.php, line 44File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 92 |
SELECT cat_id,cat_name,cat_slug FROM category AS c WHERE c.cat_status = 1 AND c.cat_type = 1 AND c.cat_id IN ('3196', '3199', '3202') LIMIT 50Connection name: default Speed: 0.903 ms Query analysis: · Query: SIMPLE on c · Possible keys: PRIMARY,cat_type,cat_status · Key Used: cat_type|cat_status · Type: range|filter · Rows: 3 (19%) (Using index condition; Using where; Using rowid filter) Call trace for this query:File: PKGPATH/pvh/classes/model/core/base.php, line 576File: PKGPATH/pvh/classes/model/core/base.php, line 674File: PKGPATH/pvh/classes/model/product.php, line 3847File: PKGPATH/pvh/classes/model/ads.php, line 313File: PKGPATH/pvh/classes/model/ads.php, line 431File: APPPATH/classes/controller/welcome.php, line 44File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 92 |
SELECT p.product_id,p.product_name,p.product_key,p.product_slug,p.product_new,p.product_hot,p.product_seen,p.product_price,p.product_price_sale_new,p.product_stock_status,pi.product_image_file,pc.cat_id,ps.product_image_color_type FROM product AS p LEFT JOIN product_cat AS pc ON p.product_id = pc.product_id LEFT JOIN product_sub AS ps ON p.product_id = ps.product_id LEFT JOIN product_images AS pi ON p.product_id = pi.product_id WHERE pc.cat_id = 3196 AND p.product_status = 1 GROUP BY p.product_id ORDER BY p.product_hot DESC , p.product_new DESC , p.product_date_stock DESC LIMIT 10Connection name: default Speed: 3.243 ms Query analysis: · Query: SIMPLE on pc · Possible keys: product_cat,cat_id,product_id · Key Used: product_cat · Type: ref · Rows: 9 (Using where; Using index; Using temporary; Using filesort) · Query: SIMPLE on p · Possible keys: PRIMARY,product_status · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on ps · Possible keys: product_id · Key Used: product_id · Type: ref · Rows: 1 · Query: SIMPLE on pi · Possible keys: product_id · Key Used: product_id · Type: ref · Rows: 2 Call trace for this query:File: PKGPATH/pvh/classes/model/product.php, line 546File: PKGPATH/pvh/classes/model/core/base.php, line 674File: PKGPATH/pvh/classes/model/product.php, line 3885File: PKGPATH/pvh/classes/model/ads.php, line 313File: PKGPATH/pvh/classes/model/ads.php, line 431File: APPPATH/classes/controller/welcome.php, line 44File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 92 |
SELECT p.product_id,p.product_name,p.product_key,p.product_slug,p.product_new,p.product_hot,p.product_seen,p.product_price,p.product_price_sale_new,p.product_stock_status,pi.product_image_file,pc.cat_id,ps.product_image_color_type FROM product AS p LEFT JOIN product_cat AS pc ON p.product_id = pc.product_id LEFT JOIN product_sub AS ps ON p.product_id = ps.product_id LEFT JOIN product_images AS pi ON p.product_id = pi.product_id WHERE pc.cat_id = 3199 AND p.product_status = 1 GROUP BY p.product_id ORDER BY p.product_hot DESC , p.product_new DESC , p.product_date_stock DESC LIMIT 10Connection name: default Speed: 2.127 ms Query analysis: · Query: SIMPLE on pc · Possible keys: product_cat,cat_id,product_id · Key Used: product_cat · Type: ref · Rows: 9 (Using where; Using index; Using temporary; Using filesort) · Query: SIMPLE on p · Possible keys: PRIMARY,product_status · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on ps · Possible keys: product_id · Key Used: product_id · Type: ref · Rows: 1 · Query: SIMPLE on pi · Possible keys: product_id · Key Used: product_id · Type: ref · Rows: 2 Call trace for this query:File: PKGPATH/pvh/classes/model/product.php, line 546File: PKGPATH/pvh/classes/model/core/base.php, line 674File: PKGPATH/pvh/classes/model/product.php, line 3885File: PKGPATH/pvh/classes/model/ads.php, line 313File: PKGPATH/pvh/classes/model/ads.php, line 431File: APPPATH/classes/controller/welcome.php, line 44File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 92 |
SELECT p.product_id,p.product_name,p.product_key,p.product_slug,p.product_new,p.product_hot,p.product_seen,p.product_price,p.product_price_sale_new,p.product_stock_status,pi.product_image_file,pc.cat_id,ps.product_image_color_type FROM product AS p LEFT JOIN product_cat AS pc ON p.product_id = pc.product_id LEFT JOIN product_sub AS ps ON p.product_id = ps.product_id LEFT JOIN product_images AS pi ON p.product_id = pi.product_id WHERE pc.cat_id = 3202 AND p.product_status = 1 GROUP BY p.product_id ORDER BY p.product_hot DESC , p.product_new DESC , p.product_date_stock DESC LIMIT 10Connection name: default Speed: 1.319 ms Query analysis: · Query: SIMPLE on pc · Possible keys: product_cat,cat_id,product_id · Key Used: product_cat · Type: ref · Rows: 4 (Using where; Using index; Using temporary; Using filesort) · Query: SIMPLE on p · Possible keys: PRIMARY,product_status · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on ps · Possible keys: product_id · Key Used: product_id · Type: ref · Rows: 1 · Query: SIMPLE on pi · Possible keys: product_id · Key Used: product_id · Type: ref · Rows: 2 Call trace for this query:File: PKGPATH/pvh/classes/model/product.php, line 546File: PKGPATH/pvh/classes/model/core/base.php, line 674File: PKGPATH/pvh/classes/model/product.php, line 3885File: PKGPATH/pvh/classes/model/ads.php, line 313File: PKGPATH/pvh/classes/model/ads.php, line 431File: APPPATH/classes/controller/welcome.php, line 44File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 92 |
SELECT co.*
FROM coupon as co WHERE co.coupon_status = 1 LIMIT 200Connection name: default Speed: 0.804 ms Query analysis: · Query: SIMPLE on co · Possible keys: coupon_status · Key Used: coupon_status · Type: ref · Rows: 1 Call trace for this query:File: PKGPATH/pvh/classes/model/core/base.php, line 425File: PKGPATH/pvh/classes/model/core/base.php, line 613File: PKGPATH/pvh/classes/model/coupon_product.php, line 134File: PKGPATH/pvh/classes/model/coupon_product.php, line 108File: PKGPATH/pvh/classes/model/coupon_product.php, line 255File: PKGPATH/pvh/classes/model/product.php, line 1619File: PKGPATH/pvh/classes/model/product.php, line 3891File: PKGPATH/pvh/classes/model/ads.php, line 313File: PKGPATH/pvh/classes/model/ads.php, line 431File: APPPATH/classes/controller/welcome.php, line 44File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 92 |
SELECT co.*
FROM coupon as co WHERE co.coupon_status = 1 LIMIT 200Connection name: default Speed: 0.409 ms · DUPLICATE Query analysis: · Query: SIMPLE on co · Possible keys: coupon_status · Key Used: coupon_status · Type: ref · Rows: 1 Call trace for this query:File: PKGPATH/pvh/classes/model/core/base.php, line 425File: PKGPATH/pvh/classes/model/core/base.php, line 613File: PKGPATH/pvh/classes/model/coupon_product.php, line 134File: PKGPATH/pvh/classes/model/coupon_product.php, line 108File: PKGPATH/pvh/classes/model/coupon_product.php, line 192File: PKGPATH/pvh/classes/model/coupon_product.php, line 271File: PKGPATH/pvh/classes/model/product.php, line 1619File: PKGPATH/pvh/classes/model/product.php, line 3891File: PKGPATH/pvh/classes/model/ads.php, line 313File: PKGPATH/pvh/classes/model/ads.php, line 431File: APPPATH/classes/controller/welcome.php, line 44File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 92 |
SELECT co.coupon_id, co.coupon_status
,co.coupon_value, co.coupon_type
,cp.product_id, co.coupon_name
FROM coupon as co
LEFT JOIN coupon_product as cp
ON cp.coupon_id = co.coupon_id WHERE co.coupon_status = 1 AND co.coupon_for = 1 AND co.coupon_id = -1 AND cp.product_id IN(41517,41425,41523,41426,41533,41506,41336,41516,41424,41860,41874,41861,41876,41862,41920,41863,41859,41865,41861,41862,41874,41859) GROUP BY cp.product_idConnection name: default Speed: 0.521 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: PKGPATH/pvh/classes/model/coupon_product.php, line 215File: PKGPATH/pvh/classes/model/coupon_product.php, line 271File: PKGPATH/pvh/classes/model/product.php, line 1619File: PKGPATH/pvh/classes/model/product.php, line 3891File: PKGPATH/pvh/classes/model/ads.php, line 313File: PKGPATH/pvh/classes/model/ads.php, line 431File: APPPATH/classes/controller/welcome.php, line 44File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 92 |
SELECT t.*, ta.tag_image, ta.tag_name, ta.tag_status, ta.tag_type
FROM tag_product as t
LEFT JOIN tag as ta
ON ta.tag_id = t.tag_id
WHERE ta.tag_status = 1 AND t.product_id IN (41517,41425,41523,41426,41533,41506,41336,41516,41424,41860,41874,41861,41876,41862,41920,41863,41859,41865,41861,41862,41874,41859) GROUP BY t.product_idConnection name: default Speed: 1.039 ms Query analysis: · Query: SIMPLE on t · Possible keys: tag_id,product_id · Type: ALL · Rows: 1 (Using where; Using temporary; Using filesort) · Query: SIMPLE on ta · Possible keys: PRIMARY,tag_status · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) Call trace for this query:File: PKGPATH/pvh/classes/model/tag_product.php, line 124File: PKGPATH/pvh/classes/model/tag_product.php, line 180File: PKGPATH/pvh/classes/model/product.php, line 1629File: PKGPATH/pvh/classes/model/product.php, line 3891File: PKGPATH/pvh/classes/model/ads.php, line 313File: PKGPATH/pvh/classes/model/ads.php, line 431File: APPPATH/classes/controller/welcome.php, line 44File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 92 |
SELECT p.product_id,p.product_key,ps.product_image_color_type FROM product AS p LEFT JOIN product_sub AS ps ON p.product_id = ps.product_id WHERE p.product_status = 1 AND p.product_key IN ('31D0037', '25D0005', '31D0042', '25D0006', '31D0157', '30D0035', '11D0166', '31D0034', '25D0004', '67D0048', '67D0120', '67D0049', '67D0136', '67D0050', '76D0045', '67D0051', '67D0047', '67D0066', '67D0049', '67D0050', '67D0120', '67D0047') GROUP BY p.product_idConnection name: default Speed: 1.366 ms Query analysis: · Query: SIMPLE on p · Possible keys: product_status,product_key · Key Used: product_key|product_status · Type: range|filter · Rows: 27 (8%) (Using index condition; Using where; Using temporary; Using filesort; Using rowid filter) · Query: SIMPLE on ps · Possible keys: product_id · Key Used: product_id · Type: ref · Rows: 1 Call trace for this query:File: PKGPATH/pvh/classes/model/product.php, line 515File: PKGPATH/pvh/classes/model/core/base.php, line 674File: PKGPATH/pvh/classes/model/product.php, line 1679File: PKGPATH/pvh/classes/model/product.php, line 3891File: PKGPATH/pvh/classes/model/ads.php, line 313File: PKGPATH/pvh/classes/model/ads.php, line 431File: APPPATH/classes/controller/welcome.php, line 44File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 92 |
SELECT product_sub_id,product_id,product_sub_sku,product_sub_size,product_sub_quantity,product_sub_price FROM product_sub AS ps WHERE ps.product_id IN ('41517', '41425', '41523', '41426', '41533', '41506', '41336', '41516', '41424', '41860', '41874', '41861', '41876', '41862', '41920', '41863', '41859', '41865', '41861', '41862', '41874', '41859') AND ps.product_sub_stock_status = 1 GROUP BY ps.product_sub_idConnection name: default Speed: 2.302 ms Query analysis: · Query: SIMPLE on ps · Possible keys: product_id,product_sub_stock_status · Key Used: product_id|product_sub_stock_status · Type: range|filter · Rows: 115 (43%) (Using index condition; Using where; Using filesort; Using rowid filter) Call trace for this query:File: PKGPATH/pvh/classes/model/product_sub.php, line 745File: PKGPATH/pvh/classes/model/core/base.php, line 674File: PKGPATH/pvh/classes/model/product.php, line 1698File: PKGPATH/pvh/classes/model/product.php, line 3891File: PKGPATH/pvh/classes/model/ads.php, line 313File: PKGPATH/pvh/classes/model/ads.php, line 431File: APPPATH/classes/controller/welcome.php, line 44File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 92 |
SELECT cat_id,cat_name,cat_slug FROM category AS c WHERE c.cat_status = 1 AND c.cat_type = 1 AND c.cat_id IN ('3195', '3196', '3197') LIMIT 50Connection name: default Speed: 0.916 ms Query analysis: · Query: SIMPLE on c · Possible keys: PRIMARY,cat_type,cat_status · Key Used: cat_type|cat_status · Type: range|filter · Rows: 3 (19%) (Using index condition; Using where; Using rowid filter) Call trace for this query:File: PKGPATH/pvh/classes/model/core/base.php, line 576File: PKGPATH/pvh/classes/model/core/base.php, line 674File: PKGPATH/pvh/classes/model/product.php, line 3513File: PKGPATH/pvh/classes/model/ads.php, line 317File: PKGPATH/pvh/classes/model/ads.php, line 431File: APPPATH/classes/controller/welcome.php, line 44File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 92 |
SELECT p.product_id,p.product_name,p.product_key,p.product_slug,p.product_new,p.product_hot,p.product_seen,p.product_price,p.product_price_sale_new,p.product_stock_status,pi.product_image_file,pc.cat_id,ps.product_image_color_type FROM product AS p LEFT JOIN product_cat AS pc ON p.product_id = pc.product_id LEFT JOIN product_sub AS ps ON p.product_id = ps.product_id LEFT JOIN product_images AS pi ON p.product_id = pi.product_id WHERE pc.cat_id = 3195 AND p.product_status = 1 GROUP BY p.product_id ORDER BY pc.cat_order DESC , p.product_new DESC , p.product_date_stock DESC LIMIT 10Connection name: default Speed: 3.982 ms Query analysis: · Query: SIMPLE on pc · Possible keys: product_cat,cat_id,product_id · Key Used: cat_id · Type: ref · Rows: 12 (Using where; Using temporary; Using filesort) · Query: SIMPLE on p · Possible keys: PRIMARY,product_status · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on ps · Possible keys: product_id · Key Used: product_id · Type: ref · Rows: 1 · Query: SIMPLE on pi · Possible keys: product_id · Key Used: product_id · Type: ref · Rows: 2 Call trace for this query:File: PKGPATH/pvh/classes/model/product.php, line 546File: PKGPATH/pvh/classes/model/core/base.php, line 674File: PKGPATH/pvh/classes/model/product.php, line 3551File: PKGPATH/pvh/classes/model/ads.php, line 317File: PKGPATH/pvh/classes/model/ads.php, line 431File: APPPATH/classes/controller/welcome.php, line 44File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 92 |
SELECT p.product_id,p.product_name,p.product_key,p.product_slug,p.product_new,p.product_hot,p.product_seen,p.product_price,p.product_price_sale_new,p.product_stock_status,pi.product_image_file,pc.cat_id,ps.product_image_color_type FROM product AS p LEFT JOIN product_cat AS pc ON p.product_id = pc.product_id LEFT JOIN product_sub AS ps ON p.product_id = ps.product_id LEFT JOIN product_images AS pi ON p.product_id = pi.product_id WHERE pc.cat_id = 3196 AND p.product_status = 1 GROUP BY p.product_id ORDER BY pc.cat_order DESC , p.product_new DESC , p.product_date_stock DESC LIMIT 10Connection name: default Speed: 2.540 ms Query analysis: · Query: SIMPLE on pc · Possible keys: product_cat,cat_id,product_id · Key Used: cat_id · Type: ref · Rows: 9 (Using where; Using temporary; Using filesort) · Query: SIMPLE on p · Possible keys: PRIMARY,product_status · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on ps · Possible keys: product_id · Key Used: product_id · Type: ref · Rows: 1 · Query: SIMPLE on pi · Possible keys: product_id · Key Used: product_id · Type: ref · Rows: 2 Call trace for this query:File: PKGPATH/pvh/classes/model/product.php, line 546File: PKGPATH/pvh/classes/model/core/base.php, line 674File: PKGPATH/pvh/classes/model/product.php, line 3551File: PKGPATH/pvh/classes/model/ads.php, line 317File: PKGPATH/pvh/classes/model/ads.php, line 431File: APPPATH/classes/controller/welcome.php, line 44File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 92 |
SELECT p.product_id,p.product_name,p.product_key,p.product_slug,p.product_new,p.product_hot,p.product_seen,p.product_price,p.product_price_sale_new,p.product_stock_status,pi.product_image_file,pc.cat_id,ps.product_image_color_type FROM product AS p LEFT JOIN product_cat AS pc ON p.product_id = pc.product_id LEFT JOIN product_sub AS ps ON p.product_id = ps.product_id LEFT JOIN product_images AS pi ON p.product_id = pi.product_id WHERE pc.cat_id = 3197 AND p.product_status = 1 GROUP BY p.product_id ORDER BY pc.cat_order DESC , p.product_new DESC , p.product_date_stock DESC LIMIT 10Connection name: default Speed: 3.359 ms Query analysis: · Query: SIMPLE on pc · Possible keys: product_cat,cat_id,product_id · Key Used: cat_id · Type: range · Rows: 26 (Using index condition; Using temporary; Using filesort) · Query: SIMPLE on p · Possible keys: PRIMARY,product_status · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on ps · Possible keys: product_id · Key Used: product_id · Type: ref · Rows: 1 · Query: SIMPLE on pi · Possible keys: product_id · Key Used: product_id · Type: ref · Rows: 2 Call trace for this query:File: PKGPATH/pvh/classes/model/product.php, line 546File: PKGPATH/pvh/classes/model/core/base.php, line 674File: PKGPATH/pvh/classes/model/product.php, line 3551File: PKGPATH/pvh/classes/model/ads.php, line 317File: PKGPATH/pvh/classes/model/ads.php, line 431File: APPPATH/classes/controller/welcome.php, line 44File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 92 |
SELECT co.*
FROM coupon as co WHERE co.coupon_status = 1 LIMIT 200Connection name: default Speed: 0.618 ms · DUPLICATE Query analysis: · Query: SIMPLE on co · Possible keys: coupon_status · Key Used: coupon_status · Type: ref · Rows: 1 Call trace for this query:File: PKGPATH/pvh/classes/model/core/base.php, line 425File: PKGPATH/pvh/classes/model/core/base.php, line 613File: PKGPATH/pvh/classes/model/coupon_product.php, line 134File: PKGPATH/pvh/classes/model/coupon_product.php, line 108File: PKGPATH/pvh/classes/model/coupon_product.php, line 255File: PKGPATH/pvh/classes/model/product.php, line 1619File: PKGPATH/pvh/classes/model/product.php, line 3557File: PKGPATH/pvh/classes/model/ads.php, line 317File: PKGPATH/pvh/classes/model/ads.php, line 431File: APPPATH/classes/controller/welcome.php, line 44File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 92 |
SELECT co.*
FROM coupon as co WHERE co.coupon_status = 1 LIMIT 200Connection name: default Speed: 0.405 ms · DUPLICATE Query analysis: · Query: SIMPLE on co · Possible keys: coupon_status · Key Used: coupon_status · Type: ref · Rows: 1 Call trace for this query:File: PKGPATH/pvh/classes/model/core/base.php, line 425File: PKGPATH/pvh/classes/model/core/base.php, line 613File: PKGPATH/pvh/classes/model/coupon_product.php, line 134File: PKGPATH/pvh/classes/model/coupon_product.php, line 108File: PKGPATH/pvh/classes/model/coupon_product.php, line 192File: PKGPATH/pvh/classes/model/coupon_product.php, line 271File: PKGPATH/pvh/classes/model/product.php, line 1619File: PKGPATH/pvh/classes/model/product.php, line 3557File: PKGPATH/pvh/classes/model/ads.php, line 317File: PKGPATH/pvh/classes/model/ads.php, line 431File: APPPATH/classes/controller/welcome.php, line 44File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 92 |
SELECT co.coupon_id, co.coupon_status
,co.coupon_value, co.coupon_type
,cp.product_id, co.coupon_name
FROM coupon as co
LEFT JOIN coupon_product as cp
ON cp.coupon_id = co.coupon_id WHERE co.coupon_status = 1 AND co.coupon_for = 1 AND co.coupon_id = -1 AND cp.product_id IN(41854,41386,41723,41326,41891,41316,41318,41381,41319,41880,41425,41523,41336,41517,41516,41533,41426,41506,41424,41717,41693,41660,41666,41589,41665,41654,41718,41692,41720) GROUP BY cp.product_idConnection name: default Speed: 0.472 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: PKGPATH/pvh/classes/model/coupon_product.php, line 215File: PKGPATH/pvh/classes/model/coupon_product.php, line 271File: PKGPATH/pvh/classes/model/product.php, line 1619File: PKGPATH/pvh/classes/model/product.php, line 3557File: PKGPATH/pvh/classes/model/ads.php, line 317File: PKGPATH/pvh/classes/model/ads.php, line 431File: APPPATH/classes/controller/welcome.php, line 44File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 92 |
SELECT t.*, ta.tag_image, ta.tag_name, ta.tag_status, ta.tag_type
FROM tag_product as t
LEFT JOIN tag as ta
ON ta.tag_id = t.tag_id
WHERE ta.tag_status = 1 AND t.product_id IN (41854,41386,41723,41326,41891,41316,41318,41381,41319,41880,41425,41523,41336,41517,41516,41533,41426,41506,41424,41717,41693,41660,41666,41589,41665,41654,41718,41692,41720) GROUP BY t.product_idConnection name: default Speed: 0.562 ms Query analysis: · Query: SIMPLE on t · Possible keys: tag_id,product_id · Type: ALL · Rows: 1 (Using where; Using temporary; Using filesort) · Query: SIMPLE on ta · Possible keys: PRIMARY,tag_status · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) Call trace for this query:File: PKGPATH/pvh/classes/model/tag_product.php, line 124File: PKGPATH/pvh/classes/model/tag_product.php, line 180File: PKGPATH/pvh/classes/model/product.php, line 1629File: PKGPATH/pvh/classes/model/product.php, line 3557File: PKGPATH/pvh/classes/model/ads.php, line 317File: PKGPATH/pvh/classes/model/ads.php, line 431File: APPPATH/classes/controller/welcome.php, line 44File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 92 |
SELECT p.product_id,p.product_key,ps.product_image_color_type FROM product AS p LEFT JOIN product_sub AS ps ON p.product_id = ps.product_id WHERE p.product_status = 1 AND p.product_key IN ('60D0158', '17D0138', '55D0024', '11D0148', '70D0142', '11D0026', '11D0053', '17D0019', '11D0053', '67D0132', '25D0005', '31D0042', '11D0166', '31D0037', '31D0034', '31D0157', '25D0006', '30D0035', '25D0004', '48D0155', '46D0141', '45D0058', '45D0140', '41D0012', '45D0134', '45D0017', '48D0124', '46D0135', '49D0011') GROUP BY p.product_idConnection name: default Speed: 1.159 ms Query analysis: · Query: SIMPLE on p · Possible keys: product_status,product_key · Key Used: product_status · Type: ref · Rows: 51 (Using where) · Query: SIMPLE on ps · Possible keys: product_id · Key Used: product_id · Type: ref · Rows: 1 Call trace for this query:File: PKGPATH/pvh/classes/model/product.php, line 515File: PKGPATH/pvh/classes/model/core/base.php, line 674File: PKGPATH/pvh/classes/model/product.php, line 1679File: PKGPATH/pvh/classes/model/product.php, line 3557File: PKGPATH/pvh/classes/model/ads.php, line 317File: PKGPATH/pvh/classes/model/ads.php, line 431File: APPPATH/classes/controller/welcome.php, line 44File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 92 |
SELECT product_sub_id,product_id,product_sub_sku,product_sub_size,product_sub_quantity,product_sub_price FROM product_sub AS ps WHERE ps.product_id IN ('41854', '41386', '41723', '41326', '41891', '41316', '41318', '41381', '41319', '41880', '41425', '41523', '41336', '41517', '41516', '41533', '41426', '41506', '41424', '41717', '41693', '41660', '41666', '41589', '41665', '41654', '41718', '41692', '41720') AND ps.product_sub_stock_status = 1 GROUP BY ps.product_sub_idConnection name: default Speed: 1.812 ms Query analysis: · Query: SIMPLE on ps · Possible keys: product_id,product_sub_stock_status · Key Used: product_id|product_sub_stock_status · Type: range|filter · Rows: 197 (43%) (Using index condition; Using where; Using filesort; Using rowid filter) Call trace for this query:File: PKGPATH/pvh/classes/model/product_sub.php, line 745File: PKGPATH/pvh/classes/model/core/base.php, line 674File: PKGPATH/pvh/classes/model/product.php, line 1698File: PKGPATH/pvh/classes/model/product.php, line 3557File: PKGPATH/pvh/classes/model/ads.php, line 317File: PKGPATH/pvh/classes/model/ads.php, line 431File: APPPATH/classes/controller/welcome.php, line 44File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 92 |