1
0.14 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_ . id_user AS id_user_18 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_ . id_user AS id_user_18 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' ;
Copy
2
0.11 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 ;
Copy
3
0.13 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' ;
Copy
4
0.11 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 ;
Copy
5
0.09 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 ;
Copy
6
0.09 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 ;
Copy
7
0.07 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 ;
Copy
8
0.07 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 ;
Copy
9
0.11 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 ;
Copy