-
SELECT p.id, p.parent_id, p.type_id, p.title, p.nodes, p.level, p.is_enabled, p.theme_id, p.page_description, t.module, t.handler FROM pages p INNER JOIN pages_types t ON p.type_id=t.id WHERE p.path='/hudy-alu-ultra-light-pinion-gear-hard-coated-38t-64/' [0 ms]
-
SELECT t.product_id AS id, COALESCE(t.name, p.name) AS name, t.meta_description, ct.page_id, pg.nodes, pg.level FROM products_translations t INNER JOIN products p ON t.product_id=p.id LEFT JOIN categories_translations ct ON p.category_id=ct.category_id AND t.lang=ct.lang LEFT JOIN pages pg ON ct.page_id=pg.id WHERE t.path='/hudy-alu-ultra-light-pinion-gear-hard-coated-38t-64/' [0 ms]
-
SELECT p.id, p.category_id, p.brand_id, COALESCE(t.name, p.name) AS name, p.image, p.is_available, p.available_quantity, p.allow_negative_quantity, p.max_visible_quantity, p.available_date, p.ordering_code, t.introduction, t.content, t.meta_description, p.ean_code, p.ordering_code, p.properties_template_id, a.label AS availability_label, a.css_class AS availability_css_class, a.schema_label AS availability_schema_label, c.nodes AS category_nodes, s.label AS sticker_label, s.css_class AS sticker_css_class, b.name AS brand_name, ROUND(LEAST(pp.price, COALESCE(ppc.price, pp.price)) * COALESCE(1 - (COALESCE(pdc.value, pdg.value, 0) / 100), 1), 2) AS price, ROUND(pp.price, 2) AS price_before, COALESCE(pvr.vat_rate, cvr.vat_rate, bvr.vat_rate, dvr.vat_rate) AS vat_rate FROM products p INNER JOIN products_translations t ON p.id=t.product_id AND t.lang='en' INNER JOIN products_availabilities a ON p.availability_id=a.id LEFT JOIN products_prices pp ON p.id=pp.product_id AND pp.min_quantity=0 LEFT JOIN products_prices_customer ppc ON ppc.customer_id=0 AND p.id=ppc.product_id AND ppc.min_quantity=0 LEFT JOIN products_discounts_customer pdc ON pdc.customer_id=0 AND p.id=pdc.product_id AND pdc.min_quantity=0 LEFT JOIN products_discounts_group pdg ON pdg.discount_group_id=0 AND p.id=pdg.product_id AND pdg.min_quantity=0 LEFT JOIN categories c ON p.category_id=c.id LEFT JOIN products_stickers s ON p.sticker_id=s.id LEFT JOIN products_brands b ON p.brand_id=b.id LEFT JOIN products_vat_rates pv ON p.id=pv.product_id AND pv.country_id=84 LEFT JOIN orders_vat_rates pvr ON pv.vat_rate_id=pvr.id LEFT JOIN orders_vat_rates cvr ON cvr.country_id=84 AND cvr.is_default=1 LEFT JOIN products_vat_rates bv ON p.id=bv.product_id AND bv.country_id=1 LEFT JOIN orders_vat_rates bvr ON bv.vat_rate_id=bvr.id LEFT JOIN orders_vat_rates dvr ON dvr.country_id=1 AND dvr.is_default=1 WHERE p.id=1221 [1 ms]
-
SELECT pg.id, COALESCE(t.name, c.name) AS title, pg.path FROM categories c INNER JOIN categories_translations t ON c.id=t.category_id AND t.lang='en' INNER JOIN pages pg ON t.page_id=pg.id WHERE c.id IN(1,4,52,53,55) AND c.level>0 ORDER BY c.level ASC [0 ms]
-
SELECT code, symbol_before, symbol_after, decimals, decimal_separator, thousands_separator, replace_zero_decimals, conversion_rate FROM orders_currencies WHERE id=1 AND is_enabled=1 [0 ms]
-
SELECT name, filename FROM products_images WHERE product_id=1221 AND is_enabled=1 ORDER BY position ASC, id ASC [1 ms]
-
SELECT url FROM products_videos WHERE product_id=1221 AND (lang IS NULL OR lang='en') ORDER BY position ASC, id ASC [0 ms]
-
SELECT name, section_name, description, filename, filetype, filesize FROM products_files WHERE product_id=1221 AND (lang IS NULL OR lang='en') ORDER BY position ASC, id ASC [0 ms]
-
SELECT c.id, COALESCE(t.name, c.name) AS name, c.image, pg.path FROM categories c INNER JOIN categories_translations t ON c.id=t.category_id AND t.lang='en' INNER JOIN pages pg ON t.page_id=pg.id WHERE c.is_enabled=1 AND c.parent_id=4 ORDER BY c.position ASC, c.id ASC [0 ms]
-
SELECT p.id, COALESCE(t.name, p.name) AS name, p.image, p.is_available, p.available_quantity, p.allow_negative_quantity, p.max_visible_quantity, p.available_date, p.ordering_code, t.path, t.introduction, a.label AS availability_label, a.css_class AS availability_css_class, s.label AS sticker_label, s.css_class AS sticker_css_class, ROUND(LEAST(pp.price, COALESCE(ppc.price, pp.price)) * COALESCE(1 - (COALESCE(pdc.value, pdg.value, 0) / 100), 1), 2) AS price, ROUND(pp.price, 2) AS price_before, COALESCE(pvr.vat_rate, cvr.vat_rate, bvr.vat_rate, dvr.vat_rate) AS vat_rate FROM products p INNER JOIN products_translations t ON p.id=t.product_id AND t.lang='en' INNER JOIN products_availabilities a ON p.availability_id=a.id INNER JOIN products_prices pp ON p.id=pp.product_id AND pp.min_quantity=0 LEFT JOIN products_prices_customer ppc ON ppc.customer_id=0 AND p.id=ppc.product_id AND ppc.min_quantity=0 LEFT JOIN products_discounts_customer pdc ON pdc.customer_id=0 AND p.id=pdc.product_id AND pdc.min_quantity=0 LEFT JOIN products_discounts_group pdg ON pdg.discount_group_id=0 AND p.id=pdg.product_id AND pdg.min_quantity=0 LEFT JOIN products_stickers s ON p.sticker_id=s.id LEFT JOIN products_vat_rates pv ON p.id=pv.product_id AND pv.country_id=84 LEFT JOIN orders_vat_rates pvr ON pv.vat_rate_id=pvr.id LEFT JOIN orders_vat_rates cvr ON cvr.country_id=84 AND cvr.is_default=1 LEFT JOIN products_vat_rates bv ON p.id=bv.product_id AND bv.country_id=1 LEFT JOIN orders_vat_rates bvr ON bv.vat_rate_id=bvr.id LEFT JOIN orders_vat_rates dvr ON dvr.country_id=1 AND dvr.is_default=1 WHERE p.id IN(835) AND p.is_visible=1 LIMIT 20 [0 ms]
-
SELECT t.name, v.value FROM products_properties p INNER JOIN products_properties_values v ON p.value_id=v.id INNER JOIN products_properties_types t ON v.type_id=t.id INNER JOIN products_properties_templates_join ppt ON ppt.template_id=1 AND ppt.type_id=t.id AND ppt.is_visible=1 WHERE p.product_id=1221 ORDER BY ppt.position ASC, t.id ASC, v.position ASC [0 ms]
-
SELECT p.id, COALESCE(t.name, p.name) AS name, p.image, p.is_available, p.available_quantity, p.allow_negative_quantity, p.max_visible_quantity, p.available_date, p.ordering_code, t.path, t.introduction, a.label AS availability_label, a.css_class AS availability_css_class, s.label AS sticker_label, s.css_class AS sticker_css_class, ROUND(LEAST(pp.price, COALESCE(ppc.price, pp.price)) * COALESCE(1 - (COALESCE(pdc.value, pdg.value, 0) / 100), 1), 2) AS price, ROUND(pp.price, 2) AS price_before, COALESCE(pvr.vat_rate, cvr.vat_rate, bvr.vat_rate, dvr.vat_rate) AS vat_rate FROM products_related r INNER JOIN products_related pr ON r.group_name=pr.group_name INNER JOIN products p ON pr.product_id=p.id INNER JOIN products_translations t ON pr.product_id=t.product_id AND t.lang='en' INNER JOIN products_availabilities a ON p.availability_id=a.id LEFT JOIN products_prices pp ON p.id=pp.product_id AND pp.min_quantity=0 LEFT JOIN products_prices_customer ppc ON ppc.customer_id=0 AND p.id=ppc.product_id AND ppc.min_quantity=0 LEFT JOIN products_discounts_customer pdc ON pdc.customer_id=0 AND p.id=pdc.product_id AND pdc.min_quantity=0 LEFT JOIN products_discounts_group pdg ON pdg.discount_group_id=0 AND p.id=pdg.product_id AND pdg.min_quantity=0 LEFT JOIN products_stickers s ON p.sticker_id=s.id LEFT JOIN products_vat_rates pv ON p.id=pv.product_id AND pv.country_id=84 LEFT JOIN orders_vat_rates pvr ON pv.vat_rate_id=pvr.id LEFT JOIN orders_vat_rates cvr ON cvr.country_id=84 AND cvr.is_default=1 LEFT JOIN products_vat_rates bv ON p.id=bv.product_id AND bv.country_id=1 LEFT JOIN orders_vat_rates bvr ON bv.vat_rate_id=bvr.id LEFT JOIN orders_vat_rates dvr ON dvr.country_id=1 AND dvr.is_default=1 WHERE r.product_id=1221 AND pr.product_id!=1221 AND p.is_visible=1 ORDER BY pr.position ASC, price ASC, p.name ASC, p.id ASC [0 ms]
-
SELECT p.id, COALESCE(t.name, p.name) AS name, p.image, p.is_available, p.available_quantity, p.allow_negative_quantity, p.max_visible_quantity, p.available_date, p.ordering_code, t.path, t.introduction, a.label AS availability_label, a.css_class AS availability_css_class, s.label AS sticker_label, s.css_class AS sticker_css_class, ROUND(LEAST(pp.price, COALESCE(ppc.price, pp.price)) * COALESCE(1 - (COALESCE(pdc.value, pdg.value, 0) / 100), 1), 2) AS price, ROUND(pp.price, 2) AS price_before, COALESCE(pvr.vat_rate, cvr.vat_rate, bvr.vat_rate, dvr.vat_rate) AS vat_rate FROM products_related_packages r INNER JOIN products_related_packages pr ON r.group_name=pr.group_name INNER JOIN products p ON pr.product_id=p.id INNER JOIN products_translations t ON pr.product_id=t.product_id AND t.lang='en' INNER JOIN products_availabilities a ON p.availability_id=a.id LEFT JOIN products_prices pp ON p.id=pp.product_id AND pp.min_quantity=0 LEFT JOIN products_prices_customer ppc ON ppc.customer_id=0 AND p.id=ppc.product_id AND ppc.min_quantity=0 LEFT JOIN products_discounts_customer pdc ON pdc.customer_id=0 AND p.id=pdc.product_id AND pdc.min_quantity=0 LEFT JOIN products_discounts_group pdg ON pdg.discount_group_id=0 AND p.id=pdg.product_id AND pdg.min_quantity=0 LEFT JOIN products_stickers s ON p.sticker_id=s.id LEFT JOIN products_vat_rates pv ON p.id=pv.product_id AND pv.country_id=84 LEFT JOIN orders_vat_rates pvr ON pv.vat_rate_id=pvr.id LEFT JOIN orders_vat_rates cvr ON cvr.country_id=84 AND cvr.is_default=1 LEFT JOIN products_vat_rates bv ON p.id=bv.product_id AND bv.country_id=1 LEFT JOIN orders_vat_rates bvr ON bv.vat_rate_id=bvr.id LEFT JOIN orders_vat_rates dvr ON dvr.country_id=1 AND dvr.is_default=1 WHERE r.product_id=1221 AND pr.product_id!=1221 AND p.is_visible=1 ORDER BY pr.position ASC, price ASC, p.id ASC [0 ms]
-
SELECT p.id, COALESCE(t.name, p.name) AS name, p.image, p.is_available, p.available_quantity, p.allow_negative_quantity, p.max_visible_quantity, p.available_date, p.ordering_code, t.path, t.introduction, a.label AS availability_label, a.css_class AS availability_css_class, s.label AS sticker_label, s.css_class AS sticker_css_class, ROUND(LEAST(pp.price, COALESCE(ppc.price, pp.price)) * COALESCE(1 - (COALESCE(pdc.value, pdg.value, 0) / 100), 1), 2) AS price, ROUND(pp.price, 2) AS price_before, COALESCE(pvr.vat_rate, cvr.vat_rate, bvr.vat_rate, dvr.vat_rate) AS vat_rate, fav.product_id IS NOT NULL AS is_favourite FROM products_accessories pa INNER JOIN products p ON pa.related_id=p.id INNER JOIN products_translations t ON pa.related_id=t.product_id AND t.lang='en' INNER JOIN products_availabilities a ON p.availability_id=a.id LEFT JOIN products_prices pp ON p.id=pp.product_id AND pp.min_quantity=0 LEFT JOIN products_prices_customer ppc ON ppc.customer_id=0 AND p.id=ppc.product_id AND ppc.min_quantity=0 LEFT JOIN products_discounts_customer pdc ON pdc.customer_id=0 AND p.id=pdc.product_id AND pdc.min_quantity=0 LEFT JOIN products_discounts_group pdg ON pdg.discount_group_id=0 AND p.id=pdg.product_id AND pdg.min_quantity=0 LEFT JOIN products_stickers s ON p.sticker_id=s.id LEFT JOIN products_vat_rates pv ON p.id=pv.product_id AND pv.country_id=84 LEFT JOIN orders_vat_rates pvr ON pv.vat_rate_id=pvr.id LEFT JOIN orders_vat_rates cvr ON cvr.country_id=84 AND cvr.is_default=1 LEFT JOIN products_vat_rates bv ON p.id=bv.product_id AND bv.country_id=1 LEFT JOIN orders_vat_rates bvr ON bv.vat_rate_id=bvr.id LEFT JOIN orders_vat_rates dvr ON dvr.country_id=1 AND dvr.is_default=1 LEFT JOIN carts_favourites fav ON p.id=fav.product_id AND fav.cart_id=0 WHERE pa.product_id=1221 AND p.is_visible=1 ORDER BY name ASC, p.id ASC [2 ms]
-
SELECT id, parent_id, type_id, title, lang, path FROM pages WHERE lang='en' AND level=1 AND is_enabled=1 AND is_visible=1 ORDER BY level ASC, position ASC, id ASC [0 ms]