| # | Query time (s) | Controller | Query |
|---|
| 1 | 0.0009 | | 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.0003 | | SHOW TABLES LIKE 'oc_ocfilter_setting' |
| 4 | 0.0002 | | SELECT * FROM oc_ocfilter_setting |
| 5 | 0.0001 | | DELETE FROM oc_ocfilter_cache WHERE `expire` < '1732725530' |
| 6 | 0.0001 | ControllerStartupStartup | SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://warcam.ru/' |
| 7 | 0.0022 | ControllerStartupStartup | SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC |
| 8 | 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 |
| 9 | 0.0005 | ControllerEventCompatibility | SELECT fias_id, offname, shortname, altnames FROM fias WHERE `level` = 1 |
| 10 | 0.0029 | 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','шымкент','шымкент г.') |
| 11 | 0.0003 | ControllerEventCompatibility | SELECT fias_id, offname, altnames FROM fias WHERE `level` = 0 |
| 12 | 0.0003 | ControllerEventCompatibility | SELECT country_id, name FROM oc_country WHERE name IN ('российская федерация','russian federation','russia','россия','белоруссия (беларусь)','беларусь','belarus','белоруссия','беларусь','ukraine','україна','украина','kazakhstan','казахстан') |
| 13 | 0.0002 | ControllerEventCompatibility | SELECT * FROM oc_currency |
| 14 | 0.0004 | 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 |
| 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 = '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 |
| 16 | 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 |
| 17 | 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' |
| 18 | 0.0002 | 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' |
| 19 | 0.0001 | ControllerEventCompatibility | DELETE FROM oc_cart WHERE date_added < DATE_SUB(NOW(), INTERVAL '30' DAY) |
| 20 | 0.0004 | ControllerEventCompatibility | SHOW TABLES LIKE 'oc_cartkeeper' |
| 21 | 0.0003 | ControllerEventCompatibility | SHOW TABLES LIKE 'oc_cartkeeper_share' |
| 22 | 0.0003 | ControllerEventCompatibility | DELETE FROM oc_cartkeeper WHERE date_added < DATE_SUB(NOW(), INTERVAL '30' DAY) |
| 23 | 0.0001 | ControllerEventCompatibility | DELETE FROM oc_cartkeeper_share WHERE customer_id = '0' AND date_added < DATE_SUB(NOW(), INTERVAL '3' DAY) |
| 24 | 0.0001 | ControllerEventCompatibility | DELETE FROM oc_cartkeeper_share WHERE customer_id != '0' AND date_added < DATE_SUB(NOW(), INTERVAL '14' DAY) |
| 25 | 0.0001 | ControllerEventCompatibility | SELECT `session_id` FROM `oc_cart` WHERE `session_id` = 'e43aa8d2c2e5cfcc0270fa32be2d6722' LIMIT 1 |
| 26 | 0.0001 | ControllerStartupEvent | SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC |
| 27 | 0.0013 | ControllerStartupSeoPro | SELECT category_id, parent_id FROM oc_category ORDER BY parent_id |
| 28 | 0.0002 | ControllerStartupSeoPro | SELECT query FROM oc_url_alias WHERE keyword = 'teyes' LIMIT 1 |
| 29 | 0.0001 | ControllerStartupSeoPro | SELECT query FROM oc_url_alias WHERE keyword = 'teyes' LIMIT 1 |
| 30 | 0.0001 | ControllerStartupSeoPro | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=179' LIMIT 1 |
| 31 | 0.0001 | ControllerProductManufacturer | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'common/home' LIMIT 1 |
| 32 | 0.0001 | ControllerProductManufacturer | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product/manufacturer' LIMIT 1 |
| 33 | 0.0002 | ControllerProductManufacturer | SELECT DISTINCT *, md.name AS name FROM oc_manufacturer m LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE md.language_id = '1' && m.manufacturer_id = '179' AND m2s.store_id = '0' |
| 34 | 0.0001 | ControllerProductManufacturer | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=179' LIMIT 1 |
| 35 | 0.0001 | ControllerProductManufacturer | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product/compare' LIMIT 1 |
| 36 | 0.0003 | ControllerEventCompatibility | SELECT * FROM oc_layout_route WHERE 'product/manufacturer/info' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 37 | 0.0001 | ControllerEventCompatibility | SELECT * FROM oc_layout_module WHERE layout_id = '15' AND `code` = 'ocfilter' |
| 38 | 0.0001 | ControllerEventCompatibility | SELECT * FROM oc_ocfilter_setting WHERE `key` = 'placement_layout' |
| 39 | 0.0925 | ControllerEventCompatibility | SELECT COUNT(DISTINCT p.product_id) AS total 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) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.catalog_output = '1' AND p.manufacturer_id = '179' |
| 40 | 0.466 | ControllerEventCompatibility | SELECT p.product_id,
(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 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 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) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.catalog_output = '1' AND p.manufacturer_id = '179' GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 6400,32 |
| 41 | 0.0009 | ControllerEventCompatibility | 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 = '69677' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 42 | 0.0012 | ControllerEventCompatibility | 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 = '65057' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 43 | 0.001 | ControllerEventCompatibility | 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 = '65452' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 44 | 0.0009 | ControllerEventCompatibility | 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 = '62848' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 45 | 0.001 | ControllerEventCompatibility | 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 = '74755' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 46 | 0.0009 | ControllerEventCompatibility | 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 = '64277' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 47 | 0.0008 | ControllerEventCompatibility | 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 = '64178' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 48 | 0.0008 | ControllerEventCompatibility | 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 = '73040' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 49 | 0.0008 | ControllerEventCompatibility | 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 = '72111' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 50 | 0.0011 | ControllerEventCompatibility | 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 = '64647' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 51 | 0.0009 | ControllerEventCompatibility | 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 = '65193' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 52 | 0.0008 | ControllerEventCompatibility | 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 = '129561' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 53 | 0.0009 | ControllerEventCompatibility | 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 = '129562' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 54 | 0.0008 | ControllerEventCompatibility | 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 = '129563' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 55 | 0.0007 | ControllerEventCompatibility | 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 = '129568' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 56 | 0.0008 | ControllerEventCompatibility | 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 = '129567' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 57 | 0.0007 | ControllerEventCompatibility | 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 = '140842' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 58 | 0.0007 | ControllerEventCompatibility | 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 = '140843' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 59 | 0.0007 | ControllerEventCompatibility | 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 = '140841' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 60 | 0.0007 | ControllerEventCompatibility | 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 = '129542' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 61 | 0.0008 | ControllerEventCompatibility | 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 = '129558' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 62 | 0.0007 | ControllerEventCompatibility | 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 = '129557' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 63 | 0.0008 | ControllerEventCompatibility | 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 = '129559' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 64 | 0.0008 | ControllerEventCompatibility | 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 = '129564' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 65 | 0.0007 | ControllerEventCompatibility | 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 = '129565' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 66 | 0.0007 | ControllerEventCompatibility | 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 = '129566' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 67 | 0.0007 | ControllerEventCompatibility | 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 = '129560' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 68 | 0.0008 | ControllerEventCompatibility | 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 = '129569' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 69 | 0.0007 | ControllerEventCompatibility | 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 = '110707' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 70 | 0.0008 | ControllerEventCompatibility | 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 = '110706' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 71 | 0.0014 | ControllerEventCompatibility | 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 = '110705' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 72 | 0.0019 | ControllerEventCompatibility | 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 = '110700' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
| 73 | 0.0003 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '69677' ORDER BY main_category DESC LIMIT 1 |
| 74 | 0.0002 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 75 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 76 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=69677' LIMIT 1 |
| 77 | 0.0002 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '65057' ORDER BY main_category DESC LIMIT 1 |
| 78 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 79 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 80 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=65057' LIMIT 1 |
| 81 | 0.0002 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '65452' ORDER BY main_category DESC LIMIT 1 |
| 82 | 0.0002 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 83 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 84 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=65452' LIMIT 1 |
| 85 | 0.0003 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '62848' ORDER BY main_category DESC LIMIT 1 |
| 86 | 0.0002 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 87 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 88 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=62848' LIMIT 1 |
| 89 | 0.0003 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '74755' ORDER BY main_category DESC LIMIT 1 |
| 90 | 0.0002 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 91 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 92 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=74755' LIMIT 1 |
| 93 | 0.0003 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '64277' ORDER BY main_category DESC LIMIT 1 |
| 94 | 0.0002 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 95 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 96 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=64277' LIMIT 1 |
| 97 | 0.0003 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '64178' ORDER BY main_category DESC LIMIT 1 |
| 98 | 0.0002 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 99 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 100 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=64178' LIMIT 1 |
| 101 | 0.0003 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '73040' ORDER BY main_category DESC LIMIT 1 |
| 102 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 103 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 104 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=73040' LIMIT 1 |
| 105 | 0.0003 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '72111' ORDER BY main_category DESC LIMIT 1 |
| 106 | 0.0002 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 107 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 108 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=72111' LIMIT 1 |
| 109 | 0.0002 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '64647' ORDER BY main_category DESC LIMIT 1 |
| 110 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 111 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 112 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=64647' LIMIT 1 |
| 113 | 0.0002 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '65193' ORDER BY main_category DESC LIMIT 1 |
| 114 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 115 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 116 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=65193' LIMIT 1 |
| 117 | 0.0006 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '129561' ORDER BY main_category DESC LIMIT 1 |
| 118 | 0.0003 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 119 | 0.0002 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 120 | 0.0002 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=129561' LIMIT 1 |
| 121 | 0.0003 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '129562' ORDER BY main_category DESC LIMIT 1 |
| 122 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 123 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 124 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=129562' LIMIT 1 |
| 125 | 0.0003 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '129563' ORDER BY main_category DESC LIMIT 1 |
| 126 | 0.0002 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 127 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 128 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=129563' LIMIT 1 |
| 129 | 0.0002 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '129568' ORDER BY main_category DESC LIMIT 1 |
| 130 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 131 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 132 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=129568' LIMIT 1 |
| 133 | 0.0005 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '129567' ORDER BY main_category DESC LIMIT 1 |
| 134 | 0.0003 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 135 | 0.0002 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 136 | 0.0002 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=129567' LIMIT 1 |
| 137 | 0.0005 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '140842' ORDER BY main_category DESC LIMIT 1 |
| 138 | 0.0002 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 139 | 0.0002 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 140 | 0.0002 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=140842' LIMIT 1 |
| 141 | 0.0003 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '140843' ORDER BY main_category DESC LIMIT 1 |
| 142 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 143 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 144 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=140843' LIMIT 1 |
| 145 | 0.0003 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '140841' ORDER BY main_category DESC LIMIT 1 |
| 146 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 147 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 148 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=140841' LIMIT 1 |
| 149 | 0.0003 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '129542' ORDER BY main_category DESC LIMIT 1 |
| 150 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 151 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 152 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=129542' LIMIT 1 |
| 153 | 0.0002 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '129558' ORDER BY main_category DESC LIMIT 1 |
| 154 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 155 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 156 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=129558' LIMIT 1 |
| 157 | 0.0002 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '129557' ORDER BY main_category DESC LIMIT 1 |
| 158 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 159 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 160 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=129557' LIMIT 1 |
| 161 | 0.0002 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '129559' ORDER BY main_category DESC LIMIT 1 |
| 162 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 163 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 164 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=129559' LIMIT 1 |
| 165 | 0.0003 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '129564' ORDER BY main_category DESC LIMIT 1 |
| 166 | 0.0002 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 167 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 168 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=129564' LIMIT 1 |
| 169 | 0.0004 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '129565' ORDER BY main_category DESC LIMIT 1 |
| 170 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 171 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 172 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=129565' LIMIT 1 |
| 173 | 0.0003 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '129566' ORDER BY main_category DESC LIMIT 1 |
| 174 | 0.0002 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 175 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 176 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=129566' LIMIT 1 |
| 177 | 0.0003 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '129560' ORDER BY main_category DESC LIMIT 1 |
| 178 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 179 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 180 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=129560' LIMIT 1 |
| 181 | 0.0002 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '129569' ORDER BY main_category DESC LIMIT 1 |
| 182 | 0.0002 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 183 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 184 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=129569' LIMIT 1 |
| 185 | 0.0003 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '110707' ORDER BY main_category DESC LIMIT 1 |
| 186 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 187 | 0.0002 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 188 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=110707' LIMIT 1 |
| 189 | 0.0004 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '110706' ORDER BY main_category DESC LIMIT 1 |
| 190 | 0.0003 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 191 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 192 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=110706' LIMIT 1 |
| 193 | 0.0003 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '110705' ORDER BY main_category DESC LIMIT 1 |
| 194 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 195 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 196 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=110705' LIMIT 1 |
| 197 | 0.0003 | ControllerEventCompatibility | SELECT category_id FROM oc_product_to_category WHERE product_id = '110700' ORDER BY main_category DESC LIMIT 1 |
| 198 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=69' LIMIT 1 |
| 199 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=161' LIMIT 1 |
| 200 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=110700' LIMIT 1 |
| 201 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=179' LIMIT 1 |
| 202 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=179' LIMIT 1 |
| 203 | 0.0003 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=179' LIMIT 1 |
| 204 | 0.0002 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=179' LIMIT 1 |
| 205 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=179' LIMIT 1 |
| 206 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=179' LIMIT 1 |
| 207 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=179' LIMIT 1 |
| 208 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=179' LIMIT 1 |
| 209 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=179' LIMIT 1 |
| 210 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=179' LIMIT 1 |
| 211 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=179' LIMIT 1 |
| 212 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=179' LIMIT 1 |
| 213 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=179' LIMIT 1 |
| 214 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=179' LIMIT 1 |
| 215 | 0.0001 | ControllerExtensionModuleMicrodataPro | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=179' LIMIT 1 |
| 216 | 0.0002 | ControllerExtensionModuleMicrodataPro | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=179' LIMIT 1 |
| 217 | 0.0001 | ControllerExtensionModuleMicrodataPro | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=179' LIMIT 1 |
| 218 | 0.0001 | ControllerExtensionModuleMicrodataPro | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'common/home' LIMIT 1 |
| 219 | 0.0002 | ControllerCommonColumnLeft | SELECT * FROM oc_layout_route WHERE 'product/manufacturer/info' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 220 | 0.0001 | ControllerCommonColumnLeft | SELECT * FROM oc_layout_module WHERE layout_id = '15' AND position = 'column_left' ORDER BY sort_order |
| 221 | 0.0005 | ControllerCommonColumnRight | SELECT * FROM oc_layout_route WHERE 'product/manufacturer/info' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 222 | 0.0002 | ControllerCommonColumnRight | SELECT * FROM oc_layout_module WHERE layout_id = '15' AND position = 'column_right' ORDER BY sort_order |
| 223 | 0.0002 | ControllerCommonContentTop | SELECT * FROM oc_layout_route WHERE 'product/manufacturer/info' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 224 | 0.0001 | ControllerCommonContentTop | SELECT * FROM oc_layout_module WHERE layout_id = '15' AND position = 'content_top' ORDER BY sort_order |
| 225 | 0.0002 | ControllerCommonContentBottom | SELECT * FROM oc_layout_route WHERE 'product/manufacturer/info' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| 226 | 0.0001 | ControllerCommonContentBottom | SELECT * FROM oc_layout_module WHERE layout_id = '15' AND position = 'content_bottom' ORDER BY sort_order |
| 227 | 0.0003 | ControllerCommonFooter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'information/contact' LIMIT 1 |
| 228 | 0.0001 | ControllerCommonFooter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/return/add' LIMIT 1 |
| 229 | 0.0001 | ControllerCommonFooter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'information/sitemap' LIMIT 1 |
| 230 | 0.0001 | ControllerCommonFooter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product/manufacturer' LIMIT 1 |
| 231 | 0.0001 | ControllerCommonFooter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/voucher' LIMIT 1 |
| 232 | 0.0001 | ControllerCommonFooter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'affiliate/account' LIMIT 1 |
| 233 | 0.0001 | ControllerCommonFooter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product/special' LIMIT 1 |
| 234 | 0.0001 | ControllerCommonFooter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/account' LIMIT 1 |
| 235 | 0.0001 | ControllerCommonFooter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/order' LIMIT 1 |
| 236 | 0.0001 | ControllerCommonFooter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/wishlist' LIMIT 1 |
| 237 | 0.0001 | ControllerCommonFooter | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/newsletter' LIMIT 1 |
| 238 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product/compare' LIMIT 1 |
| 239 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/wishlist' LIMIT 1 |
| 240 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'checkout/cart' LIMIT 1 |
| 241 | 0.0001 | ControllerExtensionModuleMicrodataPro | SELECT * FROM oc_store ORDER BY url |
| 242 | 0.0001 | ControllerCommonHeader | SELECT * FROM oc_extension WHERE `type` = 'analytics' |
| 243 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/account' LIMIT 1 |
| 244 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/logout' LIMIT 1 |
| 245 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'common/home' LIMIT 1 |
| 246 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/wishlist' LIMIT 1 |
| 247 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/account' LIMIT 1 |
| 248 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/register' LIMIT 1 |
| 249 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/login' LIMIT 1 |
| 250 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/order' LIMIT 1 |
| 251 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/transaction' LIMIT 1 |
| 252 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/download' LIMIT 1 |
| 253 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/logout' LIMIT 1 |
| 254 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'checkout/cart' LIMIT 1 |
| 255 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'checkout/checkout' LIMIT 1 |
| 256 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'information/contact' LIMIT 1 |
| 257 | 0.0001 | ControllerCommonHeader | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product/compare' LIMIT 1 |
| 258 | 0.0001 | ControllerEventCompatibility | SELECT SUM(quantity) as total FROM oc_cart WHERE api_id = '0' AND session_id = 'e43aa8d2c2e5cfcc0270fa32be2d6722' |
| 259 | 0.0004 | ControllerCommonLanguage | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'common/language/language' LIMIT 1 |
| 260 | 0.0002 | ControllerCommonLanguage | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=179' LIMIT 1 |
| 261 | 0.0001 | ControllerCommonCurrency | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'common/currency/currency' LIMIT 1 |
| 262 | 0.0002 | ControllerCommonCurrency | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=179' LIMIT 1 |
| 263 | 0.0002 | ControllerCommonCart | SELECT * FROM oc_cart WHERE api_id = '0' AND session_id = 'e43aa8d2c2e5cfcc0270fa32be2d6722' |
| 264 | 0.0001 | ControllerCommonCart | SELECT * FROM oc_extension WHERE `type` = 'total' |
| 265 | 0.0001 | ControllerEventCompatibility | SELECT * FROM oc_cart WHERE api_id = '0' AND session_id = 'e43aa8d2c2e5cfcc0270fa32be2d6722' |
| 266 | 0.0001 | ControllerEventCompatibility | SELECT SUM(amount) AS total FROM oc_customer_transaction WHERE customer_id = '0' |
| 267 | 0.0007 | ControllerEventCompatibility | SELECT SUM(quantity) as total FROM oc_cart WHERE api_id = '0' AND session_id = 'e43aa8d2c2e5cfcc0270fa32be2d6722' |
| 268 | 0.0007 | ControllerEventCompatibility | SELECT SUM(quantity) as total FROM oc_cart WHERE api_id = '0' AND session_id = 'e43aa8d2c2e5cfcc0270fa32be2d6722' |
| 269 | 0.0002 | ControllerEventCompatibility | SELECT * FROM oc_cart WHERE api_id = '0' AND session_id = 'e43aa8d2c2e5cfcc0270fa32be2d6722' |
| 270 | 0.0004 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'checkout/cart' LIMIT 1 |
| 271 | 0.0001 | ControllerEventCompatibility | SELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'checkout/checkout' LIMIT 1 |
