| 1 |
0.27 ms |
SELECT i0_.id AS id_0, i0_.ip_address AS ip_address_1, i0_.reason AS reason_2, i0_.created_at AS created_at_3, i0_.expires_at AS expires_at_4, i0_.is_active AS is_active_5, i0_.created_by_id AS created_by_id_6 FROM `ip_blacklist` i0_ WHERE i0_.ip_address = ? AND i0_.is_active = 1 AND ((i0_.expires_at IS NULL OR i0_.expires_at > ?))
Parameters: [
"40.77.167.14"
"2026-06-05 16:11:43"
]
SELECT i0_.id AS id_0, i0_.ip_address AS ip_address_1, i0_.reason AS reason_2, i0_.created_at AS created_at_3, i0_.expires_at AS expires_at_4, i0_.is_active AS is_active_5, i0_.created_by_id AS created_by_id_6 FROM `ip_blacklist` i0_ WHERE i0_.ip_address = '40.77.167.14' AND i0_.is_active = 1 AND ((i0_.expires_at IS NULL OR i0_.expires_at > '2026-06-05 16:11:43'));
|
| 2 |
0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"buy-sell-jewelry"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.slug = 'buy-sell-jewelry' LIMIT 1;
|
| 3 |
1.35 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.parent_id AS sclr_3 FROM category c0_ ORDER BY c0_.name ASC
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.parent_id AS sclr_3 FROM category c0_ ORDER BY c0_.name ASC;
|
| 4 |
8.43 ms |
SELECT c.id as category_id,
COUNT(DISTINCT CASE WHEN l.id IS NOT NULL AND u.id IS NOT NULL THEN l.id ELSE NULL END) as count FROM category c LEFT JOIN listing l ON l.category_id = c.id AND l.is_active = 1 LEFT JOIN user u ON l.owner_id = u.id AND u.is_active = 1 LEFT JOIN price_type pt ON l.price_type_id = pt.id LEFT JOIN listing_type lt ON l.listing_type_id = lt.id GROUP BY c.id
SELECT c.id as category_id,
COUNT(DISTINCT CASE WHEN l.id IS NOT NULL AND u.id IS NOT NULL THEN l.id ELSE NULL END) as count FROM category c LEFT JOIN listing l ON l.category_id = c.id AND l.is_active = 1 LEFT JOIN user u ON l.owner_id = u.id AND u.is_active = 1 LEFT JOIN price_type pt ON l.price_type_id = pt.id LEFT JOIN listing_type lt ON l.listing_type_id = lt.id GROUP BY c.id;
|
| 5 |
0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = 78;
|
| 6 |
0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = 79;
|
| 7 |
0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = 80;
|
| 8 |
0.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = 81;
|
| 9 |
0.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = 82;
|
| 10 |
0.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = 83;
|
| 11 |
0.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = 84;
|
| 12 |
0.05 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = 85;
|
| 13 |
0.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = 86;
|
| 14 |
0.05 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = 87;
|
| 15 |
0.05 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = 88;
|
| 16 |
0.05 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = 89;
|
| 17 |
0.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = 90;
|
| 18 |
0.05 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = 91;
|
| 19 |
0.05 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = 92;
|
| 20 |
0.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = 93;
|
| 21 |
0.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = 413;
|
| 22 |
0.34 ms |
SELECT COUNT(l0_.id) AS sclr_0 FROM listing l0_ LEFT JOIN `user` u1_ ON l0_.owner_id = u1_.id LEFT JOIN category c2_ ON l0_.category_id = c2_.id LEFT JOIN listing_type l3_ ON l0_.listing_type_id = l3_.id WHERE l0_.is_active = 1 AND u1_.is_active = 1 AND l0_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY l0_.updated_at DESC
Parameters: [
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
413
]
SELECT COUNT(l0_.id) AS sclr_0 FROM listing l0_ LEFT JOIN `user` u1_ ON l0_.owner_id = u1_.id LEFT JOIN category c2_ ON l0_.category_id = c2_.id LEFT JOIN listing_type l3_ ON l0_.listing_type_id = l3_.id WHERE l0_.is_active = 1 AND u1_.is_active = 1 AND l0_.category_id IN (78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 413) ORDER BY l0_.updated_at DESC;
|
| 23 |
0.85 ms |
SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.slug AS slug_2, l0_.description AS description_3, l0_.price AS price_4, l0_.is_active AS is_active_5, l0_.fields AS fields_6, l0_.latitude AS latitude_7, l0_.longitude AS longitude_8, l0_.lookup AS lookup_9, l0_.is_business AS is_business_10, l0_.url AS url_11, l0_.phone_number AS phone_number_12, l0_.condition_rating AS condition_rating_13, l0_.media_url AS media_url_14, l0_.created_at AS created_at_15, l0_.updated_at AS updated_at_16, u1_.id AS id_17, u1_.email AS email_18, u1_.slug AS slug_19, u1_.roles AS roles_20, u1_.password AS password_21, u1_.forsalebyowner_user_id AS forsalebyowner_user_id_22, u1_.first_name AS first_name_23, u1_.last_name AS last_name_24, u1_.user_name AS user_name_25, u1_.phone AS phone_26, u1_.created_at AS created_at_27, u1_.google_id AS google_id_28, u1_.avatar AS avatar_29, u1_.tagline AS tagline_30, u1_.is_active AS is_active_31, u1_.confirmation_token AS confirmation_token_32, u1_.confirmation_token_expires_at AS confirmation_token_expires_at_33, u1_.promo_code AS promo_code_34, u1_.show_phone_in_brochure AS show_phone_in_brochure_35, u1_.default_search_view AS default_search_view_36, u1_.description AS description_37, u1_.website_address AS website_address_38, u1_.allow_non_verified AS allow_non_verified_39, u1_.latitude AS latitude_40, u1_.longitude AS longitude_41, u1_.address AS address_42, u1_.show_address_in_brochure AS show_address_in_brochure_43, c2_.id AS id_44, c2_.name AS name_45, c2_.slug AS slug_46, c2_.is_active AS is_active_47, c2_.label AS label_48, c2_.sort_order AS sort_order_49, l0_.owner_id AS owner_id_50, l0_.category_id AS category_id_51, l0_.location_id AS location_id_52, l0_.listing_type_id AS listing_type_id_53, l0_.offer_type_id AS offer_type_id_54, l0_.price_type_id AS price_type_id_55, l0_.state_id AS state_id_56, l0_.status_id AS status_id_57, c2_.parent_id AS parent_id_58, c2_.form_id AS form_id_59 FROM listing l0_ LEFT JOIN `user` u1_ ON l0_.owner_id = u1_.id LEFT JOIN category c2_ ON l0_.category_id = c2_.id LEFT JOIN listing_type l3_ ON l0_.listing_type_id = l3_.id WHERE l0_.is_active = 1 AND u1_.is_active = 1 AND l0_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY l0_.updated_at DESC
Parameters: [
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
413
]
SELECT
l0_.id AS id_0,
l0_.title AS title_1,
l0_.slug AS slug_2,
l0_.description AS description_3,
l0_.price AS price_4,
l0_.is_active AS is_active_5,
l0_.fields AS fields_6,
l0_.latitude AS latitude_7,
l0_.longitude AS longitude_8,
l0_.lookup AS lookup_9,
l0_.is_business AS is_business_10,
l0_.url AS url_11,
l0_.phone_number AS phone_number_12,
l0_.condition_rating AS condition_rating_13,
l0_.media_url AS media_url_14,
l0_.created_at AS created_at_15,
l0_.updated_at AS updated_at_16,
u1_.id AS id_17,
u1_.email AS email_18,
u1_.slug AS slug_19,
u1_.roles AS roles_20,
u1_.password AS password_21,
u1_.forsalebyowner_user_id AS forsalebyowner_user_id_22,
u1_.first_name AS first_name_23,
u1_.last_name AS last_name_24,
u1_.user_name AS user_name_25,
u1_.phone AS phone_26,
u1_.created_at AS created_at_27,
u1_.google_id AS google_id_28,
u1_.avatar AS avatar_29,
u1_.tagline AS tagline_30,
u1_.is_active AS is_active_31,
u1_.confirmation_token AS confirmation_token_32,
u1_.confirmation_token_expires_at AS confirmation_token_expires_at_33,
u1_.promo_code AS promo_code_34,
u1_.show_phone_in_brochure AS show_phone_in_brochure_35,
u1_.default_search_view AS default_search_view_36,
u1_.description AS description_37,
u1_.website_address AS website_address_38,
u1_.allow_non_verified AS allow_non_verified_39,
u1_.latitude AS latitude_40,
u1_.longitude AS longitude_41,
u1_.address AS address_42,
u1_.show_address_in_brochure AS show_address_in_brochure_43,
c2_.id AS id_44,
c2_.name AS name_45,
c2_.slug AS slug_46,
c2_.is_active AS is_active_47,
c2_.label AS label_48,
c2_.sort_order AS sort_order_49,
l0_.owner_id AS owner_id_50,
l0_.category_id AS category_id_51,
l0_.location_id AS location_id_52,
l0_.listing_type_id AS listing_type_id_53,
l0_.offer_type_id AS offer_type_id_54,
l0_.price_type_id AS price_type_id_55,
l0_.state_id AS state_id_56,
l0_.status_id AS status_id_57,
c2_.parent_id AS parent_id_58,
c2_.form_id AS form_id_59
FROM
listing l0_
LEFT JOIN `user` u1_ ON l0_.owner_id = u1_.id
LEFT JOIN category c2_ ON l0_.category_id = c2_.id
LEFT JOIN listing_type l3_ ON l0_.listing_type_id = l3_.id
WHERE
l0_.is_active = 1
AND u1_.is_active = 1
AND l0_.category_id IN (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?
)
ORDER BY
l0_.updated_at DESC
SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.slug AS slug_2, l0_.description AS description_3, l0_.price AS price_4, l0_.is_active AS is_active_5, l0_.fields AS fields_6, l0_.latitude AS latitude_7, l0_.longitude AS longitude_8, l0_.lookup AS lookup_9, l0_.is_business AS is_business_10, l0_.url AS url_11, l0_.phone_number AS phone_number_12, l0_.condition_rating AS condition_rating_13, l0_.media_url AS media_url_14, l0_.created_at AS created_at_15, l0_.updated_at AS updated_at_16, u1_.id AS id_17, u1_.email AS email_18, u1_.slug AS slug_19, u1_.roles AS roles_20, u1_.password AS password_21, u1_.forsalebyowner_user_id AS forsalebyowner_user_id_22, u1_.first_name AS first_name_23, u1_.last_name AS last_name_24, u1_.user_name AS user_name_25, u1_.phone AS phone_26, u1_.created_at AS created_at_27, u1_.google_id AS google_id_28, u1_.avatar AS avatar_29, u1_.tagline AS tagline_30, u1_.is_active AS is_active_31, u1_.confirmation_token AS confirmation_token_32, u1_.confirmation_token_expires_at AS confirmation_token_expires_at_33, u1_.promo_code AS promo_code_34, u1_.show_phone_in_brochure AS show_phone_in_brochure_35, u1_.default_search_view AS default_search_view_36, u1_.description AS description_37, u1_.website_address AS website_address_38, u1_.allow_non_verified AS allow_non_verified_39, u1_.latitude AS latitude_40, u1_.longitude AS longitude_41, u1_.address AS address_42, u1_.show_address_in_brochure AS show_address_in_brochure_43, c2_.id AS id_44, c2_.name AS name_45, c2_.slug AS slug_46, c2_.is_active AS is_active_47, c2_.label AS label_48, c2_.sort_order AS sort_order_49, l0_.owner_id AS owner_id_50, l0_.category_id AS category_id_51, l0_.location_id AS location_id_52, l0_.listing_type_id AS listing_type_id_53, l0_.offer_type_id AS offer_type_id_54, l0_.price_type_id AS price_type_id_55, l0_.state_id AS state_id_56, l0_.status_id AS status_id_57, c2_.parent_id AS parent_id_58, c2_.form_id AS form_id_59 FROM listing l0_ LEFT JOIN `user` u1_ ON l0_.owner_id = u1_.id LEFT JOIN category c2_ ON l0_.category_id = c2_.id LEFT JOIN listing_type l3_ ON l0_.listing_type_id = l3_.id WHERE l0_.is_active = 1 AND u1_.is_active = 1 AND l0_.category_id IN (78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 413) ORDER BY l0_.updated_at DESC;
|
| 24 |
2.92 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.is_value AS is_value_2, COUNT(l1_.id) AS sclr_3 FROM price_type p0_ INNER JOIN listing l1_ ON p0_.id = l1_.price_type_id GROUP BY p0_.id
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.is_value AS is_value_2, COUNT(l1_.id) AS sclr_3 FROM price_type p0_ INNER JOIN listing l1_ ON p0_.id = l1_.price_type_id GROUP BY p0_.id;
|
| 25 |
0.10 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.id = 1;
|
| 26 |
0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM category_form t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM category_form t0 WHERE t0.id = 1;
|
| 27 |
0.11 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = 3256636 ORDER BY t0.sort_order ASC;
|
| 28 |
0.11 ms |
SELECT t0.id AS id_1, t0.additional_stores AS additional_stores_2, t0.override_listing_limit AS override_listing_limit_3, t0.override_store_limit AS override_store_limit_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.token AS token_7, t0.is_recurring AS is_recurring_8, t0.user_id AS user_id_9, t0.pricing_option_id AS pricing_option_id_10 FROM subscription t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.additional_stores AS additional_stores_2, t0.override_listing_limit AS override_listing_limit_3, t0.override_store_limit AS override_store_limit_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.token AS token_7, t0.is_recurring AS is_recurring_8, t0.user_id AS user_id_9, t0.pricing_option_id AS pricing_option_id_10 FROM subscription t0 WHERE t0.user_id = 295;
|
| 29 |
0.09 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.is_active AS is_active_3, t0.billing_cycle AS billing_cycle_4, t0.plan_id AS plan_id_5 FROM plan_pricing_option t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.price AS price_2, t0.is_active AS is_active_3, t0.billing_cycle AS billing_cycle_4, t0.plan_id AS plan_id_5 FROM plan_pricing_option t0 WHERE t0.id = 15;
|
| 30 |
0.10 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.word_limit AS word_limit_3, t0.photo_limit AS photo_limit_4, t0.conversation_limit AS conversation_limit_5, t0.allowed_media_link AS allowed_media_link_6, t0.slug AS slug_7, t0.base_listing_limit AS base_listing_limit_8, t0.base_store_limit AS base_store_limit_9, t0.listings_per_addon_store AS listings_per_addon_store_10, t0.is_active AS is_active_11, t0.is_custom AS is_custom_12, t0.addon_store_price AS addon_store_price_13, t0.description AS description_14, t0.allowed_website AS allowed_website_15 FROM plan t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.word_limit AS word_limit_3, t0.photo_limit AS photo_limit_4, t0.conversation_limit AS conversation_limit_5, t0.allowed_media_link AS allowed_media_link_6, t0.slug AS slug_7, t0.base_listing_limit AS base_listing_limit_8, t0.base_store_limit AS base_store_limit_9, t0.listings_per_addon_store AS listings_per_addon_store_10, t0.is_active AS is_active_11, t0.is_custom AS is_custom_12, t0.addon_store_price AS addon_store_price_13, t0.description AS description_14, t0.allowed_website AS allowed_website_15 FROM plan t0 WHERE t0.id = 3;
|
| 31 |
0.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.geometry AS geometry_3, t0.coordinates AS coordinates_4, t0.code AS code_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.province_id AS province_id_8 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.geometry AS geometry_3, t0.coordinates AS coordinates_4, t0.code AS code_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.province_id AS province_id_8 FROM city t0 WHERE t0.id = 971;
|
| 32 |
0.10 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.coordinates AS coordinates_4, t0.geometry AS geometry_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.country_id AS country_id_8 FROM province t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.coordinates AS coordinates_4, t0.geometry AS geometry_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.country_id AS country_id_8 FROM province t0 WHERE t0.id = 7;
|
| 33 |
0.10 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = 3256635 ORDER BY t0.sort_order ASC;
|
| 34 |
0.09 ms |
SELECT t0.id AS id_1, t0.additional_stores AS additional_stores_2, t0.override_listing_limit AS override_listing_limit_3, t0.override_store_limit AS override_store_limit_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.token AS token_7, t0.is_recurring AS is_recurring_8, t0.user_id AS user_id_9, t0.pricing_option_id AS pricing_option_id_10 FROM subscription t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.additional_stores AS additional_stores_2, t0.override_listing_limit AS override_listing_limit_3, t0.override_store_limit AS override_store_limit_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.token AS token_7, t0.is_recurring AS is_recurring_8, t0.user_id AS user_id_9, t0.pricing_option_id AS pricing_option_id_10 FROM subscription t0 WHERE t0.user_id = 306;
|
| 35 |
0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.geometry AS geometry_3, t0.coordinates AS coordinates_4, t0.code AS code_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.province_id AS province_id_8 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.geometry AS geometry_3, t0.coordinates AS coordinates_4, t0.code AS code_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.province_id AS province_id_8 FROM city t0 WHERE t0.id = 1014;
|
| 36 |
0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.coordinates AS coordinates_4, t0.geometry AS geometry_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.country_id AS country_id_8 FROM province t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.coordinates AS coordinates_4, t0.geometry AS geometry_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.country_id AS country_id_8 FROM province t0 WHERE t0.id = 2;
|
| 37 |
0.10 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = 3256634 ORDER BY t0.sort_order ASC;
|
| 38 |
0.10 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = 3246648 ORDER BY t0.sort_order ASC;
|
| 39 |
0.08 ms |
SELECT t0.id AS id_1, t0.additional_stores AS additional_stores_2, t0.override_listing_limit AS override_listing_limit_3, t0.override_store_limit AS override_store_limit_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.token AS token_7, t0.is_recurring AS is_recurring_8, t0.user_id AS user_id_9, t0.pricing_option_id AS pricing_option_id_10 FROM subscription t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.additional_stores AS additional_stores_2, t0.override_listing_limit AS override_listing_limit_3, t0.override_store_limit AS override_store_limit_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.token AS token_7, t0.is_recurring AS is_recurring_8, t0.user_id AS user_id_9, t0.pricing_option_id AS pricing_option_id_10 FROM subscription t0 WHERE t0.user_id = 307;
|
| 40 |
0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.geometry AS geometry_3, t0.coordinates AS coordinates_4, t0.code AS code_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.province_id AS province_id_8 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.geometry AS geometry_3, t0.coordinates AS coordinates_4, t0.code AS code_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.province_id AS province_id_8 FROM city t0 WHERE t0.id = 1042;
|
| 41 |
0.08 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = 3256633 ORDER BY t0.sort_order ASC;
|
| 42 |
0.08 ms |
SELECT t0.id AS id_1, t0.additional_stores AS additional_stores_2, t0.override_listing_limit AS override_listing_limit_3, t0.override_store_limit AS override_store_limit_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.token AS token_7, t0.is_recurring AS is_recurring_8, t0.user_id AS user_id_9, t0.pricing_option_id AS pricing_option_id_10 FROM subscription t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.additional_stores AS additional_stores_2, t0.override_listing_limit AS override_listing_limit_3, t0.override_store_limit AS override_store_limit_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.token AS token_7, t0.is_recurring AS is_recurring_8, t0.user_id AS user_id_9, t0.pricing_option_id AS pricing_option_id_10 FROM subscription t0 WHERE t0.user_id = 284;
|
| 43 |
0.06 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.is_active AS is_active_3, t0.billing_cycle AS billing_cycle_4, t0.plan_id AS plan_id_5 FROM plan_pricing_option t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.price AS price_2, t0.is_active AS is_active_3, t0.billing_cycle AS billing_cycle_4, t0.plan_id AS plan_id_5 FROM plan_pricing_option t0 WHERE t0.id = 9;
|
| 44 |
0.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.word_limit AS word_limit_3, t0.photo_limit AS photo_limit_4, t0.conversation_limit AS conversation_limit_5, t0.allowed_media_link AS allowed_media_link_6, t0.slug AS slug_7, t0.base_listing_limit AS base_listing_limit_8, t0.base_store_limit AS base_store_limit_9, t0.listings_per_addon_store AS listings_per_addon_store_10, t0.is_active AS is_active_11, t0.is_custom AS is_custom_12, t0.addon_store_price AS addon_store_price_13, t0.description AS description_14, t0.allowed_website AS allowed_website_15 FROM plan t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.word_limit AS word_limit_3, t0.photo_limit AS photo_limit_4, t0.conversation_limit AS conversation_limit_5, t0.allowed_media_link AS allowed_media_link_6, t0.slug AS slug_7, t0.base_listing_limit AS base_listing_limit_8, t0.base_store_limit AS base_store_limit_9, t0.listings_per_addon_store AS listings_per_addon_store_10, t0.is_active AS is_active_11, t0.is_custom AS is_custom_12, t0.addon_store_price AS addon_store_price_13, t0.description AS description_14, t0.allowed_website AS allowed_website_15 FROM plan t0 WHERE t0.id = 4;
|
| 45 |
0.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.geometry AS geometry_3, t0.coordinates AS coordinates_4, t0.code AS code_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.province_id AS province_id_8 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.geometry AS geometry_3, t0.coordinates AS coordinates_4, t0.code AS code_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.province_id AS province_id_8 FROM city t0 WHERE t0.id = 1083;
|
| 46 |
0.08 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = 3256631 ORDER BY t0.sort_order ASC;
|
| 47 |
0.08 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = 3256624 ORDER BY t0.sort_order ASC;
|
| 48 |
0.07 ms |
SELECT t0.id AS id_1, t0.additional_stores AS additional_stores_2, t0.override_listing_limit AS override_listing_limit_3, t0.override_store_limit AS override_store_limit_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.token AS token_7, t0.is_recurring AS is_recurring_8, t0.user_id AS user_id_9, t0.pricing_option_id AS pricing_option_id_10 FROM subscription t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.additional_stores AS additional_stores_2, t0.override_listing_limit AS override_listing_limit_3, t0.override_store_limit AS override_store_limit_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.token AS token_7, t0.is_recurring AS is_recurring_8, t0.user_id AS user_id_9, t0.pricing_option_id AS pricing_option_id_10 FROM subscription t0 WHERE t0.user_id = 290;
|
| 49 |
0.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.geometry AS geometry_3, t0.coordinates AS coordinates_4, t0.code AS code_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.province_id AS province_id_8 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.geometry AS geometry_3, t0.coordinates AS coordinates_4, t0.code AS code_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.province_id AS province_id_8 FROM city t0 WHERE t0.id = 1028;
|
| 50 |
0.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.coordinates AS coordinates_4, t0.geometry AS geometry_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.country_id AS country_id_8 FROM province t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.coordinates AS coordinates_4, t0.geometry AS geometry_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.country_id AS country_id_8 FROM province t0 WHERE t0.id = 1;
|
| 51 |
0.08 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = 3256622 ORDER BY t0.sort_order ASC;
|
| 52 |
0.08 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = 3256621 ORDER BY t0.sort_order ASC;
|
| 53 |
0.08 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = 3256620 ORDER BY t0.sort_order ASC;
|
| 54 |
0.08 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = 3255593 ORDER BY t0.sort_order ASC;
|
| 55 |
0.08 ms |
SELECT t0.id AS id_1, t0.additional_stores AS additional_stores_2, t0.override_listing_limit AS override_listing_limit_3, t0.override_store_limit AS override_store_limit_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.token AS token_7, t0.is_recurring AS is_recurring_8, t0.user_id AS user_id_9, t0.pricing_option_id AS pricing_option_id_10 FROM subscription t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.additional_stores AS additional_stores_2, t0.override_listing_limit AS override_listing_limit_3, t0.override_store_limit AS override_store_limit_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.token AS token_7, t0.is_recurring AS is_recurring_8, t0.user_id AS user_id_9, t0.pricing_option_id AS pricing_option_id_10 FROM subscription t0 WHERE t0.user_id = 323;
|
| 56 |
0.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.geometry AS geometry_3, t0.coordinates AS coordinates_4, t0.code AS code_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.province_id AS province_id_8 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.geometry AS geometry_3, t0.coordinates AS coordinates_4, t0.code AS code_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.province_id AS province_id_8 FROM city t0 WHERE t0.id = 1037;
|
| 57 |
0.12 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = 3255592 ORDER BY t0.sort_order ASC;
|
| 58 |
0.08 ms |
SELECT t0.id AS id_1, t0.additional_stores AS additional_stores_2, t0.override_listing_limit AS override_listing_limit_3, t0.override_store_limit AS override_store_limit_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.token AS token_7, t0.is_recurring AS is_recurring_8, t0.user_id AS user_id_9, t0.pricing_option_id AS pricing_option_id_10 FROM subscription t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.additional_stores AS additional_stores_2, t0.override_listing_limit AS override_listing_limit_3, t0.override_store_limit AS override_store_limit_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.token AS token_7, t0.is_recurring AS is_recurring_8, t0.user_id AS user_id_9, t0.pricing_option_id AS pricing_option_id_10 FROM subscription t0 WHERE t0.user_id = 386;
|
| 59 |
0.06 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.is_active AS is_active_3, t0.billing_cycle AS billing_cycle_4, t0.plan_id AS plan_id_5 FROM plan_pricing_option t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.price AS price_2, t0.is_active AS is_active_3, t0.billing_cycle AS billing_cycle_4, t0.plan_id AS plan_id_5 FROM plan_pricing_option t0 WHERE t0.id = 7;
|
| 60 |
0.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.geometry AS geometry_3, t0.coordinates AS coordinates_4, t0.code AS code_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.province_id AS province_id_8 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.geometry AS geometry_3, t0.coordinates AS coordinates_4, t0.code AS code_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.province_id AS province_id_8 FROM city t0 WHERE t0.id = 982;
|
| 61 |
0.08 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = 3255591 ORDER BY t0.sort_order ASC;
|
| 62 |
0.09 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = 3255588 ORDER BY t0.sort_order ASC;
|
| 63 |
0.08 ms |
SELECT t0.id AS id_1, t0.additional_stores AS additional_stores_2, t0.override_listing_limit AS override_listing_limit_3, t0.override_store_limit AS override_store_limit_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.token AS token_7, t0.is_recurring AS is_recurring_8, t0.user_id AS user_id_9, t0.pricing_option_id AS pricing_option_id_10 FROM subscription t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.additional_stores AS additional_stores_2, t0.override_listing_limit AS override_listing_limit_3, t0.override_store_limit AS override_store_limit_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.token AS token_7, t0.is_recurring AS is_recurring_8, t0.user_id AS user_id_9, t0.pricing_option_id AS pricing_option_id_10 FROM subscription t0 WHERE t0.user_id = 389;
|
| 64 |
0.08 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = 3255587 ORDER BY t0.sort_order ASC;
|
| 65 |
0.08 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = 3255585 ORDER BY t0.sort_order ASC;
|
| 66 |
0.08 ms |
SELECT t0.id AS id_1, t0.additional_stores AS additional_stores_2, t0.override_listing_limit AS override_listing_limit_3, t0.override_store_limit AS override_store_limit_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.token AS token_7, t0.is_recurring AS is_recurring_8, t0.user_id AS user_id_9, t0.pricing_option_id AS pricing_option_id_10 FROM subscription t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.additional_stores AS additional_stores_2, t0.override_listing_limit AS override_listing_limit_3, t0.override_store_limit AS override_store_limit_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.token AS token_7, t0.is_recurring AS is_recurring_8, t0.user_id AS user_id_9, t0.pricing_option_id AS pricing_option_id_10 FROM subscription t0 WHERE t0.user_id = 395;
|
| 67 |
0.08 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = 3255582 ORDER BY t0.sort_order ASC;
|
| 68 |
0.08 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = 3255579 ORDER BY t0.sort_order ASC;
|
| 69 |
0.07 ms |
SELECT t0.id AS id_1, t0.additional_stores AS additional_stores_2, t0.override_listing_limit AS override_listing_limit_3, t0.override_store_limit AS override_store_limit_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.token AS token_7, t0.is_recurring AS is_recurring_8, t0.user_id AS user_id_9, t0.pricing_option_id AS pricing_option_id_10 FROM subscription t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.additional_stores AS additional_stores_2, t0.override_listing_limit AS override_listing_limit_3, t0.override_store_limit AS override_store_limit_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.token AS token_7, t0.is_recurring AS is_recurring_8, t0.user_id AS user_id_9, t0.pricing_option_id AS pricing_option_id_10 FROM subscription t0 WHERE t0.user_id = 362;
|
| 70 |
0.06 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.is_active AS is_active_3, t0.billing_cycle AS billing_cycle_4, t0.plan_id AS plan_id_5 FROM plan_pricing_option t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.price AS price_2, t0.is_active AS is_active_3, t0.billing_cycle AS billing_cycle_4, t0.plan_id AS plan_id_5 FROM plan_pricing_option t0 WHERE t0.id = 8;
|
| 71 |
0.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.geometry AS geometry_3, t0.coordinates AS coordinates_4, t0.code AS code_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.province_id AS province_id_8 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.geometry AS geometry_3, t0.coordinates AS coordinates_4, t0.code AS code_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.province_id AS province_id_8 FROM city t0 WHERE t0.id = 1156;
|
| 72 |
0.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.coordinates AS coordinates_4, t0.geometry AS geometry_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.country_id AS country_id_8 FROM province t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.coordinates AS coordinates_4, t0.geometry AS geometry_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.country_id AS country_id_8 FROM province t0 WHERE t0.id = 9;
|
| 73 |
0.09 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = 3255576 ORDER BY t0.sort_order ASC;
|
| 74 |
0.08 ms |
SELECT t0.id AS id_1, t0.additional_stores AS additional_stores_2, t0.override_listing_limit AS override_listing_limit_3, t0.override_store_limit AS override_store_limit_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.token AS token_7, t0.is_recurring AS is_recurring_8, t0.user_id AS user_id_9, t0.pricing_option_id AS pricing_option_id_10 FROM subscription t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.additional_stores AS additional_stores_2, t0.override_listing_limit AS override_listing_limit_3, t0.override_store_limit AS override_store_limit_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.token AS token_7, t0.is_recurring AS is_recurring_8, t0.user_id AS user_id_9, t0.pricing_option_id AS pricing_option_id_10 FROM subscription t0 WHERE t0.user_id = 400;
|
| 75 |
0.08 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = 3255574 ORDER BY t0.sort_order ASC;
|