3.68 ms (48.83%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.type AS type_4, t0.is_active AS is_active_5, t0.is_public AS is_public_6, t0.description AS description_7, t0.sort_order AS sort_order_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM subscriptions t0 INNER JOIN photo_subscriptions ON t0.id = photo_subscriptions.subscription_id WHERE photo_subscriptions.photo_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.type AS type_4, t0.is_active AS is_active_5, t0.is_public AS is_public_6, t0.description AS description_7, t0.sort_order AS sort_order_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM subscriptions t0 INNER JOIN photo_subscriptions ON t0.id = photo_subscriptions.subscription_id WHERE photo_subscriptions.photo_id = 3;
|
1.32 ms (17.51%)
|
1 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.subscription_id AS subscription_id_5 FROM subscription_translations t0 WHERE t0.subscription_id = ?
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.subscription_id AS subscription_id_5 FROM subscription_translations t0 WHERE t0.subscription_id = 1;
|
0.53 ms (7.03%)
|
1 |
SELECT COUNT(c0_.id) AS sclr_0 FROM comments c0_ WHERE c0_.created_at >= ?
Parameters: [
"2026-01-22 00:00:00"
]
SELECT COUNT(c0_.id) AS sclr_0 FROM comments c0_ WHERE c0_.created_at >= '2026-01-22 00:00:00';
|
0.52 ms (6.92%)
|
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.main_image AS main_image_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.price AS price_6, t0.pricing_type AS pricing_type_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.sort_order AS sort_order_10, t0.views_count AS views_count_11, t0.likes_count AS likes_count_12, t0.purchases_count AS purchases_count_13, t0.comments_count AS comments_count_14 FROM photo t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.main_image AS main_image_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.price AS price_6, t0.pricing_type AS pricing_type_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.sort_order AS sort_order_10, t0.views_count AS views_count_11, t0.likes_count AS likes_count_12, t0.purchases_count AS purchases_count_13, t0.comments_count AS comments_count_14 FROM photo t0 WHERE t0.id = '3';
|
0.42 ms (5.57%)
|
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.is_active AS is_active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.sort_order AS sort_order_7 FROM category t0 INNER JOIN photo_categories ON t0.id = photo_categories.category_id WHERE photo_categories.photo_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.is_active AS is_active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.sort_order AS sort_order_7 FROM category t0 INNER JOIN photo_categories ON t0.id = photo_categories.category_id WHERE photo_categories.photo_id = 3;
|
0.38 ms (5.07%)
|
1 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.photo_id AS photo_id_7 FROM photo_translation t0 WHERE t0.photo_id = ?
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.photo_id AS photo_id_7 FROM photo_translation t0 WHERE t0.photo_id = 3;
|
0.35 ms (4.62%)
|
1 |
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.alt AS alt_3, t0.sort_order AS sort_order_4, t0.created_at AS created_at_5, t0.photo_id AS photo_id_6 FROM photo_gallery t0 WHERE t0.photo_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.alt AS alt_3, t0.sort_order AS sort_order_4, t0.created_at AS created_at_5, t0.photo_id AS photo_id_6 FROM photo_gallery t0 WHERE t0.photo_id = 3 ORDER BY t0.sort_order ASC;
|
0.34 ms (4.45%)
|
1 |
SELECT COUNT(c0_.id) AS sclr_0 FROM contact_message c0_ WHERE c0_.is_read = ?
SELECT COUNT(c0_.id) AS sclr_0 FROM contact_message c0_ WHERE c0_.is_read = 0;
|