| 1 |
0.14 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 |
0.47 ms |
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.password AS password_2, u0_.email AS email_3, u0_.type AS type_4, u0_.is_active AS is_active_5, u1_.id AS id_6, u1_.name AS name_7, u1_.slug AS slug_8, u1_.description AS description_9, u1_.logo AS logo_10, u1_.image AS image_11, u1_.tin AS tin_12, u1_.street AS street_13, u1_.postal_code AS postal_code_14, u1_.city AS city_15, u1_.company_data_visible AS company_data_visible_16, u1_.bank_account_number AS bank_account_number_17, u1_.is_custom_subdomain AS is_custom_subdomain_18, u1_.custom_domain_name AS custom_domain_name_19, u1_.id_user AS id_user_20 FROM user u0_ INNER JOIN user_company u1_ ON u0_.id = u1_.id_user WHERE u0_.type = ? AND u0_.is_active = 1 AND u1_.slug = ?
Parameters: [
2
"firma-testowa-1"
]
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.password AS password_2, u0_.email AS email_3, u0_.type AS type_4, u0_.is_active AS is_active_5, u1_.id AS id_6, u1_.name AS name_7, u1_.slug AS slug_8, u1_.description AS description_9, u1_.logo AS logo_10, u1_.image AS image_11, u1_.tin AS tin_12, u1_.street AS street_13, u1_.postal_code AS postal_code_14, u1_.city AS city_15, u1_.company_data_visible AS company_data_visible_16, u1_.bank_account_number AS bank_account_number_17, u1_.is_custom_subdomain AS is_custom_subdomain_18, u1_.custom_domain_name AS custom_domain_name_19, u1_.id_user AS id_user_20 FROM user u0_ INNER JOIN user_company u1_ ON u0_.id = u1_.id_user WHERE u0_.type = 2 AND u0_.is_active = 1 AND u1_.slug = 'firma-testowa-1';
|
| 3 |
0.22 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;
|
| 4 |
0.92 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.description AS description_5, t0.ean AS ean_6, t0.sku AS sku_7, t0.price AS price_8, t0.vat AS vat_9, t0.gross_price AS gross_price_10, t0.stock_quantity AS stock_quantity_11, t0.gross_weight AS gross_weight_12, t0.package_width AS package_width_13, t0.package_height AS package_height_14, t0.package_length AS package_length_15, t0.shipping_type AS shipping_type_16, t0.is_active AS is_active_17, t0.added_at AS added_at_18, t0.id_product_category AS id_product_category_19, t0.id_added_by_user AS id_added_by_user_20 FROM product t0 INNER JOIN company_store_product ON t0.id = company_store_product.id_product WHERE company_store_product.id_company_store = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.description AS description_5, t0.ean AS ean_6, t0.sku AS sku_7, t0.price AS price_8, t0.vat AS vat_9, t0.gross_price AS gross_price_10, t0.stock_quantity AS stock_quantity_11, t0.gross_weight AS gross_weight_12, t0.package_width AS package_width_13, t0.package_height AS package_height_14, t0.package_length AS package_length_15, t0.shipping_type AS shipping_type_16, t0.is_active AS is_active_17, t0.added_at AS added_at_18, t0.id_product_category AS id_product_category_19, t0.id_added_by_user AS id_added_by_user_20 FROM product t0 INNER JOIN company_store_product ON t0.id = company_store_product.id_product WHERE company_store_product.id_company_store = '1';
|
| 5 |
0.13 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;
|
| 6 |
0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.lft AS lft_6, t0.rgt AS rgt_7, t0.depth AS depth_8 FROM product_category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.lft AS lft_6, t0.rgt AS rgt_7, t0.depth AS depth_8 FROM product_category t0 WHERE t0.id = 9;
|
| 7 |
0.12 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.icon AS icon_4, p0_.lft AS lft_5, p0_.rgt AS rgt_6, p0_.depth AS depth_7 FROM product_category p0_ WHERE p0_.lft < ? AND p0_.rgt > ? ORDER BY p0_.lft DESC
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.icon AS icon_4, p0_.lft AS lft_5, p0_.rgt AS rgt_6, p0_.depth AS depth_7 FROM product_category p0_ WHERE p0_.lft < 3 AND p0_.rgt > 4 ORDER BY p0_.lft DESC;
|
| 8 |
0.09 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;
|
| 9 |
0.10 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.icon AS icon_4, p0_.lft AS lft_5, p0_.rgt AS rgt_6, p0_.depth AS depth_7 FROM product_category p0_ WHERE p0_.lft < ? AND p0_.rgt > ? ORDER BY p0_.lft DESC
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.icon AS icon_4, p0_.lft AS lft_5, p0_.rgt AS rgt_6, p0_.depth AS depth_7 FROM product_category p0_ WHERE p0_.lft < 3 AND p0_.rgt > 4 ORDER BY p0_.lft DESC;
|
| 10 |
0.48 ms |
SELECT c0_.id AS id_0, c0_.question AS question_1, c0_.answer AS answer_2, c0_.position AS position_3, c0_.id_user_company AS id_user_company_4 FROM company_faq c0_ WHERE c0_.id_user_company = ? ORDER BY c0_.position ASC
SELECT c0_.id AS id_0, c0_.question AS question_1, c0_.answer AS answer_2, c0_.position AS position_3, c0_.id_user_company AS id_user_company_4 FROM company_faq c0_ WHERE c0_.id_user_company = '1' ORDER BY c0_.position ASC;
|