22.29 ms (66.03%)
|
81 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.active AS active_3, t0.force_display AS force_display_4, t0.type AS type_5, t0.date_add AS date_add_6, t0.date_up AS date_up_7, t0.level AS level_8, t0.name AS name_9, t0.description AS description_10, t0.slug AS slug_11, t0.parent_id AS parent_id_12 FROM mg_categories t0 WHERE t0.id = ? AND t0.active = ?
SELECT t0.id AS id_1, t0.position AS position_2, t0.active AS active_3, t0.force_display AS force_display_4, t0.type AS type_5, t0.date_add AS date_add_6, t0.date_up AS date_up_7, t0.level AS level_8, t0.name AS name_9, t0.description AS description_10, t0.slug AS slug_11, t0.parent_id AS parent_id_12 FROM mg_categories t0 WHERE t0.id = 2 AND t0.active = 1;
|
5.20 ms (15.40%)
|
1 |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.purshasing_price AS purshasing_price_3, t0.selling_price AS selling_price_4, t0.selling_price_all_taxes AS selling_price_all_taxes_5, t0.sales_unit AS sales_unit_6, t0.min_quantity AS min_quantity_7, t0.max_quantity AS max_quantity_8, t0.bulk_quantity AS bulk_quantity_9, t0.discount AS discount_10, t0.discount_type AS discount_type_11, t0.discount_on_taxe AS discount_on_taxe_12, t0.stock_management AS stock_management_13, t0.quantity AS quantity_14, t0.sell_out_of_stock AS sell_out_of_stock_15, t0.stock_alert AS stock_alert_16, t0.pre_order AS pre_order_17, t0.available_date AS available_date_18, t0.date_publish AS date_publish_19, t0.offline AS offline_20, t0.type AS type_21, t0.date_add AS date_add_22, t0.date_up AS date_up_23, t0.additionnal_shipping_cost AS additionnal_shipping_cost_24, t0.width AS width_25, t0.height AS height_26, t0.depth AS depth_27, t0.weight AS weight_28, t0.name AS name_29, t0.summary AS summary_30, t0.slug AS slug_31, t0.description AS description_32, t0.supplier_id AS supplier_id_33, t0.gamme_id AS gamme_id_34, t0.carrier_id AS carrier_id_35, t0.parent_id AS parent_id_36, t0.taxe_id AS taxe_id_37 FROM mg_products t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"CONCORDE-MKII-TWIN-SCRATCH"
]
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.purshasing_price AS purshasing_price_3, t0.selling_price AS selling_price_4, t0.selling_price_all_taxes AS selling_price_all_taxes_5, t0.sales_unit AS sales_unit_6, t0.min_quantity AS min_quantity_7, t0.max_quantity AS max_quantity_8, t0.bulk_quantity AS bulk_quantity_9, t0.discount AS discount_10, t0.discount_type AS discount_type_11, t0.discount_on_taxe AS discount_on_taxe_12, t0.stock_management AS stock_management_13, t0.quantity AS quantity_14, t0.sell_out_of_stock AS sell_out_of_stock_15, t0.stock_alert AS stock_alert_16, t0.pre_order AS pre_order_17, t0.available_date AS available_date_18, t0.date_publish AS date_publish_19, t0.offline AS offline_20, t0.type AS type_21, t0.date_add AS date_add_22, t0.date_up AS date_up_23, t0.additionnal_shipping_cost AS additionnal_shipping_cost_24, t0.width AS width_25, t0.height AS height_26, t0.depth AS depth_27, t0.weight AS weight_28, t0.name AS name_29, t0.summary AS summary_30, t0.slug AS slug_31, t0.description AS description_32, t0.supplier_id AS supplier_id_33, t0.gamme_id AS gamme_id_34, t0.carrier_id AS carrier_id_35, t0.parent_id AS parent_id_36, t0.taxe_id AS taxe_id_37 FROM mg_products t0 WHERE t0.slug = 'CONCORDE-MKII-TWIN-SCRATCH' LIMIT 1;
|
1.13 ms (3.34%)
|
1 |
SELECT t0.id AS id_1, t0.size AS size_2, t0.position AS position_3, t0.cover AS cover_4, t0.mime_type AS mime_type_5, t0.product_id AS product_id_6 FROM mg_products_images t0 WHERE t0.product_id = ? AND t0.cover = ? LIMIT 1
SELECT t0.id AS id_1, t0.size AS size_2, t0.position AS position_3, t0.cover AS cover_4, t0.mime_type AS mime_type_5, t0.product_id AS product_id_6 FROM mg_products_images t0 WHERE t0.product_id = 2071 AND t0.cover = 1 LIMIT 1;
|
1.05 ms (3.12%)
|
1 |
SELECT m0_.id AS id_0, m0_.position AS position_1, m0_.active AS active_2, m0_.force_display AS force_display_3, m0_.type AS type_4, m0_.date_add AS date_add_5, m0_.date_up AS date_up_6, m0_.level AS level_7, m0_.name AS name_8, m0_.description AS description_9, m0_.slug AS slug_10, m0_.parent_id AS parent_id_11 FROM mg_categories m0_ WHERE m0_.active = 1 AND m0_.id <> 1 AND m0_.level < 3 ORDER BY m0_.position ASC
SELECT m0_.id AS id_0, m0_.position AS position_1, m0_.active AS active_2, m0_.force_display AS force_display_3, m0_.type AS type_4, m0_.date_add AS date_add_5, m0_.date_up AS date_up_6, m0_.level AS level_7, m0_.name AS name_8, m0_.description AS description_9, m0_.slug AS slug_10, m0_.parent_id AS parent_id_11 FROM mg_categories m0_ WHERE m0_.active = 1 AND m0_.id <> 1 AND m0_.level < 3 ORDER BY m0_.position ASC;
|
0.97 ms (2.86%)
|
1 |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.purshasing_price AS purshasing_price_3, t0.selling_price AS selling_price_4, t0.selling_price_all_taxes AS selling_price_all_taxes_5, t0.sales_unit AS sales_unit_6, t0.min_quantity AS min_quantity_7, t0.max_quantity AS max_quantity_8, t0.bulk_quantity AS bulk_quantity_9, t0.discount AS discount_10, t0.discount_type AS discount_type_11, t0.discount_on_taxe AS discount_on_taxe_12, t0.stock_management AS stock_management_13, t0.quantity AS quantity_14, t0.sell_out_of_stock AS sell_out_of_stock_15, t0.stock_alert AS stock_alert_16, t0.pre_order AS pre_order_17, t0.available_date AS available_date_18, t0.date_publish AS date_publish_19, t0.offline AS offline_20, t0.type AS type_21, t0.date_add AS date_add_22, t0.date_up AS date_up_23, t0.additionnal_shipping_cost AS additionnal_shipping_cost_24, t0.width AS width_25, t0.height AS height_26, t0.depth AS depth_27, t0.weight AS weight_28, t0.name AS name_29, t0.summary AS summary_30, t0.slug AS slug_31, t0.description AS description_32, t0.supplier_id AS supplier_id_33, t0.gamme_id AS gamme_id_34, t0.carrier_id AS carrier_id_35, t0.parent_id AS parent_id_36, t0.taxe_id AS taxe_id_37 FROM mg_products t0 WHERE t0.parent_id = ? AND t0.offline = ? LIMIT 1
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.purshasing_price AS purshasing_price_3, t0.selling_price AS selling_price_4, t0.selling_price_all_taxes AS selling_price_all_taxes_5, t0.sales_unit AS sales_unit_6, t0.min_quantity AS min_quantity_7, t0.max_quantity AS max_quantity_8, t0.bulk_quantity AS bulk_quantity_9, t0.discount AS discount_10, t0.discount_type AS discount_type_11, t0.discount_on_taxe AS discount_on_taxe_12, t0.stock_management AS stock_management_13, t0.quantity AS quantity_14, t0.sell_out_of_stock AS sell_out_of_stock_15, t0.stock_alert AS stock_alert_16, t0.pre_order AS pre_order_17, t0.available_date AS available_date_18, t0.date_publish AS date_publish_19, t0.offline AS offline_20, t0.type AS type_21, t0.date_add AS date_add_22, t0.date_up AS date_up_23, t0.additionnal_shipping_cost AS additionnal_shipping_cost_24, t0.width AS width_25, t0.height AS height_26, t0.depth AS depth_27, t0.weight AS weight_28, t0.name AS name_29, t0.summary AS summary_30, t0.slug AS slug_31, t0.description AS description_32, t0.supplier_id AS supplier_id_33, t0.gamme_id AS gamme_id_34, t0.carrier_id AS carrier_id_35, t0.parent_id AS parent_id_36, t0.taxe_id AS taxe_id_37 FROM mg_products t0 WHERE t0.parent_id = 2071 AND t0.offline = 0 LIMIT 1;
|
0.70 ms (2.07%)
|
2 |
SELECT t0.id AS id_1, t0.address_title AS address_title_2, t0.parameter_address_id AS parameter_address_id_3, t0.lang_id AS lang_id_4 FROM mg_parameters_addresses_title t0 WHERE t0.parameter_address_id = ?
SELECT t0.id AS id_1, t0.address_title AS address_title_2, t0.parameter_address_id AS parameter_address_id_3, t0.lang_id AS lang_id_4 FROM mg_parameters_addresses_title t0 WHERE t0.parameter_address_id = 1;
|
0.58 ms (1.71%)
|
1 |
SELECT t0.id AS id_1, t0.size AS size_2, t0.position AS position_3, t0.cover AS cover_4, t0.mime_type AS mime_type_5, t0.product_id AS product_id_6 FROM mg_products_images t0 WHERE t0.product_id = ? AND t0.cover = ?
SELECT t0.id AS id_1, t0.size AS size_2, t0.position AS position_3, t0.cover AS cover_4, t0.mime_type AS mime_type_5, t0.product_id AS product_id_6 FROM mg_products_images t0 WHERE t0.product_id = 2071 AND t0.cover = 0;
|
0.49 ms (1.46%)
|
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slogan AS slogan_3, t0.seo_description AS seo_description_4, t0.email_contact AS email_contact_5, t0.email_order AS email_order_6, t0.logo AS logo_7, t0.nb_posts AS nb_posts_8 FROM mg_parameters t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.slogan AS slogan_3, t0.seo_description AS seo_description_4, t0.email_contact AS email_contact_5, t0.email_order AS email_order_6, t0.logo AS logo_7, t0.nb_posts AS nb_posts_8 FROM mg_parameters t0 WHERE t0.id = 1;
|
0.40 ms (1.18%)
|
1 |
SELECT t0.id AS id_1, t0.supplier_name AS supplier_name_2, t0.supplier_address AS supplier_address_3, t0.supplier_zipcode AS supplier_zipcode_4, t0.supplier_town AS supplier_town_5, t0.supplier_phone AS supplier_phone_6, t0.supplier_email AS supplier_email_7, t0.supplier_web AS supplier_web_8, t0.supplier_logo AS supplier_logo_9, t0.suppliers_notes AS suppliers_notes_10 FROM mg_suppliers t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.supplier_name AS supplier_name_2, t0.supplier_address AS supplier_address_3, t0.supplier_zipcode AS supplier_zipcode_4, t0.supplier_town AS supplier_town_5, t0.supplier_phone AS supplier_phone_6, t0.supplier_email AS supplier_email_7, t0.supplier_web AS supplier_web_8, t0.supplier_logo AS supplier_logo_9, t0.suppliers_notes AS suppliers_notes_10 FROM mg_suppliers t0 WHERE t0.id = 36;
|
0.36 ms (1.07%)
|
1 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.property_id AS property_id_3, t4.id AS id_5, t4.type AS type_6, t4.position AS position_7, t4.name AS name_8, t4.slug AS slug_9, t0.product_id AS product_id_10 FROM mg_properties_contents t0 INNER JOIN mg_properties t4 ON t0.property_id = t4.id WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.value AS value_2, t0.property_id AS property_id_3, t4.id AS id_5, t4.type AS type_6, t4.position AS position_7, t4.name AS name_8, t4.slug AS slug_9, t0.product_id AS product_id_10 FROM mg_properties_contents t0 INNER JOIN mg_properties t4 ON t0.property_id = t4.id WHERE t0.product_id = 2071;
|
0.33 ms (0.97%)
|
1 |
SELECT t0.id AS id_1, t0.address AS address_2, t0.zipcode AS zipcode_3, t0.town AS town_4, t0.phone AS phone_5, t0.mobile AS mobile_6, t0.email AS email_7, t0.map AS map_8, t0.opening_time AS opening_time_9 FROM mg_parameters_addresses t0
SELECT t0.id AS id_1, t0.address AS address_2, t0.zipcode AS zipcode_3, t0.town AS town_4, t0.phone AS phone_5, t0.mobile AS mobile_6, t0.email AS email_7, t0.map AS map_8, t0.opening_time AS opening_time_9 FROM mg_parameters_addresses t0;
|
0.27 ms (0.81%)
|
1 |
SELECT t0.id AS id_1, t0.taxe_rate AS taxe_rate_2, t0.taxe_active AS taxe_active_3 FROM mg_taxes t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.taxe_rate AS taxe_rate_2, t0.taxe_active AS taxe_active_3 FROM mg_taxes t0 WHERE t0.id = 3;
|