Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.86 ms
(84.48%)
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
  198609
  212890
  389793
  392104
  410331
  411374
  415760
  416656
  427112
  429259
  434573
  439876
  439877
  441472
  444192
  445092
  445819
  448903
  449001
  450582
  451298
  451568
  452702
  452861
  454014
  454587
  456247
  456424
  456547
  456904
  457090
  458628
  460122
  465002
  466478
  470010
  470033
  471029
  471104
  476650
  477699
  482676
  483240
  483280
  484248
  485863
  486857
  493727
  496878
  496918
  497594
  498685
  499940
  503651
  504016
  505569
  507340
  507837
  512371
  516166
  523633
  528575
  530932
  543769
  548179
  550151
  557988
  561972
  562784
  566793
  567484
  572224
  576539
  586934
  592633
  598448
  600265
  600822
  602166
  602255
  602293
  614504
  621287
  627695
  631255
  632920
  648489
  649557
  652975
  654049
  669546
  669552
  671536
  672779
  683061
  686410
  690891
  700246
  706630
  717644
  723845
  728402
  730838
  731660
  742386
  748448
  761406
  767937
  778769
  780039
  785960
  787113
  788069
  790479
  792146
  794700
  807415
  808457
  808604
  811199
]
15.67 ms
(9.01%)
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
  614504
  631255
  790479
  731660
  728402
  742386
  448903
  445092
  466478
  450582
  452861
  470010
  471029
  512371
  483240
  198609
  212890
  476650
  566793
  576539
  586934
  592633
  807415
  808457
  811199
  794700
  785960
  429259
  444192
  505569
  530932
  706630
  767937
  761406
  451298
  483280
  456424
  493727
  465002
  496918
  499940
  496878
  485863
  648489
  649557
  654049
  683061
  669552
  672779
  652975
  671536
  700246
  548179
  550151
  567484
  600265
  456547
  497594
  498685
  528575
  452702
  778769
  788069
  792146
  787113
  389793
  441472
  717644
  410331
  416656
  482676
  686410
  572224
  602293
  454587
  477699
  471104
  427112
  439876
  627695
  723845
  690891
  730838
  748448
  451568
  460122
  470033
  392104
  669546
  808604
  456247
  456904
  507340
  543769
  602166
  621287
  780039
  449001
  439877
  411374
  434573
  486857
  484248
  523633
  557988
  562784
  632920
  600822
  598448
  602255
  516166
  507837
  503651
  415760
  457090
  445819
  454014
  458628
  504016
  561972
]
3.83 ms
(2.20%)
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
  198609
  212890
  389793
  392104
  410331
  411374
  415760
  416656
  427112
  429259
  434573
  439876
  439877
  441472
  444192
  445092
  445819
  448903
  449001
  450582
  451298
  451568
  452702
  452861
  454014
  454587
  456247
  456424
  456547
  456904
  457090
  458628
  460122
  465002
  466478
  470010
  470033
  471029
  471104
  476650
  477699
  482676
  483240
  483280
  484248
  485863
  486857
  493727
  496878
  496918
  497594
  498685
  499940
  503651
  504016
  505569
  507340
  507837
  512371
  516166
  523633
  528575
  530932
  543769
  548179
  550151
  557988
  561972
  562784
  566793
  567484
  572224
  576539
  586934
  592633
  598448
  600265
  600822
  602166
  602255
  602293
  614504
  621287
  627695
  631255
  632920
  648489
  649557
  652975
  654049
  669546
  669552
  671536
  672779
  683061
  686410
  690891
  700246
  706630
  717644
  723845
  728402
  730838
  731660
  742386
  748448
  761406
  767937
  778769
  780039
  785960
  787113
  788069
  790479
  792146
  794700
  807415
  808457
  808604
  811199
]
2.26 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur homemade webcam"
]
1.95 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск домашн любительск вебкамер"
]
1.67 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.91%)
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.