Query Metrics

7 Database Queries
7 Different statements
159.57 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
132.47 ms
(83.02%)
1
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  11393
  96946
  261144
  357595
  378401
  383985
  391087
  392986
  400483
  405042
  408319
  408668
  409814
  417744
  423706
  432744
  439135
  442980
  445135
  445468
  446694
  447557
  447749
  452779
  454536
  455641
  457014
  457514
  461447
  461722
  463876
  465040
  468105
  468183
  469574
  472773
  472951
  474946
  474956
  475981
  476742
  482338
  483114
  484278
  484689
  484899
  485073
  488700
  489128
  490278
  490788
  491944
  493236
  493319
  493743
  496882
  497906
  497949
  505905
  508950
  513157
  513499
  515848
  516485
  518922
  520937
  521885
  522970
  523548
  523832
  524876
  524939
  526527
  527859
  535309
  541860
  544401
  545711
  546762
  552809
  556474
  557969
  560478
  561361
  561649
  561880
  563173
  565119
  567392
  569012
  569981
  572556
  572697
  574237
  574664
  575512
  576271
  578484
  581242
  591149
  591398
  592413
  595436
  599031
  602102
  604326
  606299
  608464
  609883
  619484
  621794
  622364
  622893
  623435
  627420
  653549
  654372
  668559
  677362
  687174
]
17.62 ms
(11.04%)
1
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  604326
  627420
  619484
  468183
  357595
  383985
  400483
  461447
  472773
  261144
  454536
  457514
  455641
  468105
  474956
  527859
  484689
  490278
  491944
  522970
  493743
  524939
  497906
  526527
  439135
  513157
  556474
  606299
  508950
  546762
  608464
  96946
  445468
  483114
  469574
  552809
  391087
  392986
  11393
  474946
  409814
  417744
  475981
  482338
  563173
  569012
  569981
  575512
  561880
  578484
  541860
  561361
  654372
  687174
  653549
  581242
  609883
  595436
  602102
  592413
  622893
  476742
  472951
  447557
  505905
  520937
  523832
  493236
  513499
  515848
  432744
  423706
  668559
  489128
  457014
  518922
  521885
  535309
  544401
  557969
  576271
  574664
  545711
  561649
  565119
  574237
  677362
  560478
  567392
  572556
  591149
  591398
  621794
  623435
  599031
  622364
  447749
  461722
  408668
  405042
  445135
  463876
  516485
  524876
  484899
  490788
  496882
  488700
  497949
  484278
  493319
  523548
  572697
  378401
  408319
  442980
  446694
  452779
  485073
  465040
]
2.39 ms
(1.50%)
1
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  11393
  96946
  261144
  357595
  378401
  383985
  391087
  392986
  400483
  405042
  408319
  408668
  409814
  417744
  423706
  432744
  439135
  442980
  445135
  445468
  446694
  447557
  447749
  452779
  454536
  455641
  457014
  457514
  461447
  461722
  463876
  465040
  468105
  468183
  469574
  472773
  472951
  474946
  474956
  475981
  476742
  482338
  483114
  484278
  484689
  484899
  485073
  488700
  489128
  490278
  490788
  491944
  493236
  493319
  493743
  496882
  497906
  497949
  505905
  508950
  513157
  513499
  515848
  516485
  518922
  520937
  521885
  522970
  523548
  523832
  524876
  524939
  526527
  527859
  535309
  541860
  544401
  545711
  546762
  552809
  556474
  557969
  560478
  561361
  561649
  561880
  563173
  565119
  567392
  569012
  569981
  572556
  572697
  574237
  574664
  575512
  576271
  578484
  581242
  591149
  591398
  592413
  595436
  599031
  602102
  604326
  606299
  608464
  609883
  619484
  621794
  622364
  622893
  623435
  627420
  653549
  654372
  668559
  677362
  687174
]
1.92 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skirt in anal"
]
1.88 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "юбк анал"
]
1.61 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "юбк анал"
]

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

No loaded entities.