| 1 |
0.59 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.type AS type_4, t0.guid AS guid_5, t0.slug AS slug_6, t0.elastic_updated AS elastic_updated_7, t0.keywords AS keywords_8, t0.meta_keywords AS meta_keywords_9, t0.meta_description AS meta_description_10, t0.business_id AS business_id_11, t0.user_id AS user_id_12, t0.category_id AS category_id_13 FROM product t0 WHERE t0.guid = ? LIMIT 1
Parameters: [
"01KQ9MQ0A2N1PZKZE7DH1NS1Q2"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.type AS type_4, t0.guid AS guid_5, t0.slug AS slug_6, t0.elastic_updated AS elastic_updated_7, t0.keywords AS keywords_8, t0.meta_keywords AS meta_keywords_9, t0.meta_description AS meta_description_10, t0.business_id AS business_id_11, t0.user_id AS user_id_12, t0.category_id AS category_id_13 FROM product t0 WHERE t0.guid = '01KQ9MQ0A2N1PZKZE7DH1NS1Q2' LIMIT 1;
|
| 2 |
0.50 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.type AS type_3, p0_.guid AS guid_4, p0_.slug AS slug_5, p0_.elastic_updated AS elastic_updated_6, p0_.keywords AS keywords_7, p0_.meta_keywords AS meta_keywords_8, p0_.meta_description AS meta_description_9, p0_.business_id AS business_id_10, p0_.user_id AS user_id_11, p0_.category_id AS category_id_12 FROM product p0_ WHERE p0_.business_id = ? AND p0_.id <> ?
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.type AS type_3, p0_.guid AS guid_4, p0_.slug AS slug_5, p0_.elastic_updated AS elastic_updated_6, p0_.keywords AS keywords_7, p0_.meta_keywords AS meta_keywords_8, p0_.meta_description AS meta_description_9, p0_.business_id AS business_id_10, p0_.user_id AS user_id_11, p0_.category_id AS category_id_12 FROM product p0_ WHERE p0_.business_id = 24 AND p0_.id <> 27;
|
| 3 |
0.45 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.registration_type AS registration_type_3, t0.number_of_employee AS number_of_employee_4, t0.establishment_date AS establishment_date_5, t0.annual_turnover AS annual_turnover_6, t0.working_days AS working_days_7, t0.about AS about_8, t0.email AS email_9, t0.mobile AS mobile_10, t0.address2 AS address2_11, t0.city AS city_12, t0.state AS state_13, t0.pincode AS pincode_14, t0.website AS website_15, t0.guid AS guid_16, t0.is_website_verified AS is_website_verified_17, t0.is_email_verified AS is_email_verified_18, t0.address1 AS address1_19, t0.txt_record AS txt_record_20, t0.created_on AS created_on_21, t0.slug AS slug_22, t0.views AS views_23, t0.user_id AS user_id_24, t0.country_id AS country_id_25 FROM business t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.registration_type AS registration_type_3, t0.number_of_employee AS number_of_employee_4, t0.establishment_date AS establishment_date_5, t0.annual_turnover AS annual_turnover_6, t0.working_days AS working_days_7, t0.about AS about_8, t0.email AS email_9, t0.mobile AS mobile_10, t0.address2 AS address2_11, t0.city AS city_12, t0.state AS state_13, t0.pincode AS pincode_14, t0.website AS website_15, t0.guid AS guid_16, t0.is_website_verified AS is_website_verified_17, t0.is_email_verified AS is_email_verified_18, t0.address1 AS address1_19, t0.txt_record AS txt_record_20, t0.created_on AS created_on_21, t0.slug AS slug_22, t0.views AS views_23, t0.user_id AS user_id_24, t0.country_id AS country_id_25 FROM business t0 WHERE t0.id = 24;
|
| 4 |
0.44 ms |
SELECT t0.id AS id_1, t0.guid AS guid_2, t0.image_data AS image_data_3, t0.mime_type AS mime_type_4, t0.file_size AS file_size_5, t0.position AS position_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.product_id AS product_id_9 FROM product_photo t0 WHERE t0.product_id = ? ORDER BY t0.position ASC, t0.id ASC
SELECT t0.id AS id_1, t0.guid AS guid_2, t0.image_data AS image_data_3, t0.mime_type AS mime_type_4, t0.file_size AS file_size_5, t0.position AS position_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.product_id AS product_id_9 FROM product_photo t0 WHERE t0.product_id = 27 ORDER BY t0.position ASC, t0.id ASC;
|
| 5 |
0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.keywords AS keywords_4, t0.is_default AS is_default_5, t0.homepage AS homepage_6, t0.slug AS slug_7, t0.faicon AS faicon_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.keywords AS keywords_4, t0.is_default AS is_default_5, t0.homepage AS homepage_6, t0.slug AS slug_7, t0.faicon AS faicon_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.id = 1246;
|