0.3861658573 | UPDATE oc_product SET image ='' WHERE image IS NULL |
0.0043540001 | SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '24735' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name |
0.0037040710 | SELECT * FROM oc_product_image WHERE product_id = '214244' ORDER BY sort_order ASC |
0.0034990311 | SELECT * FROM oc_product_image WHERE product_id = '25151' ORDER BY sort_order ASC |
0.0032892227 | SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC |
0.0027041435 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru') |
0.0022900105 | SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '24216' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name |
0.0021829605 | SELECT * FROM oc_currency |
0.0021150112 | SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '24735' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name |
0.0018210411 | SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '24216' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name |
0.0017700195 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/compare' OR route = 'ru-ru') |
0.0017099380 | SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '24216' |
0.0016641617 | SELECT * FROM oc_product_image WHERE product_id = '24217' ORDER BY sort_order ASC |
0.0016469955 | SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '24761' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name |
0.0016391277 | DELETE FROM oc_cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 60 MINUTE) |
0.0015540123 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0015461445 | SELECT value FROM oc_setting WHERE store_id = '0' AND `key`='asc_jetcache_settings' |
0.0014979839 | SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '24716' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name |
0.0014939308 | SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '24717' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name |
0.0014641285 | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'advertise_google' |
0.0013978481 | SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '24718' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name |
0.0013680458 | SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '24217' |
0.0013599396 | SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '25167' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name |
0.0013568401 | SELECT count(*) as c FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='atlantcabel' AND TABLE_NAME='oc_category' AND COLUMN_NAME='noindex' |
0.0013549328 | SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '24715' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name |
0.0013000965 | SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '24319' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name |
0.0012919903 | SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '25152' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name |
0.0012021065 | DELETE FROM `oc_session` WHERE `expire` < '2025-08-02 07:04:17' |
0.0011839867 | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_prostoremeslinks' |
0.0011639595 | SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '214244' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name |
0.0011501312 | SELECT * FROM oc_category_to_layout WHERE category_id = '24' AND store_id = '0' |
0.0011489391 | SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '25151' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name |
0.0011382103 | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'advertise_google' |
0.0011339188 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0011339188 | SELECT * FROM oc_product_image WHERE product_id = '214248' ORDER BY sort_order ASC |
0.0010590553 | SELECT * FROM oc_product_image WHERE product_id = '24761' ORDER BY sort_order ASC |
0.0010550022 | SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '24217' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name |
0.0010011196 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header_wishlist' |
0.0009920597 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0009770393 | SELECT * FROM oc_extension WHERE `type` = 'analytics' |
0.0009741783 | SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '24761' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name |
0.0009460449 | SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '214248' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name |
0.0009410381 | SELECT * FROM oc_category_to_layout WHERE category_id = '24' AND store_id = '0' |
0.0009398460 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0009241104 | SHOW TABLES LIKE 'oc_ocfilter_setting' |
0.0009150505 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0008988380 | SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '214245' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name |
0.0008988380 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '') |
0.0008831024 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/column_left' |
0.0008831024 | SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '46') ORDER BY tr1.priority ASC |
0.0008728504 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'product/category_grid' |
0.0008649826 | SET time_zone = '+00:00' |
0.0008528233 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0008478165 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header_compare' |
0.0008389950 | SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '24717' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name |
0.0008261204 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru') |
0.0008108616 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru') |
0.0007920265 | SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '25167' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name |
0.0007889271 | UPDATE oc_category SET image ='' WHERE image IS NULL |
0.0007729530 | SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '24718' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name |
0.0007691383 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/search' OR route = 'ru-ru') |
0.0007610321 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru') |
0.0007569790 | SELECT * FROM oc_category_to_layout WHERE category_id = '24' AND store_id = '0' |
0.0007519722 | SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '4' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' |
0.0007410049 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/module/callback' |
0.0007379055 | SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '23' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
0.0007371902 | SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '24716' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name |
0.0007290840 | SELECT * FROM oc_category_to_layout WHERE category_id = '24' AND store_id = '0' |
0.0007278919 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru') |
0.0007169247 | SELECT `data` FROM `oc_session` WHERE `session_id` = '9802a5925943a834dff44a0d01' AND `expire` > '2025-08-02 07:04:17' |
0.0007059574 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0007059574 | SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '9' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' |
0.0007040501 | SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '24715' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name |
0.0006880760 | SELECT * FROM oc_category_to_layout WHERE category_id = '24' AND store_id = '0' |
0.0006818771 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'product/buyclick_form' |
0.0006661415 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header_5' |
0.0006649494 | SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '24' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
0.0006551743 | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
0.0006511211 | SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '214244' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name |
0.0006339550 | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
0.0006330013 | SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '7' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' |
0.0006189346 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header' |
0.0006170273 | SELECT category_id, image, parent_id FROM oc_category WHERE image='' |
0.0006089211 | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
0.0006029606 | SELECT * FROM oc_product_image WHERE product_id = '25167' ORDER BY sort_order ASC |
0.0005910397 | SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '24718' |
0.0005829334 | SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '25151' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name |
0.0005829334 | SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '24319' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name |
0.0005710125 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/language' |
0.0005710125 | SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '24761' |
0.0005691051 | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
0.0005631447 | SELECT * FROM oc_product_image WHERE product_id = '24718' ORDER BY sort_order ASC |
0.0005609989 | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
0.0005571842 | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order |
0.0005540848 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru') |
0.0005531311 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header_nav_v_drop' |
0.0005528927 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru') |
0.0005519390 | SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '46') ORDER BY tr1.priority ASC |
0.0005519390 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'checkout/checkout' OR route = 'ru-ru') |
0.0005519390 | SELECT * FROM oc_ocfilter_setting |
0.0005450249 | SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '24715' |
0.0005450249 | SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '24217' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name |
0.0005421638 | SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '214245' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name |
0.0005409718 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/content_top' |
0.0005340576 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0005338192 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0005319118 | SELECT * FROM oc_cart WHERE customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0005280972 | SET time_zone = '+00:00' |
0.0005280972 | SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` ASC |
0.0005278587 | SELECT * FROM oc_product_image WHERE product_id = '24735' ORDER BY sort_order ASC |
0.0005259514 | SELECT * FROM oc_product_image WHERE product_id = '24717' ORDER BY sort_order ASC |
0.0005249977 | SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '25152' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name |
0.0005240440 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru') |
0.0005221367 | SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '25167' |
0.0005109310 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/currency' |
0.0005059242 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0004990101 | SELECT * FROM oc_product_image WHERE product_id = '24715' ORDER BY sort_order ASC |
0.0004980564 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/search' |
0.0004949570 | SELECT category_id, image, parent_id FROM oc_category WHERE image='' |
0.0004861355 | SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '214248' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name |
0.0004820824 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0004749298 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/category' OR route = 'ru-ru') |
0.0004730225 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0004708767 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/column_right' |
0.0004680157 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'product/category' |
0.0004580021 | SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '14' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' |
0.0004541874 | SELECT * FROM oc_product_image WHERE product_id = '24319' ORDER BY sort_order ASC |
0.0004451275 | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'content_bottom' ORDER BY sort_order |
0.0004448891 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0004398823 | SELECT * FROM oc_product_image WHERE product_id = '24716' ORDER BY sort_order ASC |
0.0004370213 | SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '24717' |
0.0004251003 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0004210472 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/content_bottom' |
0.0004160404 | SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://atlantpro24.ru/' |
0.0004148483 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/prostoresets' OR route = 'ru-ru') |
0.0004119873 | SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '24716' |
0.0004048347 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'ru-ru') |
0.0004022121 | SELECT * FROM oc_product_image WHERE product_id = '25152' ORDER BY sort_order ASC |
0.0004010201 | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order |
0.0003931522 | SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '24735' |
0.0003929138 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header_nav_cust' |
0.0003900528 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0003840923 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/credit' OR route = 'ru-ru') |
0.0003840923 | SELECT * FROM oc_weight_class wc LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1' |
0.0003819466 | SELECT * FROM oc_product_image WHERE product_id = '214245' ORDER BY sort_order ASC |
0.0003738403 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0003721714 | SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '24319' |
0.0003719330 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0003640652 | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order |
0.0003628731 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'ru-ru') |
0.0003619194 | SELECT * FROM oc_product_image WHERE product_id = '24216' ORDER BY sort_order ASC |
0.0003609657 | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND `code` = 'ocfilter' |
0.0003578663 | SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '214248' |
0.0003550053 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0003550053 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0003519058 | SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '214245' |
0.0003480911 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0003449917 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0003352165 | SELECT * FROM oc_length_class mc LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1' |
0.0003318787 | SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '25151' |
0.0003309250 | SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '214244' |
0.0003290176 | SELECT * FROM oc_ocfilter_setting WHERE `key` = 'placement_layout' |
0.0003280640 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0003271103 | SET SQL_BIG_SELECTS = 1 |
0.0003259182 | SELECT * FROM oc_extension WHERE `type` = 'total' |
0.0003249645 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0003190041 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'product/buyclick_form' |
0.0003180504 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'checkout/checkout' OR route = 'ru-ru') |
0.0003118515 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0003070831 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/cart' |
0.0003068447 | SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '25152' |
0.0003039837 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0003030300 | SELECT SUM(amount) AS total FROM oc_customer_transaction WHERE customer_id = '0' |
0.0003030300 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru') |
0.0003011227 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0002961159 | DELETE FROM oc_cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR) |
0.0002818108 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |
0.0002748966 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9802a5925943a834dff44a0d01' |