Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.55 ms
(83.26%)
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
  415109
  422512
  423645
  427263
  428116
  428286
  430314
  433669
  443242
  443323
  448863
  449425
  453337
  468718
  469552
  471691
  474529
  475294
  476123
  476244
  478051
  479788
  481907
  481910
  483005
  483544
  485147
  491209
  491913
  492364
  493182
  497872
  503831
  504399
  511266
  517923
  522917
  525393
  525440
  528682
  533232
  533478
  535282
  536695
  540217
  541587
  541633
  541647
  541673
  541740
  541748
  541751
  541759
  541774
  541821
  541830
  541879
  542954
  544800
  545801
  545803
  550228
  550277
  550315
  550579
  552266
  558788
  559719
  560440
  563535
  566908
  568399
  568999
  571434
  574384
  576713
  583960
  583989
  585999
  586435
  597963
  599905
  602519
  604478
  604517
  605345
  614023
  628332
  632020
  632595
  632616
  632680
  632701
  635243
  637092
  641644
  643061
  644005
  647322
  651607
  653052
  656183
  665776
  666850
  676428
  695127
  695181
  710902
  711283
  715368
  743564
  765552
  787557
  789878
  792555
  803455
  807191
  823836
  824362
  824364
]
16.91 ms
(11.31%)
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
  583960
  483005
  493182
  644005
  517923
  449425
  481910
  469552
  511266
  525393
  566908
  541759
  632680
  497872
  428286
  743564
  710902
  503831
  443323
  550315
  443242
  428116
  476123
  492364
  481907
  545803
  568399
  576713
  559719
  571434
  550277
  491209
  504399
  423645
  533232
  474529
  479788
  541879
  653052
  647322
  614023
  605345
  433669
  476244
  522917
  415109
  422512
  583989
  540217
  550228
  711283
  807191
  823836
  787557
  585999
  666850
  765552
  604478
  448863
  491913
  541633
  628332
  695181
  558788
  715368
  824364
  574384
  586435
  471691
  478051
  552266
  560440
  468718
  824362
  536695
  525440
  483544
  535282
  550579
  545801
  651607
  665776
  602519
  641644
  430314
  544800
  541830
  541821
  632020
  632595
  803455
  604517
  632616
  485147
  427263
  597963
  695127
  792555
  789878
  533478
  563535
  541647
  541673
  541740
  541774
  541751
  568999
  656183
  676428
  541587
  542954
  635243
  632701
  475294
  453337
  528682
  541748
  643061
  637092
  599905
]
2.07 ms
(1.38%)
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
  415109
  422512
  423645
  427263
  428116
  428286
  430314
  433669
  443242
  443323
  448863
  449425
  453337
  468718
  469552
  471691
  474529
  475294
  476123
  476244
  478051
  479788
  481907
  481910
  483005
  483544
  485147
  491209
  491913
  492364
  493182
  497872
  503831
  504399
  511266
  517923
  522917
  525393
  525440
  528682
  533232
  533478
  535282
  536695
  540217
  541587
  541633
  541647
  541673
  541740
  541748
  541751
  541759
  541774
  541821
  541830
  541879
  542954
  544800
  545801
  545803
  550228
  550277
  550315
  550579
  552266
  558788
  559719
  560440
  563535
  566908
  568399
  568999
  571434
  574384
  576713
  583960
  583989
  585999
  586435
  597963
  599905
  602519
  604478
  604517
  605345
  614023
  628332
  632020
  632595
  632616
  632680
  632701
  635243
  637092
  641644
  643061
  644005
  647322
  651607
  653052
  656183
  665776
  666850
  676428
  695127
  695181
  710902
  711283
  715368
  743564
  765552
  787557
  789878
  792555
  803455
  807191
  823836
  824362
  824364
]
1.93 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "подборки в анал конча…"
]
1.50 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.35 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "подборк анал сперм"
]
1.27 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.