Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.46 ms
(79.12%)
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
  3381
  4245
  7088
  119987
  381775
  383419
  386166
  393550
  396139
  396681
  398914
  398918
  402217
  408425
  410783
  411257
  417428
  418125
  418774
  421181
  422488
  425137
  427433
  427502
  428569
  429948
  432909
  435358
  440654
  441004
  447115
  447134
  447453
  447484
  447530
  447551
  447790
  447796
  449435
  457585
  458755
  459491
  459497
  461738
  461938
  462108
  463331
  463764
  465949
  468020
  469751
  470379
  474737
  478012
  478482
  480017
  491194
  491639
  495820
  496087
  497550
  505324
  512504
  514145
  514430
  516737
  542092
  546970
  551107
  551417
  552209
  556841
  560038
  560478
  560631
  560639
  560645
  561649
  561673
  561677
  561702
  561832
  561846
  562116
  564401
  565324
  565951
  566657
  567338
  568357
  570537
  571900
  572042
  572307
  572755
  572954
  574841
  574905
  574910
  575212
  575798
  576077
  576088
  576388
  578501
  590081
  591240
  591367
  596526
  597260
  597572
  598700
  601978
  607093
  618923
  624220
  659615
  677042
  721393
  722882
]
20.78 ms
(13.65%)
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
  565951
  574905
  574910
  575798
  561677
  561702
  591367
  721393
  461938
  572042
  574841
  491194
  597572
  402217
  398914
  677042
  722882
  572755
  598700
  447134
  457585
  491639
  447796
  396139
  459491
  458755
  512504
  514145
  546970
  556841
  561832
  561846
  564401
  591240
  468020
  560038
  566657
  590081
  418774
  447530
  447551
  441004
  561673
  575212
  601978
  463764
  572954
  565324
  393550
  576077
  551417
  7088
  386166
  427433
  552209
  408425
  478012
  425137
  381775
  427502
  474737
  422488
  505324
  567338
  596526
  398918
  571900
  624220
  4245
  551107
  560639
  560645
  561649
  659615
  560478
  560631
  578501
  597260
  607093
  396681
  470379
  447115
  514430
  542092
  572307
  410783
  480017
  417428
  478482
  516737
  418125
  465949
  496087
  383419
  447790
  447453
  428569
  440654
  429948
  469751
  618923
  435358
  432909
  459497
  447484
  497550
  495820
  421181
  449435
  562116
  461738
  463331
  3381
  119987
  462108
  411257
  576088
  576388
  568357
  570537
]
3.36 ms
(2.21%)
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
  3381
  4245
  7088
  119987
  381775
  383419
  386166
  393550
  396139
  396681
  398914
  398918
  402217
  408425
  410783
  411257
  417428
  418125
  418774
  421181
  422488
  425137
  427433
  427502
  428569
  429948
  432909
  435358
  440654
  441004
  447115
  447134
  447453
  447484
  447530
  447551
  447790
  447796
  449435
  457585
  458755
  459491
  459497
  461738
  461938
  462108
  463331
  463764
  465949
  468020
  469751
  470379
  474737
  478012
  478482
  480017
  491194
  491639
  495820
  496087
  497550
  505324
  512504
  514145
  514430
  516737
  542092
  546970
  551107
  551417
  552209
  556841
  560038
  560478
  560631
  560639
  560645
  561649
  561673
  561677
  561702
  561832
  561846
  562116
  564401
  565324
  565951
  566657
  567338
  568357
  570537
  571900
  572042
  572307
  572755
  572954
  574841
  574905
  574910
  575212
  575798
  576077
  576088
  576388
  578501
  590081
  591240
  591367
  596526
  597260
  597572
  598700
  601978
  607093
  618923
  624220
  659615
  677042
  721393
  722882
]
2.09 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "small boy anal"
]
1.98 ms
(1.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.91 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "маленькая парен анал"
]
1.65 ms
(1.09%)
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.