| # | Query time (s) | Controller | Query |
|---|
| 1 | 0.0007 | | SELECT value FROM oc_setting WHERE store_id = '0' AND `key`='config_seo_url_type' |
| 2 | 0.0001 | | SET SQL_BIG_SELECTS = 1 |
| 3 | 0.0004 | | SHOW TABLES LIKE 'oc_ocfilter_setting' |
| 4 | 0.0002 | | SELECT * FROM oc_ocfilter_setting |
| 5 | 0.0001 | ControllerStartupStartup | SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://warcam.ru/' |
| 6 | 0.003 | ControllerStartupStartup | SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC |
| 7 | 0.0004 | ControllerEventCompatibility | SELECT f1.offname f1_name, f1.shortname f1_shortname, f1.fias_id f1_fias_id, f1.level f1_level, f1.postalcode f1_postalcode, f2.offname f2_name, f2.shortname f2_shortname, f2.fias_id f2_fias_id, f2.level f2_level, f3.offname f3_name, f3.shortname f3_shortname, f3.fias_id f3_fias_id, f3.level f3_level, f4.offname f4_name, f4.shortname f4_shortname, f4.fias_id f4_fias_id, f4.level f4_level, f4.parent_id f4_parent_id
FROM fias f1
LEFT JOIN fias f2 ON f2.fias_id = f1.parent_id
LEFT JOIN fias f3 ON f3.fias_id = f2.parent_id
LEFT JOIN fias f4 ON f4.fias_id = f3.parent_id
WHERE f1.fias_id = 41 |
| 8 | 0.0005 | ControllerEventCompatibility | SELECT fias_id, offname, shortname, altnames FROM fias WHERE `level` = 1 |
| 9 | 0.0042 | ControllerEventCompatibility | SELECT zone_id, name FROM oc_zone WHERE name IN ('ufa','уфа','башкортостан','башкортостан респ.','республика башкортостан','башкортостан республика','kursk','курск','курская','курская обл.','курская область','stavropol','ставрополь','ставропольский','ставропольский край','salekhard','салехард','ямало-ненецкий','ямало-ненецкий ао','belgorod','белгород','белгородская','белгородская обл.','белгородская область','khanty-mansiysk','ханты-мансийский ао - югра','ханты-мансийск','ханты-мансийский','ханты-мансийский ао','vladivostok','владивосток','приморский','приморский край','petrozavodsk','петрозаводск','карелия','карелия респ.','республика карелия','карелия республика','anadyr','анадырь','чукотский','чукотский ао','moskow region','московская','московская обл.','московская область','ivanovo','иваново','ивановская','ивановская обл.','ивановская область','petropavlovsk-kamchatskiy','петропавловск-камчатский','камчатский','камчатский край','krasnodar','краснодар','краснодарский','краснодарский край','карачаево-черкеcсия','cherkessk','карачаево-черкесия','черкесск','карачаево-черкесская','карачаево-черкесская респ.','республика карачаево-черкесская','карачаево-черкесская республика','orel','орел','орловская','орловская обл.','орловская область','чувашская республика','cheboksary','чебоксары','чувашия','чувашия респ.','республика чувашия','чувашия республика','magadan','магадан','магаданская','магаданская обл.','магаданская область','kemerovo','кемерово','кемеровская','кемеровская обл.','кемеровская область','еврейская ао','birobidzhan','биробиджан','еврейская','еврейская аобл.','irkutsk','иркутск','иркутская','иркутская обл.','иркутская область','gorno-altaysk','горно-алтайск','алтай','алтай респ.','республика алтай','алтай республика','vologda','вологда','вологодская','вологодская обл.','вологодская область','penza','пенза','пензенская','пензенская обл.','пензенская область','yekaterinburg','екатеринбург','свердловская','свердловская обл.','свердловская область','ul\'yanovsk','ульяновск','ульяновская','ульяновская обл.','ульяновская область','syktyvkar','сыктывкар','коми','коми респ.','республика коми','коми республика','elista','элиста','калмыкия','калмыкия респ.','республика калмыкия','калмыкия республика','республика северная осетия','vladikavkaz','владикавказ','северная осетия - алания','северная осетия - алания респ.','республика северная осетия - алания','северная осетия - алания республика','kazan','казань','татарстан','татарстан респ.','республика татарстан','татарстан республика','smolensk','смоленск','смоленская','смоленская обл.','смоленская область','blagoveshchensk','благовещенск','амурская','амурская обл.','амурская область','kaluga','калуга','калужская','калужская обл.','калужская область','tomsk','томск','томская','томская обл.','томская область','orenburg','оренбург','оренбургская','оренбургская обл.','оренбургская область','bryansk','брянск','брянская','брянская обл.','брянская область','kalinigrad','калининград','калининградская','калининградская обл.','калининградская область','kurgan','курган','курганская','курганская обл.','курганская область','tula','тула','тульская','тульская обл.','тульская область','moscow','москва','москва г.','perm','пермь','пермский','пермский край','bayqongyr city','bayqongyr','байконур - город республ-го значения','байконур','байконур г.','vyatka','kirov','киров','кировская','кировская обл.','кировская область','arkahangelsk','архангельск','архангельская','архангельская обл.','архангельская область','murmansk','мурманск','мурманская','мурманская обл.','мурманская область','tambov','тамбов','тамбовская','тамбовская обл.','тамбовская область','makhachkala','махачкала','дагестан','дагестан респ.','республика дагестан','дагестан республика','kostroma','кострома','костромская','костромская обл.','костромская область','izhevsk','ижевск','удмуртская','удмуртская респ.','республика удмуртская','удмуртская республика','novosibirsk','новосибирск','новосибирская','новосибирская обл.','новосибирская область','республика саха','yakutsk','саха / якутия','саха/якутия','республика саха / якутия','республика саха/якутия','якутск','саха (якутия)','саха (якутия) респ.','республика саха (якутия)','саха (якутия) республика','ulan-ude','улан-удэ','бурятия','бурятия респ.','республика бурятия','бурятия республика','nazran','magas','назрань','магас','ингушетия','ингушетия респ.','республика ингушетия','ингушетия республика','novgorod','новгород','новгородская','новгородская обл.','новгородская область','groznyy','грозный','чеченская','чеченская респ.','республика чеченская','чеченская республика','saratov','саратов','саратовская','саратовская обл.','саратовская область','maykop','майкоп','адыгея','адыгея респ.','республика адыгея','адыгея республика','krasnoyarsk','красноярск','красноярский','красноярский край','ленинградская','ленинградская обл.','ленинградская область','yoshkar-ola','йошкар-ола','марий эл','марий эл респ.','республика марий эл','марий эл республика','chita','чита','забайкальский','забайкальский край','khabarovsk','хабаровск','хабаровский','хабаровский край','astrakhan','астрахань','астраханская','астраханская обл.','астраханская область','abakan','абакан','хакасия','хакасия респ.','республика хакасия','хакасия республика','lipetsk','липецк','липецкая','липецкая обл.','липецкая область','yaroslavl','ярославль','ярославская','ярославская обл.','ярославская область','nizhniy novgorod','нижний новгород','нижегородская','нижегородская обл.','нижегородская область','pskov','псков','псковская','псковская обл.','псковская область','ryazan','рязань','рязанская','рязанская обл.','рязанская область','omsk','омск','омская','омская обл.','омская область','vladimir','владимир','владимирская','владимирская обл.','владимирская область','saransk','саранск','мордовия','мордовия респ.','республика мордовия','мордовия республика','tver','тверь','тверская','тверская обл.','тверская область','volgograd','волгоград','волгоградская','волгоградская обл.','волгоградская область','naryan mar','нарьян-мар','ненецкий','ненецкий ао','kyzyl','кызыл','тыва','тыва респ.','республика тыва','тыва республика','южно-сахалинск','сахалинская','сахалинская обл.','сахалинская область','республика кабардино-балкария','nalchik','нальчик','кабардино-балкарская','кабардино-балкарская респ.','республика кабардино-балкарская','кабардино-балкарская республика','chelyabinsk','челябинск','челябинская','челябинская обл.','челябинская область','barnaul','барнаул','алтайский','алтайский край','st. petersburg','санкт-петербург','санкт-петербург','санкт-петербург г.','voronezh','воронеж','воронежская','воронежская обл.','воронежская область','rostov-na-donu','ростов-на-дону','ростовская','ростовская обл.','ростовская область','samara','самара','самарская','самарская обл.','самарская область','tyumen','тюмень','тюменская','тюменская обл.','тюменская область','sevastopol\'','севастополь','севастополь г.','крым','crimea','крым','крым респ.','республика крым','крым республика','брест','brestskaya (brest)','brest','брестская','брестская обл.','брестская область','витебск','vitsyebskaya (vitsyebsk)','vitsyebsk','витебская','витебская обл.','витебская область','гомель','homyel\'skaya (homyel\')','homyel\'','гомельская','гомельская обл.','гомельская область','гродно','hrodzyenskaya (hrodna)','hrodna','гродненская','гродненская обл.','гродненская область','minskaya','минская','минская обл.','минская область','минск','horad minsk','minsk','минск','минск г.','могилев','mahilyowskaya (mahilyow)','mahilyow','могилевская','могилевская обл.','могилевская область','донецк','donets\'ka oblast\'','донецька область','донецкая','донецкая обл.','донецкая область','запорожье','zaporiz\'ka oblast\'','запорізька область','запорожская','запорожская обл.','запорожская область','кировоград','kirovohrads\'ka oblast\'','кропивницкий','кіровоградська область','кировоградская','кировоградская обл.','кировоградская область','луганск','luhans\'ka oblast\'','луганська область','луганская','луганская обл.','луганская область','одесса','odes\'ka oblast\'','одеська область','одесская','одесская обл.','одесская область','житомир','zhytomyrs\'ka oblast\'','житомирська область','житомирская','житомирская обл.','житомирская область','днепропетровск','dnipropetrovs\'ka oblast\'','днепр','дніпропетровська область','днепропетровская','днепропетровская обл.','днепропетровская область','николаев','mykolayivs\'ka oblast\'','миколаївська область','николаевская','николаевская обл.','николаевская область','сумы','sums\'ka oblast\'','сумська область','сумская','сумская обл.','сумская область','харьков','kharkivs\'ka oblast\'','харківська область','харьковская','харьковская обл.','харьковская область','винница','vinnyts\'ka oblast\'','вінницька область','винницкая','винницкая обл.','винницкая область','kyivs\'ka oblast\'','київська область','киевская','киевская обл.','киевская область','чернигов','chernihivs\'ka oblast\'','чернігівська область','черниговская','черниговская обл.','черниговская область','хмельницкий','khmel\'nyts\'ka oblast\'','хмельницька область','хмельницкая','хмельницкая обл.','хмельницкая область','херсон','khersons\'ka oblast\'','херсонська область','херсонская','херсонская обл.','херсонская область','ужгород','zakarpats\'ka oblast\'','закарпатська область','закарпатская','закарпатская обл.','закарпатская область','тернополь','ternopil\'s\'ka oblast\'','тернопільська область','тернопольская','тернопольская обл.','тернопольская область','ровно','rivnens\'ka oblast\'','рівненська область','ровненская','ровненская обл.','ровненская область','ивано-франковск','ivano-frankivs\'ka oblast\'','івано-франківська область','ивано-франковская','ивано-франковская обл.','ивано-франковская область','львов','l\'vivs\'ka oblast\'','львівська область','львовская','львовская обл.','львовская область','черкассы','cherkas\'ka oblast\'','черкаська область','черкасская','черкасская обл.','черкасская область','полтава','poltavs\'ka oblast\'','полтавська область','полтавская','полтавская обл.','полтавская область','черновцы','chernivets\'ka oblast\'','чернівецька область','черновицкая','черновицкая обл.','черновицкая область','луцк','volyns\'ka oblast\'','волинська область','волынская','волынская обл.','волынская область','kyiv','київ','киев','киев г.','aqmola','акмолинская','акмолинская обл.','акмолинская область','aqtobe','актюбинская','актюбинская обл.','актюбинская область','almaty','алматинская','алматинская обл.','алматинская область','atyrau','атырауская','атырауская обл.','атырауская область','batys qazaqstan','западно-казахстанская','западно-казахстанская обл.','западно-казахстанская область','zhambyl','жамбылская','жамбылская обл.','жамбылская область','qaraghandy','карагандинская','карагандинская обл.','карагандинская область','qostanay','костанайская','костанайская обл.','костанайская область','qyzylorda','кызылординская','кызылординская обл.','кызылординская область','mangghystau','мангистауская','мангистауская обл.','мангистауская область','ongtustik qazaqstan','turkestan','южно-казахстанская область','туркестанская','туркестанская обл.','туркестанская область','pavlodar','павлодарская','павлодарская обл.','павлодарская область','soltustik qazaqstan','северо-казахстанская','северо-казахстанская обл.','северо-казахстанская область','shyghys qazaqstan','восточно-казахстанская','восточно-казахстанская обл.','восточно-казахстанская область','астана - город республ-го значения','астана','нур-султан - город республ-го значения','astana city','nur-sultan','нур-султан','нур-султан г.','алматы - город республ-го значения','almaty city','алматы','алматы г.','шымкент - город республ-го значения','shymkent','шымкент','шымкент г.') |
| 10 | 0.0003 | ControllerEventCompatibility | SELECT fias_id, offname, altnames FROM fias WHERE `level` = 0 |
| 11 | 0.0001 | ControllerEventCompatibility | SELECT country_id, name FROM oc_country WHERE name IN ('российская федерация','russian federation','russia','россия','белоруссия (беларусь)','беларусь','belarus','белоруссия','беларусь','ukraine','україна','украина','kazakhstan','казахстан') |
| 12 | 0.0003 | ControllerEventCompatibility | SELECT * FROM oc_currency |
| 13 | 0.0005 | ControllerEventCompatibility | 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 = '2761') ORDER BY tr1.priority ASC |
| 14 | 0.0003 | ControllerEventCompatibility | 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 = 'payment' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2761') ORDER BY tr1.priority ASC |
| 15 | 0.0003 | ControllerEventCompatibility | 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 = '2761') ORDER BY tr1.priority ASC |
| 16 | 0.0002 | ControllerEventCompatibility | 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' |
| 17 | 0.0001 | ControllerEventCompatibility | 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' |
| 18 | 0.0001 | ControllerEventCompatibility | DELETE FROM oc_cart WHERE date_added < DATE_SUB(NOW(), INTERVAL '30' DAY) |
| 19 | 0.0004 | ControllerEventCompatibility | SHOW TABLES LIKE 'oc_cartkeeper' |
| 20 | 0.0004 | ControllerEventCompatibility | SHOW TABLES LIKE 'oc_cartkeeper_share' |
| 21 | 0.0004 | ControllerEventCompatibility | DELETE FROM oc_cartkeeper WHERE date_added < DATE_SUB(NOW(), INTERVAL '30' DAY) |
| 22 | 0.0001 | ControllerEventCompatibility | DELETE FROM oc_cartkeeper_share WHERE customer_id = '0' AND date_added < DATE_SUB(NOW(), INTERVAL '3' DAY) |
| 23 | 0.0001 | ControllerEventCompatibility | DELETE FROM oc_cartkeeper_share WHERE customer_id != '0' AND date_added < DATE_SUB(NOW(), INTERVAL '14' DAY) |
| 24 | 0.0001 | ControllerEventCompatibility | SELECT `session_id` FROM `oc_cart` WHERE `session_id` = '883fb1b43233c87ca87681ec16ca9156' LIMIT 1 |
| 25 | 0.0002 | ControllerStartupEvent | SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC |
| 26 | 0.0011 | ControllerStartupSeoPro | SELECT category_id, parent_id FROM oc_category ORDER BY parent_id |
| 27 | 0.0003 | ControllerStartupSeoPro | SELECT query FROM oc_url_alias WHERE keyword = 'magnitoly' LIMIT 1 |
| 28 | 0.0002 | ControllerStartupSeoPro | SELECT query FROM oc_url_alias WHERE keyword = 'chevrolet' LIMIT 1 |
| 29 | 0.0001 | ControllerStartupSeoPro | SELECT query FROM oc_url_alias WHERE keyword = 'chevrolet-captiva-i-2011-2015-canbox-h-line-5612-1036-na-android-10-4g-sim-4-64-dsp-qled-tesla' LIMIT 1 |
| 30 | 0.0001 | ControllerStartupSeoPro | SELECT query FROM oc_url_alias WHERE keyword = 'magnitoly/chevrolet/chevrolet-captiva-i-2011-2015-canbox-h-line-5612-1036-na-android-10-4g-sim-4-64-dsp-qled-tesla' LIMIT 1 |
| 31 | 0.0001 | ControllerStartupSeoPro | SELECT category_id FROM oc_product_to_category WHERE product_id = '123029' ORDER BY main_category DESC LIMIT 1 |
| 32 | 0.0001 | ControllerStartupSeoPro | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 33 | 0.0001 | ControllerStartupSeoPro | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=165' LIMIT 1 |
| 34 | 0.0001 | ControllerStartupSeoPro | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=123029' LIMIT 1 |
| 35 | 0.0001 | ControllerProductProduct | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'common/home' LIMIT 1 |
| 36 | 0.0002 | ControllerProductProduct | 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 = '69' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 37 | 0.0001 | ControllerProductProduct | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 38 | 0.0001 | ControllerProductProduct | 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 = '165' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 39 | 0.0001 | ControllerProductProduct | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 40 | 0.0001 | ControllerProductProduct | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=165' LIMIT 1 |
| 41 | 0.0001 | ControllerProductProduct | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'common/home' LIMIT 1 |
| 42 | 0.0001 | ControllerProductProduct | SELECT MAX(category_id) as category_id FROM oc_product_to_category WHERE product_id =123029 |
| 43 | 0.0001 | ControllerProductProduct | SELECT parent_id FROM oc_category WHERE category_id =401 |
| 44 | 0.0001 | ControllerProductProduct | SELECT parent_id FROM oc_category WHERE category_id =165 |
| 45 | 0.0001 | ControllerProductProduct | 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 = '69' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 46 | 0.0001 | ControllerProductProduct | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 47 | 0.0001 | ControllerProductProduct | 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 = '165' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 48 | 0.0001 | ControllerProductProduct | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 49 | 0.0001 | ControllerProductProduct | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=165' LIMIT 1 |
| 50 | 0.0002 | ControllerProductProduct | 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 = '401' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 51 | 0.0001 | ControllerProductProduct | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 52 | 0.0001 | ControllerProductProduct | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=165' LIMIT 1 |
| 53 | 0.0001 | ControllerProductProduct | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=401' LIMIT 1 |
| 54 | 0.0007 | ControllerProductProduct | SELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '123029' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 55 | 0.0002 | ControllerProductProduct | SELECT p2c.product_id, p2c.category_id, p2c.main_category FROM oc_product_to_category p2c
LEFT JOIN oc_category_description cd ON (p2c.category_id = cd.category_id)
WHERE product_id = '123029'
ORDER BY cd.name ASC
|
| 56 | 0.0002 | ControllerProductProduct | 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 = '401' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 57 | 0.0001 | ControllerProductProduct | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 58 | 0.0001 | ControllerProductProduct | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=165' LIMIT 1 |
| 59 | 0.0001 | ControllerProductProduct | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=401' LIMIT 1 |
| 60 | 0.0002 | ControllerProductProduct | 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 = '165' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
| 61 | 0.0001 | ControllerProductProduct | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'captcha/basic_captcha/captcha' LIMIT 1 |
| 62 | 0.0002 | ControllerProductProduct | SELECT SQL_CALC_FOUND_ROWS q.* FROM oc_qa q INNER JOIN oc_qa_to_store q2s ON (q.qa_id = q2s.qa_id) LEFT JOIN oc_product p ON (q.product_id = p.product_id) WHERE p.product_id = '123029' AND q2s.store_id = '0' AND q.status = '1' ORDER BY q.date_asked DESC |
| 63 | 0.0001 | ControllerProductProduct | SELECT FOUND_ROWS() AS count |
| 64 | 0.0001 | ControllerProductProduct | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=123029' LIMIT 1 |
| 65 | 0.0001 | ControllerExtensionModuleOCFilter | SELECT category_id FROM oc_product_to_category WHERE product_id = '123029' ORDER BY main_category DESC LIMIT 1 |
| 66 | 0.0001 | ControllerExtensionModuleOCFilter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 67 | 0.0001 | ControllerExtensionModuleOCFilter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=165' LIMIT 1 |
| 68 | 0.0001 | ControllerExtensionModuleOCFilter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=123029' LIMIT 1 |
| 69 | 0.0001 | ControllerExtensionModuleOCFilter | SELECT category_id FROM oc_product_to_category WHERE product_id = '123029' ORDER BY main_category DESC LIMIT 1 |
| 70 | 0.0001 | ControllerExtensionModuleOCFilter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 71 | 0.0001 | ControllerExtensionModuleOCFilter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=165' LIMIT 1 |
| 72 | 0.0001 | ControllerExtensionModuleOCFilter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=123029' LIMIT 1 |
| 73 | 0.0001 | ControllerExtensionModuleOCFilter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/login' LIMIT 1 |
| 74 | 0.0001 | ControllerExtensionModuleOCFilter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/register' LIMIT 1 |
| 75 | 0.0001 | ControllerExtensionModuleOCFilter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=136' LIMIT 1 |
| 76 | 0.0001 | ControllerExtensionModuleOCFilter | SELECT * FROM oc_product_image WHERE product_id = '123029' ORDER BY sort_order ASC |
| 77 | 0.0007 | ControllerExtensionModuleOCFilter | SELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '46669' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 78 | 0.0003 | ControllerExtensionModuleOCFilter | SELECT * FROM oc_product_image WHERE product_id = '46669' ORDER BY sort_order ASC |
| 79 | 0.0008 | ControllerExtensionModuleOCFilter | SELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '123712' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 80 | 0.0002 | ControllerExtensionModuleOCFilter | SELECT * FROM oc_product_image WHERE product_id = '123712' ORDER BY sort_order ASC |
| 81 | 0.0003 | ControllerExtensionModuleOCFilter | SELECT * FROM oc_product_discount WHERE product_id = '123029' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY quantity ASC, priority ASC, price ASC |
| 82 | 0.0005 | ControllerExtensionModuleOCFilter | SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '123029' AND od.language_id = '1' ORDER BY o.sort_order |
| 83 | 0.0005 | ControllerExtensionModuleOCFilter | SELECT * FROM oc_product_option_value pov LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id) LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id) WHERE pov.product_id = '123029' AND pov.product_option_id = '487074' AND ovd.language_id = '1' ORDER BY ov.sort_order |
| 84 | 0.0004 | ControllerExtensionModuleOCFilter | SELECT * FROM oc_product_option_value pov LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id) LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id) WHERE pov.product_id = '123029' AND pov.product_option_id = '487073' AND ovd.language_id = '1' ORDER BY ov.sort_order |
| 85 | 0.0005 | ControllerExtensionModuleOCFilter | SELECT * FROM oc_product_option_value pov LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id) LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id) WHERE pov.product_id = '123029' AND pov.product_option_id = '487072' AND ovd.language_id = '1' ORDER BY ov.sort_order |
| 86 | 0.0004 | ControllerEventCompatibility | SELECT COUNT(*) AS total FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '123029' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1' |
| 87 | 0.0002 | ControllerEventCompatibility | SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '123029' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1' ORDER BY r.date_added DESC LIMIT 0,5 |
| 88 | 0.0001 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '123029' ORDER BY main_category DESC LIMIT 1 |
| 89 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 90 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=165' LIMIT 1 |
| 91 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=123029' LIMIT 1 |
| 92 | 0.0007 | ControllerEventCompatibility | SELECT ag.attribute_group_id, agd.name, agd.tooltip 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 = '123029' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name |
| 93 | 0.0005 | ControllerEventCompatibility | SELECT a.attribute_id, ad.name, ad.tooltip,
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 = '123029' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name |
| 94 | 0.0005 | ControllerEventCompatibility | SELECT a.attribute_id, ad.name, ad.tooltip,
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 = '123029' AND a.attribute_group_id = '18' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name |
| 95 | 0.0004 | ControllerEventCompatibility | SELECT a.attribute_id, ad.name, ad.tooltip,
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 = '123029' AND a.attribute_group_id = '22' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name |
| 96 | 0.0004 | ControllerEventCompatibility | SELECT a.attribute_id, ad.name, ad.tooltip,
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 = '123029' AND a.attribute_group_id = '19' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name |
| 97 | 0.0004 | ControllerEventCompatibility | SELECT a.attribute_id, ad.name, ad.tooltip,
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 = '123029' AND a.attribute_group_id = '21' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name |
| 98 | 0.0004 | ControllerEventCompatibility | SELECT a.attribute_id, ad.name, ad.tooltip,
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 = '123029' AND a.attribute_group_id = '20' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name |
| 99 | 0.0006 | ControllerEventCompatibility | SELECT * FROM oc_product_related pr LEFT JOIN oc_product p ON (pr.related_id = p.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pr.product_id = '123029' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' LIMIT 20 |
| 100 | 0.0003 | ControllerEventCompatibility | SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 123029 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC |
| 101 | 0.0002 | ControllerEventCompatibility | UPDATE oc_product SET viewed = (viewed + 1) WHERE product_id = '123029' |
| 102 | 0.0002 | ControllerExtensionModuleMicrodataPro | SELECT author, date_added, rating, text FROM oc_review WHERE product_id = '123029' AND status = '1' ORDER BY date_added DESC |
| 103 | 0.0001 | ControllerProductExtendedReviews | SELECT * FROM oc_product_to_layout WHERE product_id = '123029' AND store_id = '0' |
| 104 | 0.0002 | ControllerProductExtendedReviews | SELECT * FROM oc_layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 105 | 0.0001 | ControllerProductExtendedReviews | SELECT * FROM oc_layout_module WHERE layout_id = '2' AND `code` = 'ocfilter' |
| 106 | 0.0001 | ControllerProductExtendedReviews | SELECT * FROM oc_ocfilter_setting WHERE `key` = 'placement_layout' |
| 107 | 0.0002 | ControllerProductExtendedReviews | SELECT * FROM oc_product WHERE product_id = '123029' |
| 108 | 0.0001 | ControllerEventCompatibility | SELECT *, CONCAT(filter_id, '.', source) AS filter_key FROM oc_ocfilter_filter_value_to_product WHERE product_id = '123029' |
| 109 | 0.0001 | ControllerEventCompatibility | SELECT *, CONCAT(filter_id, '.', source) AS filter_key FROM oc_ocfilter_filter_range_to_product WHERE product_id = '123029' |
| 110 | 0.0001 | ControllerEventCompatibility | SELECT * FROM oc_product_special WHERE product_id = '123029' AND customer_group_id = '1' AND ((date_start = '0000-00-00' OR date_start < '2024-11-24') AND (date_end = '0000-00-00' OR date_end > '2024-11-24')) LIMIT 1 |
| 111 | 0.0001 | ControllerEventCompatibility | SELECT * FROM oc_product_discount WHERE product_id = '123029' AND customer_group_id = '1' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < '2024-11-24') AND (date_end = '0000-00-00' OR date_end > '2024-11-24')) LIMIT 1 |
| 112 | 0.0003 | ControllerEventCompatibility | SELECT p.page_id, p.params, p.params_count, p.category_id, pd.name, pd.heading_title, (SELECT GROUP_CONCAT(DISTINCT cp.path_id ORDER BY cp.`level` SEPARATOR '_') AS path FROM oc_category_path cp WHERE cp.category_id = p.category_id) AS path, (SELECT ua.keyword FROM oc_url_alias ua WHERE ua.`query` = CONCAT('ocfilter_page_id=', p.page_id) LIMIT 1) AS keyword FROM oc_ocfilter_page p LEFT JOIN oc_ocfilter_page_description pd ON (p.page_id = pd.page_id) LEFT JOIN oc_product_to_category p2c ON (p.category_id = p2c.category_id) WHERE p.status = '1' AND p.dynamic = '0' AND pd.language_id = '1' AND p2c.product_id = '123029' AND p.product = '1' ORDER BY p.params_count DESC |
| 113 | 0.0001 | ControllerCommonColumnLeft | SELECT * FROM oc_product_to_layout WHERE product_id = '123029' AND store_id = '0' |
| 114 | 0.0001 | ControllerCommonColumnLeft | SELECT * FROM oc_layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 115 | 0.0001 | ControllerCommonColumnLeft | SELECT * FROM oc_layout_module WHERE layout_id = '2' AND position = 'column_left' ORDER BY sort_order |
| 116 | 0.0001 | ControllerEventCompatibility | SELECT * FROM oc_module WHERE module_id = '45' |
| 117 | 0.0001 | ControllerEventCompatibility | SELECT * FROM oc_module WHERE module_id = '40' |
| 118 | 0.0001 | ControllerEventCompatibility | SELECT * FROM oc_module WHERE module_id = '36' |
| 119 | 0.0001 | ControllerEventCompatibility | SELECT * FROM oc_module WHERE module_id = '37' |
| 120 | 0.0001 | ControllerEventCompatibility | SELECT * FROM oc_module WHERE module_id = '39' |
| 121 | 0.0001 | ControllerCommonColumnRight | SELECT * FROM oc_product_to_layout WHERE product_id = '123029' AND store_id = '0' |
| 122 | 0.0002 | ControllerCommonColumnRight | SELECT * FROM oc_layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 123 | 0.0001 | ControllerCommonColumnRight | SELECT * FROM oc_layout_module WHERE layout_id = '2' AND position = 'column_right' ORDER BY sort_order |
| 124 | 0.0001 | ControllerCommonContentTop | SELECT * FROM oc_product_to_layout WHERE product_id = '123029' AND store_id = '0' |
| 125 | 0.0001 | ControllerCommonContentTop | SELECT * FROM oc_layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 126 | 0.0001 | ControllerCommonContentTop | SELECT * FROM oc_layout_module WHERE layout_id = '2' AND position = 'content_top' ORDER BY sort_order |
| 127 | 0.0001 | ControllerCommonContentBottom | SELECT * FROM oc_product_to_layout WHERE product_id = '123029' AND store_id = '0' |
| 128 | 0.0002 | ControllerCommonContentBottom | SELECT * FROM oc_layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 129 | 0.0001 | ControllerCommonContentBottom | SELECT * FROM oc_layout_module WHERE layout_id = '2' AND position = 'content_bottom' ORDER BY sort_order |
| 130 | 0.0001 | ControllerEventCompatibility | SELECT * FROM oc_module WHERE module_id = '43' |
| 131 | 0.0002 | ControllerCommonFooter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'information/contact' LIMIT 1 |
| 132 | 0.0001 | ControllerCommonFooter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/return/add' LIMIT 1 |
| 133 | 0.0001 | ControllerCommonFooter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'information/sitemap' LIMIT 1 |
| 134 | 0.0001 | ControllerCommonFooter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product/manufacturer' LIMIT 1 |
| 135 | 0.0001 | ControllerCommonFooter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/voucher' LIMIT 1 |
| 136 | 0.0001 | ControllerCommonFooter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'affiliate/account' LIMIT 1 |
| 137 | 0.0001 | ControllerCommonFooter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product/special' LIMIT 1 |
| 138 | 0.0001 | ControllerCommonFooter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/account' LIMIT 1 |
| 139 | 0.0001 | ControllerCommonFooter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/order' LIMIT 1 |
| 140 | 0.0001 | ControllerCommonFooter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/wishlist' LIMIT 1 |
| 141 | 0.0001 | ControllerCommonFooter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/newsletter' LIMIT 1 |
| 142 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product/compare' LIMIT 1 |
| 143 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/wishlist' LIMIT 1 |
| 144 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'checkout/cart' LIMIT 1 |
| 145 | 0.0001 | ControllerExtensionModuleMicrodataPro | SELECT * FROM oc_store ORDER BY url |
| 146 | 0.0001 | ControllerCommonHeader | SELECT * FROM oc_extension WHERE `type` = 'analytics' |
| 147 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/account' LIMIT 1 |
| 148 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/logout' LIMIT 1 |
| 149 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'common/home' LIMIT 1 |
| 150 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/wishlist' LIMIT 1 |
| 151 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/account' LIMIT 1 |
| 152 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/register' LIMIT 1 |
| 153 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/login' LIMIT 1 |
| 154 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/order' LIMIT 1 |
| 155 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/transaction' LIMIT 1 |
| 156 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/download' LIMIT 1 |
| 157 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/logout' LIMIT 1 |
| 158 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'checkout/cart' LIMIT 1 |
| 159 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'checkout/checkout' LIMIT 1 |
| 160 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'information/contact' LIMIT 1 |
| 161 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product/compare' LIMIT 1 |
| 162 | 0.0001 | ControllerEventCompatibility | SELECT SUM(quantity) as total FROM oc_cart WHERE api_id = '0' AND session_id = '883fb1b43233c87ca87681ec16ca9156' |
| 163 | 0.0002 | ControllerCommonLanguage | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'common/language/language' LIMIT 1 |
| 164 | 0.0002 | ControllerCommonLanguage | SELECT category_id FROM oc_product_to_category WHERE product_id = '123029' ORDER BY main_category DESC LIMIT 1 |
| 165 | 0.0001 | ControllerCommonLanguage | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 166 | 0.0001 | ControllerCommonLanguage | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=165' LIMIT 1 |
| 167 | 0.0001 | ControllerCommonLanguage | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=123029' LIMIT 1 |
| 168 | 0.0001 | ControllerCommonCurrency | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'common/currency/currency' LIMIT 1 |
| 169 | 0.0002 | ControllerCommonCurrency | SELECT category_id FROM oc_product_to_category WHERE product_id = '123029' ORDER BY main_category DESC LIMIT 1 |
| 170 | 0.0001 | ControllerCommonCurrency | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 171 | 0.0001 | ControllerCommonCurrency | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=165' LIMIT 1 |
| 172 | 0.0001 | ControllerCommonCurrency | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=123029' LIMIT 1 |
| 173 | 0.0002 | ControllerCommonCart | SELECT * FROM oc_cart WHERE api_id = '0' AND session_id = '883fb1b43233c87ca87681ec16ca9156' |
| 174 | 0.0001 | ControllerCommonCart | SELECT * FROM oc_extension WHERE `type` = 'total' |
| 175 | 0.0001 | ControllerEventCompatibility | SELECT * FROM oc_cart WHERE api_id = '0' AND session_id = '883fb1b43233c87ca87681ec16ca9156' |
| 176 | 0.0002 | ControllerEventCompatibility | SELECT SUM(amount) AS total FROM oc_customer_transaction WHERE customer_id = '0' |
| 177 | 0.0002 | ControllerEventCompatibility | SELECT SUM(quantity) as total FROM oc_cart WHERE api_id = '0' AND session_id = '883fb1b43233c87ca87681ec16ca9156' |
| 178 | 0.0001 | ControllerEventCompatibility | SELECT SUM(quantity) as total FROM oc_cart WHERE api_id = '0' AND session_id = '883fb1b43233c87ca87681ec16ca9156' |
| 179 | 0.0001 | ControllerEventCompatibility | SELECT * FROM oc_cart WHERE api_id = '0' AND session_id = '883fb1b43233c87ca87681ec16ca9156' |
| 180 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'checkout/cart' LIMIT 1 |
| 181 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'checkout/checkout' LIMIT 1 |
