https://testshopapp.julico.io/home

Query Metrics

57 Database Queries
11 Different statements
48.82 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.44 ms
SELECT m0_.id AS id_0, m0_.start_time AS start_time_1, m0_.end_time AS end_time_2, m0_.description AS description_3, m0_.is_active AS is_active_4 FROM maintenance_schedule m0_ WHERE m0_.is_active = ? AND m0_.start_time <= ? AND m0_.end_time >= ? ORDER BY m0_.end_time DESC LIMIT 1
Parameters:
[
  1
  "2026-06-16 20:13:30"
  "2026-06-16 20:13:30"
]
2 8.84 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.logo_path AS logo_path_3, t0.active AS active_4, t0.subscription_paid_until AS subscription_paid_until_5, t0.adresse AS adresse_6, t0.telephone AS telephone_7, t0.numero_cr AS numero_cr_8, t0.numero_tva AS numero_tva_9, t0.country_id AS country_id_10, t0.region_id AS region_id_11, t0.city_id AS city_id_12 FROM magasin t0
Parameters:
[]
3 0.37 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.tax AS tax_3 FROM category t0 ORDER BY t0.nom ASC
Parameters:
[]
4 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.phone_code AS phone_code_4 FROM country t0 ORDER BY t0.name ASC
Parameters:
[]
5 0.23 ms
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.tax AS tax_2 FROM category c0_
Parameters:
[]
6 0.59 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.product_name AS product_name_1, p0_.qtt AS qtt_2, p0_.prix AS prix_3, p0_.publish_item AS publish_item_4, p0_.promo AS promo_5, p0_.description AS description_6, p0_.publish_date AS publish_date_7, p0_.sale_price AS sale_price_8, p0_.cost_price AS cost_price_9, p0_.date_production AS date_production_10, p0_.date_expiration AS date_expiration_11, p0_.variant_type AS variant_type_12, p0_.variant_type2 AS variant_type2_13, p0_.variant_type3 AS variant_type3_14, c1_.id AS id_15, c1_.nom AS nom_16, c1_.tax AS tax_17 FROM produit p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id LEFT JOIN magasin m2_ ON p0_.magasin_id = m2_.id WHERE (p0_.publish_item = 1 OR ? = 1) AND ((m2_.active = 1 AND (m2_.subscription_paid_until IS NULL OR m2_.subscription_paid_until >= ?)) OR ? = 1) ORDER BY p0_.id DESC) dctrn_result) dctrn_table
Parameters:
[
  0
  "2026-06-16 00:00:00"
  0
]
7 0.53 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.product_name AS product_name_1, p0_.qtt AS qtt_2, p0_.prix AS prix_3, p0_.publish_item AS publish_item_4, p0_.promo AS promo_5, p0_.description AS description_6, p0_.publish_date AS publish_date_7, p0_.sale_price AS sale_price_8, p0_.cost_price AS cost_price_9, p0_.date_production AS date_production_10, p0_.date_expiration AS date_expiration_11, p0_.variant_type AS variant_type_12, p0_.variant_type2 AS variant_type2_13, p0_.variant_type3 AS variant_type3_14 FROM produit p0_ LEFT JOIN magasin m1_ ON p0_.magasin_id = m1_.id WHERE p0_.publish_date <= ? AND p0_.publish_date >= ? AND (p0_.publish_item = 1 OR ? = 1) AND ((m1_.active = 1 AND (m1_.subscription_paid_until IS NULL OR m1_.subscription_paid_until >= ?)) OR ? = 1) ORDER BY p0_.publish_date DESC) dctrn_result) dctrn_table
Parameters:
[
  "2026-06-16 20:13:30"
  "2026-05-17 20:13:30"
  0
  "2026-06-16 00:00:00"
  0
]
8 0.58 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.product_name AS product_name_1, p0_.qtt AS qtt_2, p0_.prix AS prix_3, p0_.publish_item AS publish_item_4, p0_.promo AS promo_5, p0_.description AS description_6, p0_.publish_date AS publish_date_7, p0_.sale_price AS sale_price_8, p0_.cost_price AS cost_price_9, p0_.date_production AS date_production_10, p0_.date_expiration AS date_expiration_11, p0_.variant_type AS variant_type_12, p0_.variant_type2 AS variant_type2_13, p0_.variant_type3 AS variant_type3_14, c1_.id AS id_15, c1_.nom AS nom_16, c1_.tax AS tax_17, m2_.id AS id_18, m2_.nom AS nom_19, m2_.logo_path AS logo_path_20, m2_.active AS active_21, m2_.subscription_paid_until AS subscription_paid_until_22, m2_.adresse AS adresse_23, m2_.telephone AS telephone_24, m2_.numero_cr AS numero_cr_25, m2_.numero_tva AS numero_tva_26 FROM produit p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id LEFT JOIN magasin m2_ ON p0_.magasin_id = m2_.id WHERE (p0_.publish_item = 1 OR ? = 1) AND ((m2_.active = 1 AND (m2_.subscription_paid_until IS NULL OR m2_.subscription_paid_until >= ?)) OR ? = 1)) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 24
Parameters:
[
  0
  "2026-06-16 00:00:00"
  0
]
9 0.63 ms
SELECT p0_.id AS id_0, p0_.product_name AS product_name_1, p0_.qtt AS qtt_2, p0_.prix AS prix_3, p0_.publish_item AS publish_item_4, p0_.promo AS promo_5, p0_.description AS description_6, p0_.publish_date AS publish_date_7, p0_.sale_price AS sale_price_8, p0_.cost_price AS cost_price_9, p0_.date_production AS date_production_10, p0_.date_expiration AS date_expiration_11, p0_.variant_type AS variant_type_12, p0_.variant_type2 AS variant_type2_13, p0_.variant_type3 AS variant_type3_14, c1_.id AS id_15, c1_.nom AS nom_16, c1_.tax AS tax_17, p0_.category_id AS category_id_18, p0_.user_id AS user_id_19, p0_.magasin_id AS magasin_id_20 FROM produit p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id LEFT JOIN magasin m2_ ON p0_.magasin_id = m2_.id WHERE (p0_.publish_item = 1 OR ? = 1) AND ((m2_.active = 1 AND (m2_.subscription_paid_until IS NULL OR m2_.subscription_paid_until >= ?)) OR ? = 1) AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.id DESC
Parameters:
[
  0
  "2026-06-16 00:00:00"
  0
  68
  66
  65
  61
  60
  59
  58
  57
  56
  55
  53
  45
  43
  42
  41
  40
  39
  38
  36
  35
  32
  30
  29
  28
]
10 8.69 ms
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
  68
]
11 0.27 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4, t0.produit_variant_id AS produit_variant_id_5 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
  68
]
12 0.29 ms
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
  66
]
13 0.28 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4, t0.produit_variant_id AS produit_variant_id_5 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
  66
]
14 0.24 ms
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
  65
]
15 0.23 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4, t0.produit_variant_id AS produit_variant_id_5 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
  65
]
16 0.24 ms
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
  61
]
17 0.22 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4, t0.produit_variant_id AS produit_variant_id_5 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
  61
]
18 0.25 ms
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
  60
]
19 0.24 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4, t0.produit_variant_id AS produit_variant_id_5 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
  60
]
20 0.21 ms
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
  59
]
21 0.20 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4, t0.produit_variant_id AS produit_variant_id_5 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
  59
]
22 0.22 ms
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
  58
]
23 11.87 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4, t0.produit_variant_id AS produit_variant_id_5 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
  58
]
24 0.25 ms
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
  57
]
25 0.23 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4, t0.produit_variant_id AS produit_variant_id_5 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
  57
]
26 0.28 ms
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
  56
]
27 0.21 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4, t0.produit_variant_id AS produit_variant_id_5 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
  56
]
28 0.22 ms
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
  55
]
29 0.21 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4, t0.produit_variant_id AS produit_variant_id_5 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
  55
]
30 0.20 ms
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
  53
]
31 0.21 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4, t0.produit_variant_id AS produit_variant_id_5 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
  53
]
32 0.22 ms
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
  45
]
33 0.21 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4, t0.produit_variant_id AS produit_variant_id_5 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
  45
]
34 0.20 ms
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
  43
]
35 0.19 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4, t0.produit_variant_id AS produit_variant_id_5 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
  43
]
36 0.21 ms
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
  42
]
37 0.24 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4, t0.produit_variant_id AS produit_variant_id_5 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
  42
]
38 0.24 ms
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
  41
]
39 0.22 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4, t0.produit_variant_id AS produit_variant_id_5 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
  41
]
40 0.20 ms
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
  40
]
41 0.19 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4, t0.produit_variant_id AS produit_variant_id_5 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
  40
]
42 0.21 ms
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
  39
]
43 0.19 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4, t0.produit_variant_id AS produit_variant_id_5 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
  39
]
44 0.19 ms
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
  38
]
45 0.24 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4, t0.produit_variant_id AS produit_variant_id_5 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
  38
]
46 0.22 ms
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
  36
]
47 0.20 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4, t0.produit_variant_id AS produit_variant_id_5 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
  36
]
48 0.20 ms
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
  35
]
49 0.19 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4, t0.produit_variant_id AS produit_variant_id_5 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
  35
]
50 0.24 ms
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
  32
]
51 0.20 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4, t0.produit_variant_id AS produit_variant_id_5 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
  32
]
52 0.24 ms
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
  30
]
53 0.21 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4, t0.produit_variant_id AS produit_variant_id_5 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
  30
]
54 0.27 ms
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
  29
]
55 5.74 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4, t0.produit_variant_id AS produit_variant_id_5 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
  29
]
56 0.22 ms
SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = ?
Parameters:
[
  28
]
57 0.21 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4, t0.produit_variant_id AS produit_variant_id_5 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
  28
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping