GET https://7arfti.com/ar/listing?page=90

Query Metrics

36 Database Queries
9 Different statements
43.44 ms Query time
2 Invalid entities

Group similar statements

#â–² Time Info
1 18.56 ms
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.pricing_type AS pricing_type_2, a0_.price_type AS price_type_3, a0_.price AS price_4, a0_.max_price AS max_price_5, a0_.description AS description_6, a0_.business_hours AS business_hours_7, a0_.special_business_hours AS special_business_hours_8, a0_.images AS images_9, a0_.phone AS phone_10, a0_.whatsapp_number AS whatsapp_number_11, a0_.social_profiles AS social_profiles_12, a0_.created_at AS created_at_13, a0_.updated_at AS updated_at_14, a0_.expires_on AS expires_on_15, a0_.slug AS slug_16, a0_.views AS views_17, a0_.phone_click_count AS phone_click_count_18, a0_.phone_reveal_count AS phone_reveal_count_19, a0_.avg_rating AS avg_rating_20, a0_.deleted_at AS deleted_at_21, c1_.id AS id_22, c1_.name AS name_23, c1_.description AS description_24, c1_.menu_order AS menu_order_25, c1_.created_at AS created_at_26, c1_.updated_at AS updated_at_27, c1_.status AS status_28, c1_.icon AS icon_29, v2_.id AS id_30, v2_.name AS name_31, v2_.postal_code AS postal_code_32, a0_.category_id AS category_id_33, a0_.artisan_id AS artisan_id_34, a0_.ville_id AS ville_id_35, a0_.region_id AS region_id_36, a0_.status_id AS status_id_37, c1_.parent_category_id AS parent_category_id_38 FROM artisan_post a0_ LEFT JOIN category c1_ ON a0_.category_id = c1_.id LEFT JOIN ville v2_ ON a0_.ville_id = v2_.id LEFT JOIN review r3_ ON a0_.id = r3_.artisan_post_id WHERE a0_.deleted_at IS NULL ORDER BY a0_.created_at DESC
Parameters:
[]
2 0.84 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.menu_order AS menu_order_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.status AS status_7, t0.icon AS icon_8, t0.parent_category_id AS parent_category_id_9 FROM category t0 ORDER BY t0.menu_order ASC LIMIT 10
Parameters:
[]
3 0.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.postal_code AS postal_code_3 FROM ville t0 ORDER BY t0.id ASC LIMIT 10
Parameters:
[]
4 0.58 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.menu_order AS menu_order_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.status AS status_6, c0_.icon AS icon_7, c0_.parent_category_id AS parent_category_id_8 FROM category c0_
Parameters:
[]
5 0.49 ms
SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.postal_code AS postal_code_2 FROM ville v0_
Parameters:
[]
6 0.60 ms
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.status AS status_6, t0.user_id AS user_id_7, t0.artisan_post_id AS artisan_post_id_8 FROM review t0 WHERE t0.artisan_post_id = ?
Parameters:
0 of 0
[â–¼ 28 ]
7 2.12 ms
SELECT t0.id AS id_1, t0.speciality AS speciality_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5 FROM artisan t0 WHERE t0.id = ?
Parameters:
0 of 0
[â–¼ 29 ]
8 3.36 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.whatsapp_number AS whatsapp_number_7, t0.phone AS phone_8, t0.address AS address_9, t0.avatar AS avatar_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.username AS username_13, t14.id AS id_15, t14.speciality AS speciality_16, t14.created_at AS created_at_17, t14.updated_at AS updated_at_18, t14.user_id AS user_id_19, t0.ville_id AS ville_id_20, t0.region_id AS region_id_21, t22.id AS id_23, t22.created_at AS created_at_24, t22.updated_at AS updated_at_25, t22.user_id AS user_id_26 FROM user t0 LEFT JOIN artisan t14 ON t14.user_id = t0.id LEFT JOIN client t22 ON t22.user_id = t0.id WHERE t0.id = ?
Parameters:
0 of 0
[â–¼ 43 ]
9 0.61 ms
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.status AS status_6, t0.user_id AS user_id_7, t0.artisan_post_id AS artisan_post_id_8 FROM review t0 WHERE t0.artisan_post_id = ?
Parameters:
0 of 0
[â–¼ 27 ]
10 0.41 ms
SELECT t0.id AS id_1, t0.speciality AS speciality_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5 FROM artisan t0 WHERE t0.id = ?
Parameters:
0 of 0
[â–¼ 27 ]
11 0.60 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.whatsapp_number AS whatsapp_number_7, t0.phone AS phone_8, t0.address AS address_9, t0.avatar AS avatar_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.username AS username_13, t14.id AS id_15, t14.speciality AS speciality_16, t14.created_at AS created_at_17, t14.updated_at AS updated_at_18, t14.user_id AS user_id_19, t0.ville_id AS ville_id_20, t0.region_id AS region_id_21, t22.id AS id_23, t22.created_at AS created_at_24, t22.updated_at AS updated_at_25, t22.user_id AS user_id_26 FROM user t0 LEFT JOIN artisan t14 ON t14.user_id = t0.id LEFT JOIN client t22 ON t22.user_id = t0.id WHERE t0.id = ?
Parameters:
0 of 0
[â–¼ 41 ]
12 0.41 ms
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.status AS status_6, t0.user_id AS user_id_7, t0.artisan_post_id AS artisan_post_id_8 FROM review t0 WHERE t0.artisan_post_id = ?
Parameters:
0 of 0
[â–¼ 26 ]
13 0.42 ms
SELECT t0.id AS id_1, t0.speciality AS speciality_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5 FROM artisan t0 WHERE t0.id = ?
Parameters:
0 of 0
[â–¼ 26 ]
14 0.55 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.whatsapp_number AS whatsapp_number_7, t0.phone AS phone_8, t0.address AS address_9, t0.avatar AS avatar_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.username AS username_13, t14.id AS id_15, t14.speciality AS speciality_16, t14.created_at AS created_at_17, t14.updated_at AS updated_at_18, t14.user_id AS user_id_19, t0.ville_id AS ville_id_20, t0.region_id AS region_id_21, t22.id AS id_23, t22.created_at AS created_at_24, t22.updated_at AS updated_at_25, t22.user_id AS user_id_26 FROM user t0 LEFT JOIN artisan t14 ON t14.user_id = t0.id LEFT JOIN client t22 ON t22.user_id = t0.id WHERE t0.id = ?
Parameters:
0 of 0
[â–¼ 40 ]
15 0.42 ms
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.status AS status_6, t0.user_id AS user_id_7, t0.artisan_post_id AS artisan_post_id_8 FROM review t0 WHERE t0.artisan_post_id = ?
Parameters:
0 of 0
[â–¼ 25 ]
16 0.38 ms
SELECT t0.id AS id_1, t0.speciality AS speciality_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5 FROM artisan t0 WHERE t0.id = ?
Parameters:
0 of 0
[â–¼ 25 ]
17 0.54 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.whatsapp_number AS whatsapp_number_7, t0.phone AS phone_8, t0.address AS address_9, t0.avatar AS avatar_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.username AS username_13, t14.id AS id_15, t14.speciality AS speciality_16, t14.created_at AS created_at_17, t14.updated_at AS updated_at_18, t14.user_id AS user_id_19, t0.ville_id AS ville_id_20, t0.region_id AS region_id_21, t22.id AS id_23, t22.created_at AS created_at_24, t22.updated_at AS updated_at_25, t22.user_id AS user_id_26 FROM user t0 LEFT JOIN artisan t14 ON t14.user_id = t0.id LEFT JOIN client t22 ON t22.user_id = t0.id WHERE t0.id = ?
Parameters:
0 of 0
[â–¼ 39 ]
18 0.44 ms
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.status AS status_6, t0.user_id AS user_id_7, t0.artisan_post_id AS artisan_post_id_8 FROM review t0 WHERE t0.artisan_post_id = ?
Parameters:
0 of 0
[â–¼ 24 ]
19 0.39 ms
SELECT t0.id AS id_1, t0.speciality AS speciality_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5 FROM artisan t0 WHERE t0.id = ?
Parameters:
0 of 0
[â–¼ 24 ]
20 0.57 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.whatsapp_number AS whatsapp_number_7, t0.phone AS phone_8, t0.address AS address_9, t0.avatar AS avatar_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.username AS username_13, t14.id AS id_15, t14.speciality AS speciality_16, t14.created_at AS created_at_17, t14.updated_at AS updated_at_18, t14.user_id AS user_id_19, t0.ville_id AS ville_id_20, t0.region_id AS region_id_21, t22.id AS id_23, t22.created_at AS created_at_24, t22.updated_at AS updated_at_25, t22.user_id AS user_id_26 FROM user t0 LEFT JOIN artisan t14 ON t14.user_id = t0.id LEFT JOIN client t22 ON t22.user_id = t0.id WHERE t0.id = ?
Parameters:
0 of 0
[â–¼ 38 ]
21 0.42 ms
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.status AS status_6, t0.user_id AS user_id_7, t0.artisan_post_id AS artisan_post_id_8 FROM review t0 WHERE t0.artisan_post_id = ?
Parameters:
0 of 0
[â–¼ 23 ]
22 0.39 ms
SELECT t0.id AS id_1, t0.speciality AS speciality_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5 FROM artisan t0 WHERE t0.id = ?
Parameters:
0 of 0
[â–¼ 20 ]
23 0.54 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.whatsapp_number AS whatsapp_number_7, t0.phone AS phone_8, t0.address AS address_9, t0.avatar AS avatar_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.username AS username_13, t14.id AS id_15, t14.speciality AS speciality_16, t14.created_at AS created_at_17, t14.updated_at AS updated_at_18, t14.user_id AS user_id_19, t0.ville_id AS ville_id_20, t0.region_id AS region_id_21, t22.id AS id_23, t22.created_at AS created_at_24, t22.updated_at AS updated_at_25, t22.user_id AS user_id_26 FROM user t0 LEFT JOIN artisan t14 ON t14.user_id = t0.id LEFT JOIN client t22 ON t22.user_id = t0.id WHERE t0.id = ?
Parameters:
0 of 0
[â–¼ 34 ]
24 0.41 ms
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.status AS status_6, t0.user_id AS user_id_7, t0.artisan_post_id AS artisan_post_id_8 FROM review t0 WHERE t0.artisan_post_id = ?
Parameters:
0 of 0
[â–¼ 22 ]
25 0.37 ms
SELECT t0.id AS id_1, t0.speciality AS speciality_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5 FROM artisan t0 WHERE t0.id = ?
Parameters:
0 of 0
[â–¼ 23 ]
26 0.69 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.whatsapp_number AS whatsapp_number_7, t0.phone AS phone_8, t0.address AS address_9, t0.avatar AS avatar_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.username AS username_13, t14.id AS id_15, t14.speciality AS speciality_16, t14.created_at AS created_at_17, t14.updated_at AS updated_at_18, t14.user_id AS user_id_19, t0.ville_id AS ville_id_20, t0.region_id AS region_id_21, t22.id AS id_23, t22.created_at AS created_at_24, t22.updated_at AS updated_at_25, t22.user_id AS user_id_26 FROM user t0 LEFT JOIN artisan t14 ON t14.user_id = t0.id LEFT JOIN client t22 ON t22.user_id = t0.id WHERE t0.id = ?
Parameters:
0 of 0
[â–¼ 37 ]
27 0.44 ms
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.status AS status_6, t0.user_id AS user_id_7, t0.artisan_post_id AS artisan_post_id_8 FROM review t0 WHERE t0.artisan_post_id = ?
Parameters:
0 of 0
[â–¼ 21 ]
28 0.40 ms
SELECT t0.id AS id_1, t0.speciality AS speciality_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5 FROM artisan t0 WHERE t0.id = ?
Parameters:
0 of 0
[â–¼ 22 ]
29 0.55 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.whatsapp_number AS whatsapp_number_7, t0.phone AS phone_8, t0.address AS address_9, t0.avatar AS avatar_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.username AS username_13, t14.id AS id_15, t14.speciality AS speciality_16, t14.created_at AS created_at_17, t14.updated_at AS updated_at_18, t14.user_id AS user_id_19, t0.ville_id AS ville_id_20, t0.region_id AS region_id_21, t22.id AS id_23, t22.created_at AS created_at_24, t22.updated_at AS updated_at_25, t22.user_id AS user_id_26 FROM user t0 LEFT JOIN artisan t14 ON t14.user_id = t0.id LEFT JOIN client t22 ON t22.user_id = t0.id WHERE t0.id = ?
Parameters:
0 of 0
[â–¼ 36 ]
30 0.67 ms
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.status AS status_6, t0.user_id AS user_id_7, t0.artisan_post_id AS artisan_post_id_8 FROM review t0 WHERE t0.artisan_post_id = ?
Parameters:
0 of 0
[â–¼ 20 ]
31 1.02 ms
SELECT t0.id AS id_1, t0.speciality AS speciality_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5 FROM artisan t0 WHERE t0.id = ?
Parameters:
0 of 0
[â–¼ 21 ]
32 0.72 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.whatsapp_number AS whatsapp_number_7, t0.phone AS phone_8, t0.address AS address_9, t0.avatar AS avatar_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.username AS username_13, t14.id AS id_15, t14.speciality AS speciality_16, t14.created_at AS created_at_17, t14.updated_at AS updated_at_18, t14.user_id AS user_id_19, t0.ville_id AS ville_id_20, t0.region_id AS region_id_21, t22.id AS id_23, t22.created_at AS created_at_24, t22.updated_at AS updated_at_25, t22.user_id AS user_id_26 FROM user t0 LEFT JOIN artisan t14 ON t14.user_id = t0.id LEFT JOIN client t22 ON t22.user_id = t0.id WHERE t0.id = ?
Parameters:
0 of 0
[â–¼ 35 ]
33 0.47 ms
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.status AS status_6, t0.user_id AS user_id_7, t0.artisan_post_id AS artisan_post_id_8 FROM review t0 WHERE t0.artisan_post_id = ?
Parameters:
0 of 0
[â–¼ 18 ]
34 0.44 ms
SELECT t0.id AS id_1, t0.speciality AS speciality_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5 FROM artisan t0 WHERE t0.id = ?
Parameters:
0 of 0
[â–¼ 19 ]
35 0.60 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.whatsapp_number AS whatsapp_number_7, t0.phone AS phone_8, t0.address AS address_9, t0.avatar AS avatar_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.username AS username_13, t14.id AS id_15, t14.speciality AS speciality_16, t14.created_at AS created_at_17, t14.updated_at AS updated_at_18, t14.user_id AS user_id_19, t0.ville_id AS ville_id_20, t0.region_id AS region_id_21, t22.id AS id_23, t22.created_at AS created_at_24, t22.updated_at AS updated_at_25, t22.user_id AS user_id_26 FROM user t0 LEFT JOIN artisan t14 ON t14.user_id = t0.id LEFT JOIN client t22 ON t22.user_id = t0.id WHERE t0.id = ?
Parameters:
0 of 0
[â–¼ 33 ]
36 2.51 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, COUNT(a1_.id) AS sclr_2 FROM artisan_post a1_ INNER JOIN category c0_ ON a1_.category_id = c0_.id GROUP BY c0_.id, c0_.name ORDER BY sclr_2 DESC LIMIT 5
Parameters:
[]