GET https://www.v3.agriland.shop/categorie/1-materiels-d%27occasion?page=4

Response
200 OK
IP
216.73.216.48
Profiled on
Token
33b569

Query Metrics

23 Database Queries
8 Different statements
195.70 ms Query time
1 Invalid entities
98 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.15 ms 
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.slug = ? LIMIT 1
Parameters: 
[
  "1-materiels-d'occasion"
]
View formatted query    View runnable query    Explain query
2 0.14 ms 
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
3 0.12 ms 
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = ?
Parameters: 
[
  6
]
View formatted query    View runnable query    Explain query
4 0.10 ms 
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = ?
Parameters: 
[
  7
]
View formatted query    View runnable query    Explain query
5 0.10 ms 
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = ?
Parameters: 
[
  8
]
View formatted query    View runnable query    Explain query
6 0.10 ms 
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = ?
Parameters: 
[
  9
]
View formatted query    View runnable query    Explain query
7 0.07 ms 
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = ?
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query
8 0.07 ms 
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = ?
Parameters: 
[
  11
]
View formatted query    View runnable query    Explain query
9 0.12 ms 
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = ?
Parameters: 
[
  12
]
View formatted query    View runnable query    Explain query
10 0.13 ms 
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = ?
Parameters: 
[
  13
]
View formatted query    View runnable query    Explain query
11 0.13 ms 
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = ?
Parameters: 
[
  14
]
View formatted query    View runnable query    Explain query
12 0.11 ms 
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = ?
Parameters: 
[
  15
]
View formatted query    View runnable query    Explain query
13 0.12 ms 
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = ?
Parameters: 
[
  16
]
View formatted query    View runnable query    Explain query
14 0.12 ms 
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = ?
Parameters: 
[
  17
]
View formatted query    View runnable query    Explain query
15 0.10 ms 
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = ?
Parameters: 
[
  42
]
View formatted query    View runnable query    Explain query
16 0.07 ms 
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = ?
Parameters: 
[
  129
]
View formatted query    View runnable query    Explain query
17 0.07 ms 
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = ?
Parameters: 
[
  214
]
View formatted query    View runnable query    Explain query
18 11.45 ms 
SELECT DISTINCT mrq.id, mrq.nom
            FROM article a
            INNER JOIN marque mrq ON mrq.id = a.marque_id
            WHERE a.publie = 1
              AND a.marque_id IS NOT NULL
         AND EXISTS (
                SELECT 1 FROM groupe_famille_article_article gfaa
                INNER JOIN machine_categorie mc ON mc.id = gfaa.machine_categorie_id
                WHERE gfaa.article_id = a.id AND mc.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
            ) ORDER BY mrq.nom ASC
Parameters: 
[
  1
  6
  18
  19
  20
  192
  7
  39
  40
  41
  8
  31
  32
  33
  9
  26
  27
  28
  29
  190
  10
  23
  24
  30
  60
  11
  45
  58
  197
  208
  212
  12
  55
  56
  57
  13
  21
  22
  25
  38
  52
  53
  67
  75
  131
  132
  213
  14
  62
  63
  15
  43
  44
  202
  215
  16
  34
  35
  36
  37
  17
  61
  64
  66
  209
  210
  211
  42
  129
  200
  201
  203
  204
  207
  214
]
View formatted query    View runnable query    Explain query
19 84.34 ms 
SELECT DISTINCT mv.id, mv.nom
            FROM article a
            INNER JOIN article_application aa ON aa.article_id = a.id
            INNER JOIN modele mdl ON mdl.id = aa.modele_id
            INNER JOIN marque_vehicule mv ON mv.id = mdl.marque_vehicule_id
            WHERE a.publie = 1
         AND EXISTS (
                SELECT 1 FROM groupe_famille_article_article gfaa
                INNER JOIN machine_categorie mc ON mc.id = gfaa.machine_categorie_id
                WHERE gfaa.article_id = a.id AND mc.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
            ) ORDER BY mv.nom ASC
Parameters: 
[
  1
  6
  18
  19
  20
  192
  7
  39
  40
  41
  8
  31
  32
  33
  9
  26
  27
  28
  29
  190
  10
  23
  24
  30
  60
  11
  45
  58
  197
  208
  212
  12
  55
  56
  57
  13
  21
  22
  25
  38
  52
  53
  67
  75
  131
  132
  213
  14
  62
  63
  15
  43
  44
  202
  215
  16
  34
  35
  36
  37
  17
  61
  64
  66
  209
  210
  211
  42
  129
  200
  201
  203
  204
  207
  214
]
View formatted query    View runnable query    Explain query
20 87.73 ms 
SELECT DISTINCT a0_.id AS id_0, a0_.num_article_erp AS num_article_erp_1, a0_.reference AS reference_2, a0_.titre_web AS titre_web_3, a0_.description_web AS description_web_4, a0_.meta_titre AS meta_titre_5, a0_.meta_mots_cles AS meta_mots_cles_6, a0_.meta_description AS meta_description_7, a0_.reference_oem AS reference_oem_8, a0_.ref_marked AS ref_marked_9, a0_.prix_vente AS prix_vente_10, a0_.prix_achat AS prix_achat_11, a0_.unite AS unite_12, a0_.notes AS notes_13, a0_.stock AS stock_14, a0_.nombre_dans_lot AS nombre_dans_lot_15, a0_.publie AS publie_16, a0_.date_creation AS date_creation_17, a0_.date_synchronisation AS date_synchronisation_18, a0_.en_stock AS en_stock_19, a0_.slug AS slug_20, a1_.id AS id_21, a1_.id_erp AS id_erp_22, a1_.nom_fichier AS nom_fichier_23, a1_.photo_par_defaut AS photo_par_defaut_24, a1_.nom_fichier_card AS nom_fichier_card_25, a0_.marque_id AS marque_id_26, a1_.article_id AS article_id_27 FROM article a0_ LEFT JOIN groupe_famille_article_article g2_ ON a0_.id = g2_.article_id LEFT JOIN machine_categorie m3_ ON g2_.machine_categorie_id = m3_.id LEFT JOIN article_photo a1_ ON a0_.id = a1_.article_id WHERE a0_.publie = 1 AND m3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.date_creation DESC, a1_.photo_par_defaut DESC LIMIT 12 OFFSET 36
Parameters: 
[
  1
  6
  18
  19
  20
  192
  7
  39
  40
  41
  8
  31
  32
  33
  9
  26
  27
  28
  29
  190
  10
  23
  24
  30
  60
  11
  45
  58
  197
  208
  212
  12
  55
  56
  57
  13
  21
  22
  25
  38
  52
  53
  67
  75
  131
  132
  213
  14
  62
  63
  15
  43
  44
  202
  215
  16
  34
  35
  36
  37
  17
  61
  64
  66
  209
  210
  211
  42
  129
  200
  201
  203
  204
  207
  214
]
View formatted query    View runnable query    Explain query
21 10.10 ms 
SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM article a0_ LEFT JOIN groupe_famille_article_article g1_ ON a0_.id = g1_.article_id LEFT JOIN machine_categorie m2_ ON g1_.machine_categorie_id = m2_.id WHERE a0_.publie = 1 AND m2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  1
  6
  18
  19
  20
  192
  7
  39
  40
  41
  8
  31
  32
  33
  9
  26
  27
  28
  29
  190
  10
  23
  24
  30
  60
  11
  45
  58
  197
  208
  212
  12
  55
  56
  57
  13
  21
  22
  25
  38
  52
  53
  67
  75
  131
  132
  213
  14
  62
  63
  15
  43
  44
  202
  215
  16
  34
  35
  36
  37
  17
  61
  64
  66
  209
  210
  211
  42
  129
  200
  201
  203
  204
  207
  214
]
View formatted query    View runnable query    Explain query
22 0.15 ms 
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id IS NULL ORDER BY t0.nom ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
23 0.09 ms 
SELECT t0.id AS id_1, t0.id_marque_erp AS id_marque_erp_2, t0.nom AS nom_3, t0.code AS code_4 FROM marque t0 WHERE t0.id = ?
Parameters: 
[
  79
]
View formatted query    View runnable query    Explain query

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\MachineCategorie 85
App\Entity\Article 12
App\Entity\Marque 1

Entities Mapping

Class Mapping errors
App\Entity\MachineCategorie No errors.
App\Entity\GroupeFamilleArticle No errors.
App\Entity\Article
  • The field App\Entity\Article#groupeFamilleArticleArticles is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\GroupeFamilleArticleArticle#article does not contain the required 'inversedBy="groupeFamilleArticleArticles"' attribute.
  • The field App\Entity\Article#articleApplications is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ArticleApplication#article does not contain the required 'inversedBy="articleApplications"' attribute.
App\Entity\GroupeFamilleArticleArticle No errors.
App\Entity\ArticlePhoto No errors.
App\Entity\Marque No errors.
App\Entity\ArticleApplication No errors.