| 1 |
0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM settings t0 WHERE t0.id = ?
Parameters: [
"app.host"
]
SELECT t0.id AS id_1, t0.name AS name_2 FROM settings t0 WHERE t0.id = 'app.host';
|
| 2 |
1.23 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.short_description AS short_description_3, p0_.description AS description_4, p0_.ean AS ean_5, p0_.sku AS sku_6, p0_.price AS price_7, p0_.vat AS vat_8, p0_.gross_price AS gross_price_9, p0_.stock_quantity AS stock_quantity_10, p0_.gross_weight AS gross_weight_11, p0_.package_width AS package_width_12, p0_.package_height AS package_height_13, p0_.package_length AS package_length_14, p0_.shipping_type AS shipping_type_15, p0_.is_active AS is_active_16, p0_.added_at AS added_at_17, p0_.id_product_category AS id_product_category_18, p0_.id_added_by_user AS id_added_by_user_19 FROM product p0_ INNER JOIN user u1_ ON p0_.id_added_by_user = u1_.id WHERE p0_.is_active = 1 AND u1_.is_active = 1 ORDER BY p0_.id DESC LIMIT 24
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.short_description AS short_description_3, p0_.description AS description_4, p0_.ean AS ean_5, p0_.sku AS sku_6, p0_.price AS price_7, p0_.vat AS vat_8, p0_.gross_price AS gross_price_9, p0_.stock_quantity AS stock_quantity_10, p0_.gross_weight AS gross_weight_11, p0_.package_width AS package_width_12, p0_.package_height AS package_height_13, p0_.package_length AS package_length_14, p0_.shipping_type AS shipping_type_15, p0_.is_active AS is_active_16, p0_.added_at AS added_at_17, p0_.id_product_category AS id_product_category_18, p0_.id_added_by_user AS id_added_by_user_19 FROM product p0_ INNER JOIN user u1_ ON p0_.id_added_by_user = u1_.id WHERE p0_.is_active = 1 AND u1_.is_active = 1 ORDER BY p0_.id DESC LIMIT 24;
|
| 3 |
0.24 ms |
SELECT t0.id AS id_1, t0.image AS image_2, t0.id_product AS id_product_3 FROM product_image t0 WHERE t0.id_product = ? ORDER BY t0.id ASC
SELECT t0.id AS id_1, t0.image AS image_2, t0.id_product AS id_product_3 FROM product_image t0 WHERE t0.id_product = 1 ORDER BY t0.id ASC;
|
| 4 |
0.17 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.type AS type_5, t0.is_active AS is_active_6 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.type AS type_5, t0.is_active AS is_active_6 FROM user t0 WHERE t0.id = '3';
|
| 5 |
0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.logo AS logo_5, t0.image AS image_6, t0.tin AS tin_7, t0.street AS street_8, t0.postal_code AS postal_code_9, t0.city AS city_10, t0.company_data_visible AS company_data_visible_11, t0.bank_account_number AS bank_account_number_12, t0.is_custom_subdomain AS is_custom_subdomain_13, t0.custom_domain_name AS custom_domain_name_14, t0.id_user AS id_user_15 FROM user_company t0 WHERE t0.id_user = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.logo AS logo_5, t0.image AS image_6, t0.tin AS tin_7, t0.street AS street_8, t0.postal_code AS postal_code_9, t0.city AS city_10, t0.company_data_visible AS company_data_visible_11, t0.bank_account_number AS bank_account_number_12, t0.is_custom_subdomain AS is_custom_subdomain_13, t0.custom_domain_name AS custom_domain_name_14, t0.id_user AS id_user_15 FROM user_company t0 WHERE t0.id_user = '3';
|
| 6 |
0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.intro AS intro_3, t0.description AS description_4, t0.image AS image_5, t0.delivery_methods_info AS delivery_methods_info_6, t0.returns_info AS returns_info_7, t0.payment_methods_info AS payment_methods_info_8, t0.is_active AS is_active_9, t0.id_company AS id_company_10 FROM company_store t0 WHERE t0.id_company = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.intro AS intro_3, t0.description AS description_4, t0.image AS image_5, t0.delivery_methods_info AS delivery_methods_info_6, t0.returns_info AS returns_info_7, t0.payment_methods_info AS payment_methods_info_8, t0.is_active AS is_active_9, t0.id_company AS id_company_10 FROM company_store t0 WHERE t0.id_company = '1' LIMIT 1;
|
| 7 |
0.14 ms |
SELECT t0.id AS id_1, t0.image AS image_2, t0.id_product AS id_product_3 FROM product_image t0 WHERE t0.id_product = ? ORDER BY t0.id ASC
SELECT t0.id AS id_1, t0.image AS image_2, t0.id_product AS id_product_3 FROM product_image t0 WHERE t0.id_product = 2 ORDER BY t0.id ASC;
|
| 8 |
0.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.intro AS intro_3, t0.description AS description_4, t0.image AS image_5, t0.delivery_methods_info AS delivery_methods_info_6, t0.returns_info AS returns_info_7, t0.payment_methods_info AS payment_methods_info_8, t0.is_active AS is_active_9, t0.id_company AS id_company_10 FROM company_store t0 WHERE t0.id_company = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.intro AS intro_3, t0.description AS description_4, t0.image AS image_5, t0.delivery_methods_info AS delivery_methods_info_6, t0.returns_info AS returns_info_7, t0.payment_methods_info AS payment_methods_info_8, t0.is_active AS is_active_9, t0.id_company AS id_company_10 FROM company_store t0 WHERE t0.id_company = '1' LIMIT 1;
|
| 9 |
0.36 ms |
SELECT p0_.id AS id_0, p0_.template_type AS template_type_1, p0_.date_from AS date_from_2, p0_.date_to AS date_to_3, p0_.url_alias AS url_alias_4, p0_.type AS type_5, p0_.view_count AS view_count_6, p0_.completed_steps AS completed_steps_7, p0_.is_draft AS is_draft_8, p0_.payment_method AS payment_method_9, p0_.payment_id AS payment_id_10, p0_.paid_at AS paid_at_11, p0_.added_at AS added_at_12, p0_.id_presentation AS id_presentation_13, p0_.id_added_by_user AS id_added_by_user_14 FROM promotion p0_ INNER JOIN user u1_ ON p0_.id_added_by_user = u1_.id WHERE p0_.is_draft = 0 AND u1_.is_active = 1 AND p0_.type IN (?, ?) AND p0_.date_from <= ? AND p0_.date_to >= ? ORDER BY p0_.date_to ASC LIMIT 4
Parameters: [
1
2
"2026-10-25 00:00:00"
"2026-10-25 00:00:00"
]
SELECT p0_.id AS id_0, p0_.template_type AS template_type_1, p0_.date_from AS date_from_2, p0_.date_to AS date_to_3, p0_.url_alias AS url_alias_4, p0_.type AS type_5, p0_.view_count AS view_count_6, p0_.completed_steps AS completed_steps_7, p0_.is_draft AS is_draft_8, p0_.payment_method AS payment_method_9, p0_.payment_id AS payment_id_10, p0_.paid_at AS paid_at_11, p0_.added_at AS added_at_12, p0_.id_presentation AS id_presentation_13, p0_.id_added_by_user AS id_added_by_user_14 FROM promotion p0_ INNER JOIN user u1_ ON p0_.id_added_by_user = u1_.id WHERE p0_.is_draft = 0 AND u1_.is_active = 1 AND p0_.type IN (1, 2) AND p0_.date_from <= '2026-10-25 00:00:00' AND p0_.date_to >= '2026-10-25 00:00:00' ORDER BY p0_.date_to ASC LIMIT 4;
|
| 10 |
0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.logo AS logo_4, t0.primary_button_background_color AS primary_button_background_color_5, t0.primary_button_text_color AS primary_button_text_color_6, t0.default_button_background_color AS default_button_background_color_7, t0.default_button_text_color AS default_button_text_color_8, t0.completed_steps AS completed_steps_9, t0.is_published AS is_published_10, t0.added_at AS added_at_11, t0.id_added_by_user AS id_added_by_user_12 FROM presentation t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.logo AS logo_4, t0.primary_button_background_color AS primary_button_background_color_5, t0.primary_button_text_color AS primary_button_text_color_6, t0.default_button_background_color AS default_button_background_color_7, t0.default_button_text_color AS default_button_text_color_8, t0.completed_steps AS completed_steps_9, t0.is_published AS is_published_10, t0.added_at AS added_at_11, t0.id_added_by_user AS id_added_by_user_12 FROM presentation t0 WHERE t0.id = '1';
|
| 11 |
0.13 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.type AS type_5, t0.is_active AS is_active_6 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.type AS type_5, t0.is_active AS is_active_6 FROM user t0 WHERE t0.id = '1';
|
| 12 |
0.16 ms |
SELECT t0.id AS id_1, t0.gross_price AS gross_price_2, t0.quantity AS quantity_3, t0.id_promotion AS id_promotion_4, t0.id_presentation_product AS id_presentation_product_5 FROM promotion_product t0 WHERE t0.id_promotion = ? ORDER BY t0.id ASC
SELECT t0.id AS id_1, t0.gross_price AS gross_price_2, t0.quantity AS quantity_3, t0.id_promotion AS id_promotion_4, t0.id_presentation_product AS id_presentation_product_5 FROM promotion_product t0 WHERE t0.id_promotion = '3' ORDER BY t0.id ASC;
|
| 13 |
0.14 ms |
SELECT t0.id AS id_1, t0.id_presentation AS id_presentation_2, t0.id_product AS id_product_3 FROM presentation_product t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.id_presentation AS id_presentation_2, t0.id_product AS id_product_3 FROM presentation_product t0 WHERE t0.id = '1';
|
| 14 |
0.13 ms |
SELECT t0.id AS id_1, t0.gross_price AS gross_price_2, t0.quantity AS quantity_3, t0.id_promotion AS id_promotion_4, t0.id_presentation_product AS id_presentation_product_5 FROM promotion_product t0 WHERE t0.id_promotion = ? ORDER BY t0.id ASC
SELECT t0.id AS id_1, t0.gross_price AS gross_price_2, t0.quantity AS quantity_3, t0.id_promotion AS id_promotion_4, t0.id_presentation_product AS id_presentation_product_5 FROM promotion_product t0 WHERE t0.id_promotion = '2' ORDER BY t0.id ASC;
|