Некоторые товары можно забрать  совершенно бесплатно в  38 пунктах выдачи Санкт-Петербурга.

Адреса пунктов самовывоза в Вашем городе можно увидеть на интерактивной карте при оформлении заказа (выберите способ доставки "САМОВЫВОЗ" и обозначьте наиболее удобный для Вас пункт выдачи заказа.) Если пункты выдачи Главпункт  не отражаются на карте - это означает, что выбранный Вами товар  не может быть доставлен данным способом и для Вас доступны другие варианты доставки.

Оплата при получении без дополнительной комиссии.   Срок доставки 1-2 дня.

  • м. Автово — пр.Стачек, д.75 - за пав."Мастер Кебаб";
  • м. Автово2 [до 10 кг] — ул. Маршала Казакова, д.1;
  • м. Академическая — пр.Науки, д.17 к2, вверх по пандусу;
  • м. Большевиков — ул. Коллонтай, д.18;
  • м. Василеостровская — 6-я Линия В.О., д.25;
  • м. Ветеранов — пр.Ветеранов, д.36,к.2, ТЦ Манхэттен, 2 этаж;
  • м. Горьковская — Кронверкский п., д.31;
  • м. Гражданский — пр. Просвещения, д87, к1, «Северо-Муринский ун-г», 2 эт, направо;
  • м. Девяткино — п. Мурино, Привокзальная пл., д.3, к.1;
  • м. Дыбенко — Дыбенко, 27, к.1, вход со двора, ближе к метро;
  • м. Звездная2 [до 10 кг] — ул. Ленсовета, д.70;
  • м. Комендантский — Комендантская площадь, дом 8, литер «А»;
  • м. Купчино — Балканская пл., д5, к4;
  • м. Купчино2 / Дунайский — Будапештская ул., д.94/41;
  • м. Ладожская — Заневский пр, д65, к.5, лит.А ТК "Платформа";
  • м. Ленинский — Трамвайный пр, д.17, к.2, ТЦ "Нарва", секц.14;
  • м. Международная — ул. Бухарестская, д.74, к.3, ТБК "Международный", 2 эт.;
  • м. Московская — ул. Алтайская, д.16;
  • м. Озерки — пр. Энгельса, д.113, к.1, ТЦ "Бада-Бум", I эт.;
  • м. Парк Победы [до 10 кг] — Московский пр., д.173;
  • м. Петергофское ш.[до 10 кг] — Петергофское ш., д.45;
  • м. Пионерская — Коломяжский пр., д.15, корп.2;
  • м. Пл.Ленина — ул. Комсомола, д.16 (вход с Комсомола);
  • м. пр. Королёва — пр. Королева, д. 61;
  • м. Приморская — ул. Одоевского д.27, лит.А, 2 эт., сек.212 (у лифта);
  • м. Пролетарская — Ново-Александровская ул., д.14;
  • м. Просвещения — пр. Энгельса, д.137;
  • м. Просвещения2/пр. Культуры — пр. Просвещения д.51;
  • м. Сенная — Московский пр., д.3, 2 этаж, ТЦ Адмиралтейский;
  • Склад СПб — Камчатская ул., д.1Е;
  • м. Старая Деревня — Торфяная дор., д.2, к1, ТК "Старая Деревня", 3 эт., секц.29;
  • м. Удельная2 — Репищева 13к1;
  • м. ул. Моисеенко — ул. Моисеенко, д.25/24;
  • м. ул.М.Захарова [до 10 кг] — ул. Маршала Захарова, д.21;
  • м. Чёрная Речка — ул. Савушкина, д.1;
  • м. Чернышевская — ул. Фурштатская, д.25;
  • м. шоссе Революции — ш. Революции, д. 41/39А;
  • м. Электросила — ул. Решетникова, д.12, к.2;

С полным списком и географией данных пунктов выдачи вы можете ознакомиться в соответствующем разделе.


Total time: 0.3116 s | Queries: 177 | Slow queries (>0.003 s): 2

#Query time (s)ControllerQuery
10.001 SELECT value FROM setting WHERE store_id = '0' AND `key`='config_seo_url_type'
20.0002 SELECT * FROM extension WHERE `type` = 'openbay'
30.0001 ControllerStartupStartupSELECT * FROM store WHERE REPLACE(`ssl`, 'www.', '') = 'https://robofor.ru/'
40.0047 ControllerStartupStartupSELECT * FROM `setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
50.0006 ControllerStartupStartup SELECT f1.postalcode f1_postalcode, f1.offname f1_name, f1.level f1_level, f1.fias_id f1_fias_id, f1.shortname f1_shortname, CONCAT(f2.offname, ' ', f2.shortname) f2_name, f2.level f2_level, f2.fias_id f2_fias_id, CONCAT(f3.offname, ' ', f3.shortname) f3_name, f3.level f3_level, f3.fias_id f3_fias_id, CONCAT(f4.offname, ' ', f4.shortname) f4_name, f4.level f4_level, f4.fias_id f4_fias_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.offname = 'Сан-Диего' AND (f3.offname = 'США' OR f2.offname = 'США' OR f4.offname = 'США') AND (f1.level = 4 OR (f1.level = 1 AND f1.shortname = 'г.'))
60.0002 ControllerStartupStartupSELECT * FROM country c WHERE c.iso_code_2 = 'US'
70.0001 ControllerStartupStartupSELECT * FROM currency
80.0003 ControllerStartupStartupSELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM tax_rule tr1 LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN 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 = '0' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0') ORDER BY tr1.priority ASC
90.0002 ControllerStartupStartupSELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM tax_rule tr1 LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN 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 = '0' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0') ORDER BY tr1.priority ASC
100.0002 ControllerStartupStartupSELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM tax_rule tr1 LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN 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
110.0001 ControllerStartupStartupSELECT * FROM weight_class wc LEFT JOIN weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1'
120.0001 ControllerStartupStartupSELECT * FROM length_class mc LEFT JOIN length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1'
130.0007 ControllerStartupStartupDELETE FROM cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 3 MONTH)
140.0001 ControllerStartupStartupSELECT * FROM extension WHERE `type` = 'openbay'
150.0001 ControllerStartupEventSELECT * FROM `event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC
160.0013 ControllerStartupSeoProSHOW TABLES LIKE 'soconfig'
170.0003 ControllerStartupSeoProselect * from soconfig where store_id='0'
180.0005 ControllerStartupSeoProSHOW TABLES LIKE 'soconfig'
190.0002 ControllerStartupSeoProselect * from soconfig where store_id='0'
200.0006 ControllerInformationInformationSELECT DISTINCT * FROM information i LEFT JOIN information_description id ON (i.information_id = id.information_id) LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '12' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
210.0028 ControllerCommonColumnLeftSELECT * FROM information_to_layout WHERE information_id = '12' AND store_id = '0'
220.0003 ControllerCommonColumnLeftSELECT * FROM layout_route WHERE 'information/information' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
230.0003 ControllerCommonColumnLeftSELECT * FROM layout_module WHERE layout_id = '11' AND position = 'column_left' ORDER BY sort_order
240.0008 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
250.0005 ControllerEventCompatibilitySELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM category t0 LEFT JOIN category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '96'
260.0002 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '184'
270.0005 ControllerEventCompatibilitySHOW TABLES LIKE 'simple_blog_article'
280.0003 ControllerEventCompatibilitySELECT * FROM simple_blog_category WHERE simple_blog_category_id ='1' ORDER BY sort_order ASC;
290.0001 ControllerEventCompatibilitySELECT * FROM simple_blog_category WHERE parent_id ='1' AND status = '1' ORDER BY sort_order ASC;
300.0002 ControllerEventCompatibilitySELECT DISTINCT(simple_blog_article_id) FROM `simple_blog_article_to_category` WHERE simple_blog_category_id IN(1)
310.0008 ControllerEventCompatibility SELECT b.*,bd.article_title,bd.description, (SELECT COUNT(*) FROM simple_blog_comment bc WHERE bc.simple_blog_article_id = b.simple_blog_article_id) AS comment,(SELECT COUNT(*) FROM simple_blog_view bv WHERE bv.simple_blog_article_id = b.simple_blog_article_id) AS view FROM simple_blog_article b LEFT JOIN simple_blog_article_description bd ON b.simple_blog_article_id=bd.simple_blog_article_id and bd.language_id=1 WHERE b.status = '1' AND bd.language_id=1 AND b.simple_blog_article_id IN(1,2,3) ORDER BY bd.article_title ASC LIMIT 0,6
320.0002 ControllerEventCompatibilitySELECT * FROM `user`
330.0001 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '182'
340.0001 ControllerCommonColumnRightSELECT * FROM information_to_layout WHERE information_id = '12' AND store_id = '0'
350.0001 ControllerCommonColumnRightSELECT * FROM layout_route WHERE 'information/information' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
360.0001 ControllerCommonColumnRightSELECT * FROM layout_module WHERE layout_id = '11' AND position = 'column_right' ORDER BY sort_order
370.0001 ControllerCommonContentTopSELECT * FROM information_to_layout WHERE information_id = '12' AND store_id = '0'
380.0001 ControllerCommonContentTopSELECT * FROM layout_route WHERE 'information/information' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
390.0001 ControllerCommonContentTopSELECT * FROM layout_module WHERE layout_id = '11' AND position = 'content_top' ORDER BY sort_order
400.0001 ControllerCommonContentBottomSELECT * FROM information_to_layout WHERE information_id = '12' AND store_id = '0'
410.0001 ControllerCommonContentBottomSELECT * FROM layout_route WHERE 'information/information' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
420.0001 ControllerCommonContentBottomSELECT * FROM layout_module WHERE layout_id = '11' AND position = 'content_bottom' ORDER BY sort_order
430.0001 ControllerExtensionSoconfigContentFootertopSELECT * FROM information_to_layout WHERE information_id = '12' AND store_id = '0'
440.0001 ControllerExtensionSoconfigContentFootertopSELECT * FROM layout_route WHERE 'information/information' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
450.0001 ControllerExtensionSoconfigContentFootertopSELECT * FROM layout_module WHERE layout_id = '11' AND position = 'footertop' ORDER BY sort_order
460.0001 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '178'
470.0001 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '181'
480.0001 ControllerExtensionSoconfigFooterblock1SELECT * FROM information_to_layout WHERE information_id = '12' AND store_id = '0'
490.0002 ControllerExtensionSoconfigFooterblock1SELECT * FROM layout_route WHERE 'information/information' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
500.0004 ControllerExtensionSoconfigFooterblock1SELECT * FROM layout_module WHERE layout_id = '11' AND position = 'footer_block1' ORDER BY sort_order
510.0003 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '242'
520.0002 ControllerExtensionSoconfigFooterblock2SELECT * FROM information_to_layout WHERE information_id = '12' AND store_id = '0'
530.0002 ControllerExtensionSoconfigFooterblock2SELECT * FROM layout_route WHERE 'information/information' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
540.0002 ControllerExtensionSoconfigFooterblock2SELECT * FROM layout_module WHERE layout_id = '11' AND position = 'footer_block2' ORDER BY sort_order
550.0001 ControllerExtensionSoconfigFooterblock3SELECT * FROM information_to_layout WHERE information_id = '12' AND store_id = '0'
560.0002 ControllerExtensionSoconfigFooterblock3SELECT * FROM layout_route WHERE 'information/information' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
570.0002 ControllerExtensionSoconfigFooterblock3SELECT * FROM layout_module WHERE layout_id = '11' AND position = 'footer_block3' ORDER BY sort_order
580.0001 ControllerExtensionSoconfigFooterblock4SELECT * FROM information_to_layout WHERE information_id = '12' AND store_id = '0'
590.0001 ControllerExtensionSoconfigFooterblock4SELECT * FROM layout_route WHERE 'information/information' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
600.0002 ControllerExtensionSoconfigFooterblock4SELECT * FROM layout_module WHERE layout_id = '11' AND position = 'footer_block4' ORDER BY sort_order
610.0001 ControllerExtensionSoconfigFooterblock5SELECT * FROM information_to_layout WHERE information_id = '12' AND store_id = '0'
620.0001 ControllerExtensionSoconfigFooterblock5SELECT * FROM layout_route WHERE 'information/information' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
630.0002 ControllerExtensionSoconfigFooterblock5SELECT * FROM layout_module WHERE layout_id = '11' AND position = 'footer_block5' ORDER BY sort_order
640.0002 ControllerExtensionSoconfigFooterblock6SELECT * FROM information_to_layout WHERE information_id = '12' AND store_id = '0'
650.0002 ControllerExtensionSoconfigFooterblock6SELECT * FROM layout_route WHERE 'information/information' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
660.0002 ControllerExtensionSoconfigFooterblock6SELECT * FROM layout_module WHERE layout_id = '11' AND position = 'footer_block6' ORDER BY sort_order
670.0001 ControllerExtensionSoconfigContentFooterbottomSELECT * FROM information_to_layout WHERE information_id = '12' AND store_id = '0'
680.0001 ControllerExtensionSoconfigContentFooterbottomSELECT * FROM layout_route WHERE 'information/information' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
690.0001 ControllerExtensionSoconfigContentFooterbottomSELECT * FROM layout_module WHERE layout_id = '11' AND position = 'footerbottom' ORDER BY sort_order
700.0011 ControllerEventThemeSELECT * FROM information i LEFT JOIN information_description id ON (i.information_id = id.information_id) LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC
710.0002 ControllerEventThemeDELETE FROM `customer_online` WHERE date_added < '2021-09-22 13:41:26'
720.0004 ControllerEventThemeREPLACE INTO `customer_online` SET `ip` = '44.192.254.246', `customer_id` = '0', `url` = 'http://robofor.ru/dostavka_spb/', `referer` = '', `date_added` = '2021-09-22 14:41:26'
730.0004 ControllerEventThemeSHOW TABLES LIKE 'soconfig'
740.0001 ControllerEventThemeselect * from soconfig where store_id='0'
750.0001 ControllerCommonHeaderSELECT * FROM extension WHERE `type` = 'analytics'
760.0001 ControllerExtensionSoconfigContentSearchSELECT * FROM information_to_layout WHERE information_id = '12' AND store_id = '0'
770.0001 ControllerExtensionSoconfigContentSearchSELECT * FROM layout_route WHERE 'information/information' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
780.0001 ControllerExtensionSoconfigContentSearchSELECT * FROM layout_module WHERE layout_id = '11' AND position = 'content_search' ORDER BY sort_order
790.0001 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '94'
800.0007 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
810.0006 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
820.0003 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '64' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
830.0003 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '65' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
840.0003 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '66' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
850.0003 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '67' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
860.0003 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '105' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
870.0003 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '98' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
880.0004 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '104' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
890.0004 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '20' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
900.0003 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '73' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
910.0003 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '74' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
920.0004 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '18' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
930.0004 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '86' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
940.0004 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '87' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
950.0003 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '88' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
960.0003 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '89' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
970.0003 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '91' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
980.0003 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '101' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
990.0005 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '57' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
1000.0004 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '81' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
1010.0003 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '82' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
1020.0003 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '83' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
1030.0003 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '84' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
1040.0003 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '100' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
1050.0003 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '17' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
1060.0003 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '93' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
1070.0003 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '92' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
1080.0003 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '95' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
1090.0003 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '99' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
1100.0005 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '96' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
1110.1511 ControllerEventCompatibilitySELECT p.product_id, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM 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 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 SUM(op.quantity) AS total FROM order_product op LEFT JOIN `order` o ON (op.order_id = o.order_id) WHERE o.order_status_id > '0' AND op.product_id = p.product_id GROUP BY op.product_id ORDER BY total) AS sales FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN 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.status = 1 GROUP BY p.product_id ORDER BY p.viewed DESC, LCASE(pd.name) DESC LIMIT 0,5
1120.0012 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 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 review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '74' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1130.0005 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 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 review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '89' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1140.0006 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 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 review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '147' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1150.0006 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 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 review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '103' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1160.0006 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 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 review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '109' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1170.0002 ControllerExtensionSoconfigContentMenuSELECT * FROM information_to_layout WHERE information_id = '12' AND store_id = '0'
1180.0001 ControllerExtensionSoconfigContentMenuSELECT * FROM layout_route WHERE 'information/information' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
1190.0001 ControllerExtensionSoconfigContentMenuSELECT * FROM layout_module WHERE layout_id = '11' AND position = 'content_menu' ORDER BY sort_order
1200.0001 ControllerExtensionSoconfigContentMenu1SELECT * FROM information_to_layout WHERE information_id = '12' AND store_id = '0'
1210.0001 ControllerExtensionSoconfigContentMenu1SELECT * FROM layout_route WHERE 'information/information' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
1220.0001 ControllerExtensionSoconfigContentMenu1SELECT * FROM layout_module WHERE layout_id = '11' AND position = 'content_menu1' ORDER BY sort_order
1230.0001 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '124'
1240.0004 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='0' AND status='0' AND module_id = '124' ORDER BY rang
1250.0001 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='278' AND status='0' ORDER BY rang
1260.0002 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '64' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1270.0001 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1280.0001 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '65' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1290.0001 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1300.0001 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '66' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1310.0001 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1320.0001 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '67' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1330.0001 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1340.0001 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '105' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1350.0001 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1360.0001 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '98' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1370.0001 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1380.0001 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '104' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1390.0001 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1400.0007 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 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 review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '0' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1410.0002 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='287' AND status='0' ORDER BY rang
1420.0001 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='277' AND status='0' ORDER BY rang
1430.0002 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '73' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1440.0001 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '20' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1450.0001 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '74' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1460.0001 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '20' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1470.0001 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '97' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1480.0001 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '103' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1490.0005 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 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 review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '0' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1500.0001 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='289' AND status='0' ORDER BY rang
1510.0001 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='291' AND status='0' ORDER BY rang
1520.0001 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='279' AND status='0' ORDER BY rang
1530.0001 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='299' AND status='0' ORDER BY rang
1540.0001 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='280' AND status='0' ORDER BY rang
1550.0001 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='281' AND status='0' ORDER BY rang
1560.0001 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='283' AND status='0' ORDER BY rang
1570.0001 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='282' AND status='0' ORDER BY rang
1580.0001 ControllerExtensionSoconfigContentTopbarSELECT * FROM information_to_layout WHERE information_id = '12' AND store_id = '0'
1590.0001 ControllerExtensionSoconfigContentTopbarSELECT * FROM layout_route WHERE 'information/information' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
1600.0001 ControllerExtensionSoconfigContentTopbarSELECT * FROM layout_module WHERE layout_id = '11' AND position = 'content_topbar' ORDER BY sort_order
1610.0007 ControllerEventThemeSELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
1620.0004 ControllerEventThemeSELECT COUNT(DISTINCT(sbc.simple_blog_category_id)) AS total FROM `simple_blog_category` sbc LEFT JOIN `simple_blog_category_description` sbcd ON(sbc.simple_blog_category_id=sbcd.simple_blog_category_id) LEFT JOIN `simple_blog_category_to_store` sbcs ON(sbc.simple_blog_category_id=sbcs.simple_blog_category_id) WHERE sbc.parent_id='0' AND sbcd.language_id='1' AND sbcs.store_id='0' AND sbc.status=1 ORDER BY sbc.sort_order, LCASE(sbcd.name)
1630.0004 ControllerEventThemeSELECT * FROM `simple_blog_category` sbc LEFT JOIN `simple_blog_category_description` sbcd ON(sbc.simple_blog_category_id=sbcd.simple_blog_category_id) LEFT JOIN `simple_blog_category_to_store` sbcs ON(sbc.simple_blog_category_id=sbcs.simple_blog_category_id) WHERE sbc.parent_id='0' AND sbcd.language_id='1' AND sbcs.store_id='0' AND sbc.status=1 ORDER BY sbc.sort_order, LCASE(sbcd.name)
1640.0005 ControllerEventThemeSELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
1650.0004 ControllerEventThemeSELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
1660.0003 ControllerEventThemeSELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '20' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
1670.0004 ControllerEventThemeSELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '18' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
1680.0004 ControllerEventThemeSELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '57' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
1690.0003 ControllerEventThemeSELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '17' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
1700.0003 ControllerCommonCartSELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '67bbf0cbb1b452e4490334ff2d105c13'
1710.0001 ControllerCommonCartSELECT * FROM extension WHERE `type` = 'total'
1720.0001 ControllerEventCompatibilitySELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '67bbf0cbb1b452e4490334ff2d105c13'
1730.0003 ControllerEventCompatibilitySELECT SUM(amount) AS total FROM customer_transaction WHERE customer_id = '0'
1740.0002 ControllerEventCompatibilitySELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '67bbf0cbb1b452e4490334ff2d105c13'
1750.0001 ControllerEventCompatibilitySELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '67bbf0cbb1b452e4490334ff2d105c13'
1760.0004 ControllerEventThemeSHOW TABLES LIKE 'soconfig'
1770.0001 ControllerEventThemeselect * from soconfig where store_id='0'