| 1 |
1.73 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 ORDER BY t0.created_on DESC LIMIT 6
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 ORDER BY t0.created_on DESC LIMIT 6;
|
| 2 |
1.95 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_ INNER JOIN product_photo p1_ ON p0_.id = p1_.product_id GROUP BY p0_.id ORDER BY p0_.guid DESC LIMIT 8
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_ INNER JOIN product_photo p1_ ON p0_.id = p1_.product_id GROUP BY p0_.id ORDER BY p0_.guid DESC LIMIT 8;
|
| 3 |
0.95 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.keywords AS keywords_3, c0_.is_default AS is_default_4, c0_.homepage AS homepage_5, c0_.slug AS slug_6, c0_.faicon AS faicon_7, c0_.parent_id AS parent_id_8 FROM category c0_ WHERE c0_.parent_id IS NOT NULL AND c0_.homepage = 1 LIMIT 20
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.keywords AS keywords_3, c0_.is_default AS is_default_4, c0_.homepage AS homepage_5, c0_.slug AS slug_6, c0_.faicon AS faicon_7, c0_.parent_id AS parent_id_8 FROM category c0_ WHERE c0_.parent_id IS NOT NULL AND c0_.homepage = 1 LIMIT 20;
|
| 4 |
1.22 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 = 37 ORDER BY t0.position ASC, t0.id ASC;
|
| 5 |
0.26 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 = 4015;
|
| 6 |
0.25 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 = 2;
|
| 7 |
0.29 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 = 34 ORDER BY t0.position ASC, t0.id ASC;
|
| 8 |
0.32 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 = 5003;
|
| 9 |
0.28 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 = 33 ORDER BY t0.position ASC, t0.id ASC;
|
| 10 |
0.18 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 = 5070;
|
| 11 |
0.24 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 = 32 ORDER BY t0.position ASC, t0.id ASC;
|
| 12 |
0.15 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 = 5072;
|
| 13 |
0.20 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 = 30 ORDER BY t0.position ASC, t0.id ASC;
|
| 14 |
0.16 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 = 3188;
|
| 15 |
0.19 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 = 29 ORDER BY t0.position ASC, t0.id ASC;
|
| 16 |
0.15 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;
|
| 17 |
0.20 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;
|
| 18 |
0.21 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 = 28 ORDER BY t0.position ASC, t0.id ASC;
|
| 19 |
0.19 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;
|