Queries
max count: 2
| Query |
Count |
Min time |
Max time |
Average time |
SELECT value FROM cscart_jp_settings WHERE name = 'jp_prod_search_mode'
|
2 |
0.00001 |
0.00002 |
0.00002 |
SELECT storefronts.* FROM cscart_storefronts AS storefronts WHERE 1 = 1 AND (storefronts.url = 'edev.sms-refactory.com' OR storefronts.url = 'www.edev.sms-refactory.com' OR storefronts.url LIKE 'www_.edev.sms-refactory.com' OR storefronts.url LIKE 'edev.sms-refactory.com/%' OR storefronts.url LIKE 'www.edev.sms-refactory.com/%' OR storefronts.url LIKE 'www_.edev.sms-refactory.com/%') GROUP BY storefronts.storefront_id ORDER BY storefronts.url = 'edev.sms-refactory.com' DESC, storefronts.url = 'www.edev.sms-refactory.com' DESC, storefronts.url LIKE 'www_.edev.sms-refactory.com' DESC, storefronts.url LIKE 'edev.sms-refactory.com/%' DESC, storefronts.url LIKE 'www.edev.sms-refactory.com/%' DESC, storefronts.url LIKE 'www_.edev.sms-refactory.com/%' desc
|
1 |
0.00004 |
0.00004 |
0.00004 |
SELECT f.feature_id, f.purpose, p.product_id, p.parent_product_id, g.id, g.code FROM cscart_product_variation_group_features AS f INNER JOIN cscart_product_variation_groups AS g ON f.group_id = g.id INNER JOIN cscart_product_variation_group_products AS p ON f.group_id = p.group_id WHERE p.product_id IN (23, 4, 5, 22, 1, 113, 117, 125, 120, 133, 132, 175)
|
1 |
0.00004 |
0.00004 |
0.00004 |
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'ja' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id IN (23, 4, 5, 22, 1, 113, 117, 125, 120, 133, 132, 175) ORDER BY cscart_images_links.position, cscart_images_links.pair_id;SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'ja' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id IN (23, 4, 5, 22, 1, 113, 117, 125, 120, 133, 132, 175) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00040 |
0.00040 |
0.00040 |
SELECT a.*, b.option_name, b.internal_option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_product_options as a LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'ja' WHERE a.product_id IN (23, 4, 5, 22, 1, 113, 117, 125, 120, 133, 132, 175) AND a.status = 'A' ORDER BY a.position
|
1 |
0.00004 |
0.00004 |
0.00004 |
SELECT c.product_id AS cur_product_id, a.*, b.option_name, b.internal_option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_product_options as a LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'ja' LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id WHERE c.product_id IN (23, 4, 5, 22, 1, 113, 117, 125, 120, 133, 132, 175) AND a.product_id = 0 AND a.status = 'A' ORDER BY a.position
|
1 |
0.00002 |
0.00002 |
0.00002 |
SELECT cscart_languages.* FROM cscart_languages WHERE 1
|
1 |
0.00002 |
0.00002 |
0.00002 |
SELECT storefronts.* FROM cscart_storefronts AS storefronts LEFT JOIN cscart_storefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('1') ) GROUP BY storefronts.storefront_id ORDER BY storefronts.is_default desc
|
1 |
0.00002 |
0.00002 |
0.00002 |
SELECT cscart_promotions.*, cscart_promotion_descriptions.name, cscart_promotion_descriptions.detailed_description, cscart_promotion_descriptions.short_description FROM cscart_promotions LEFT JOIN cscart_promotion_descriptions ON cscart_promotion_descriptions.promotion_id = cscart_promotions.promotion_id AND cscart_promotion_descriptions.lang_code = 'ja' LEFT JOIN cscart_storefronts_promotions AS storefronts_promotions ON storefronts_promotions.promotion_id = cscart_promotions.promotion_id WHERE 1 AND IF(from_date, from_date <= 1772347344, 1) AND IF(to_date, to_date >= 1772347344, 1) AND status IN ('A', 'H') AND cscart_promotions.zone = 'catalog' AND (storefronts_promotions.storefront_id = 1 OR storefronts_promotions.storefront_id IS NULL) ORDER BY cscart_promotions.stop_other_rules desc, cscart_promotions.priority asc
|
1 |
0.00004 |
0.00004 |
0.00004 |
SELECT cscart_products_categories.product_id, GROUP_CONCAT(IF(cscart_products_categories.link_type = "M", CONCAT(cscart_products_categories.category_id, "M"), cscart_products_categories.category_id)) AS category_ids FROM cscart_products_categories INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') WHERE cscart_products_categories.product_id IN (23, 4, 5, 22, 1, 113, 117, 125, 120, 133, 132, 175) GROUP BY cscart_products_categories.product_id
|
1 |
0.00002 |
0.00002 |
0.00002 |
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)
|
1 |
0.00003 |
0.00003 |
0.00003 |
SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'
|
1 |
0.00002 |
0.00002 |
0.00002 |
SELECT c.* FROM cscart_bm_containers as c WHERE 1 AND c.location_id = 11 AND c.company_id = 0
|
1 |
0.00003 |
0.00003 |
0.00003 |
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 11
|
1 |
0.00002 |
0.00002 |
0.00002 |
SELECT c.*, IF (c.location_id != 11, 0, 1) as `default` FROM cscart_bm_containers as c INNER JOIN cscart_bm_locations as l ON c.location_id = l.location_id AND l.is_default = 1 AND l.layout_id = 1 WHERE 1 AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER') AND c.company_id = 0
|
1 |
0.00002 |
0.00002 |
0.00002 |
SELECT * FROM cscart_bm_containers as c LEFT JOIN cscart_bm_grids as g ON g.container_id = c.container_id WHERE 1 AND g.container_id IN (1, 42, 43, 4) ORDER BY g.order, g.parent_id, g.grid_id ASC
|
1 |
0.00003 |
0.00003 |
0.00003 |
SELECT cscart_bm_snapping.grid_id as grid_id,cscart_bm_snapping.block_id as block_id,IFNULL(dynamic_object_content.content, default_content.content) as content,IFNULL(dynamic_object_content.object_id, default_content.object_id) AS object_id,IFNULL(dynamic_object_content.object_type, default_content.object_type) AS object_type,cscart_bm_block_statuses.object_ids as object_ids,cscart_bm_snapping.*,cscart_bm_blocks.*,cscart_bm_blocks_descriptions.* FROM cscart_bm_snapping LEFT JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_bm_snapping.block_id LEFT JOIN cscart_bm_block_statuses ON cscart_bm_snapping.snapping_id = cscart_bm_block_statuses.snapping_id AND cscart_bm_block_statuses.object_type LIKE '' LEFT JOIN cscart_bm_blocks_descriptions ON cscart_bm_blocks.block_id = cscart_bm_blocks_descriptions.block_id LEFT JOIN cscart_bm_blocks_content AS default_content ON cscart_bm_blocks.block_id = default_content.block_id AND cscart_bm_blocks_descriptions.lang_code = default_content.lang_code AND default_content.snapping_id = 0 AND default_content.object_id = 0 AND default_content.object_type like '' LEFT JOIN cscart_bm_blocks_content AS dynamic_object_content ON cscart_bm_blocks.block_id = dynamic_object_content.block_id AND cscart_bm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 0 AND dynamic_object_content.object_type like '' WHERE cscart_bm_snapping.grid_id IN (1, 2, 3, 12, 15, 20, 13, 14, 16, 17, 18, 19, 21, 22, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71) AND cscart_bm_blocks_descriptions.lang_code='ja' ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id
|
1 |
0.00004 |
0.00004 |
0.00004 |
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'ja' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (23, 4, 5, 22, 1, 113, 117, 125, 120, 133, 132, 175) ORDER BY cscart_images_links.position, cscart_images_links.pair_id;SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'ja' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (23, 4, 5, 22, 1, 113, 117, 125, 120, 133, 132, 175) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00040 |
0.00040 |
0.00040 |
SELECT cscart_product_prices.product_id, MIN(IF(cscart_product_prices.percentage_discount = 0,cscart_product_prices.price,cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) AS price FROM cscart_product_prices WHERE cscart_product_prices.product_id IN (23, 4, 5, 22, 1, 113, 117, 125, 120, 133, 132, 175) AND cscart_product_prices.lower_limit = 1 AND cscart_product_prices.usergroup_id IN (0, 1) GROUP BY cscart_product_prices.product_id
|
1 |
0.00002 |
0.00002 |
0.00002 |
SELECT cscart_product_descriptions.product_id, cscart_product_descriptions.short_description, IF(cscart_product_descriptions.short_description = '' OR cscart_product_descriptions.short_description IS NULL, cscart_product_descriptions.full_description, '') AS full_description FROM cscart_product_descriptions WHERE cscart_product_descriptions.product_id IN (23, 4, 5, 22, 1, 113, 117, 125, 120, 133, 132, 175) AND cscart_product_descriptions.lang_code = 'ja'
|
1 |
0.00002 |
0.00002 |
0.00002 |
SELECT * FROM cscart_bm_layouts WHERE 1 AND storefront_id = 1 AND layout_id = 1
|
1 |
0.00003 |
0.00003 |
0.00003 |
SET time_zone = '+09:00'
|
1 |
0.00003 |
0.00003 |
0.00003 |
SELECT company_id FROM cscart_companies WHERE company_id = '1'
|
1 |
0.00003 |
0.00003 |
0.00003 |
SELECT storefronts.* FROM cscart_storefronts AS storefronts WHERE 1 = 1 AND storefronts.storefront_id IN (1) GROUP BY storefronts.storefront_id ORDER BY storefronts.is_default desc
|
1 |
0.00003 |
0.00003 |
0.00003 |
SELECT cscart_bm_layouts.* FROM cscart_bm_layouts WHERE 1 AND is_default = 1 AND theme_name = 'bright_theme' AND storefront_id = 1
|
1 |
0.00002 |
0.00002 |
0.00002 |
SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'
|
1 |
0.00002 |
0.00002 |
0.00002 |
SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'
|
1 |
0.00004 |
0.00004 |
0.00004 |
SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'ja' WHERE l.layout_id = 1 AND l.dispatch IN ('companies.products') ORDER BY l.object_ids desc LIMIT 1
|
1 |
0.00002 |
0.00002 |
0.00002 |
SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'
|
1 |
0.00002 |
0.00002 |
0.00002 |
SELECT cscart_company_descriptions.*, cscart_companies.*, p.price, p.periodicity, p.commission, p.products_limit, p.revenue_limit, p.vendor_store, p.categories, p.storefronts FROM cscart_companies LEFT JOIN cscart_company_descriptions ON cscart_company_descriptions.company_id = cscart_companies.company_id AND cscart_company_descriptions.lang_code = 'ja' LEFT JOIN cscart_vendor_plans p ON p.plan_id = cscart_companies.plan_id WHERE cscart_companies.company_id IN('1') ORDER BY cscart_companies.company_id asc LIMIT 0, 1
|
1 |
0.00004 |
0.00004 |
0.00004 |
SELECT company_descriptions.*, companies.*, cscart_vendor_plan_descriptions.plan FROM cscart_companies AS companies LEFT JOIN cscart_company_descriptions AS company_descriptions ON company_descriptions.company_id = companies.company_id AND company_descriptions.lang_code = 'ja' LEFT JOIN cscart_vendor_plan_descriptions ON companies.plan_id = cscart_vendor_plan_descriptions.plan_id AND cscart_vendor_plan_descriptions.lang_code = 'ja' WHERE companies.company_id = 1
|
1 |
0.00003 |
0.00003 |
0.00003 |
SELECT profile_fields_data.field_id, profile_fields_data.value, profile_fields.field_type FROM cscart_profile_fields_data AS profile_fields_data LEFT JOIN cscart_profile_fields AS profile_fields ON profile_fields_data.field_id = profile_fields.field_id WHERE object_id = 1 AND object_type = 'S'
|
1 |
0.00002 |
0.00002 |
0.00002 |
SELECT company_id FROM cscart_storefronts_companies WHERE storefront_id = 1
|
1 |
0.00002 |
0.00002 |
0.00002 |
SELECT SQL_CALC_FOUND_ROWS products.product_id, descr1.product as product, companies.company as company_name, products.product_type, products.parent_product_id, cscart_product_review_prepared_data.average_rating average_rating, cscart_product_review_prepared_data.reviews_count product_reviews_count FROM cscart_products as products LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'ja' LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') LEFT JOIN cscart_product_review_prepared_data ON cscart_product_review_prepared_data.product_id = products.product_id AND cscart_product_review_prepared_data.storefront_id = 0 WHERE 1 AND companies.status = 'A' AND products.company_id = 1 AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.company_id = 1 AND products.parent_product_id = 0 GROUP BY products.product_id ORDER BY product asc, products.product_id ASC LIMIT 144, 12
|
1 |
0.00003 |
0.00003 |
0.00003 |
SELECT FOUND_ROWS()
|
1 |
0.00004 |
0.00004 |
0.00004 |
SELECT cscart_products.* FROM cscart_products WHERE cscart_products.product_id IN (23, 4, 5, 22, 1, 113, 117, 125, 120, 133, 132, 175)
|
1 |
0.00004 |
0.00004 |
0.00004 |
SELECT quickpay_id FROM cscart_jp_cc_quickpay WHERE user_id =0 AND payment_method ='remise_cc'
|
1 |
0.00003 |
0.00003 |
0.00003 |