Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
222.68 ms
(90.21%)
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
  184735
  188447
  382172
  385031
  398871
  406074
  418689
  421445
  426245
  427771
  433373
  439006
  439011
  440909
  441770
  441897
  442135
  445105
  452864
  456701
  457060
  458019
  458322
  459066
  459210
  459325
  459621
  461050
  461901
  465784
  469130
  470888
  471506
  472894
  477415
  479178
  479362
  481247
  481678
  483075
  484174
  486008
  486808
  491124
  492643
  493808
  494452
  498616
  498880
  501031
  502592
  508877
  513054
  515369
  521634
  521902
  524950
  525308
  525695
  529236
  529448
  538265
  545635
  547967
  548039
  548601
  549595
  549648
  552052
  555015
  557402
  560103
  561240
  561372
  563299
  563762
  564559
  565062
  565333
  565706
  570241
  570528
  570833
  573300
  598216
  618504
  619310
  641109
  645736
  650859
  652353
  652501
  659459
  662925
  665101
  665255
  665351
  667278
  667546
  667829
  668796
  669456
  692188
  692319
  705020
  707933
  708254
  710418
  716076
  737557
  759908
  762285
  771147
  781609
  785195
  791812
  792816
  796543
  797382
  810863
]
13.07 ms
(5.30%)
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
  427771
  426245
  459210
  461050
  477415
  459325
  486808
  481678
  547967
  560103
  561372
  645736
  692319
  708254
  652353
  652501
  659459
  662925
  668796
  549595
  573300
  618504
  781609
  762285
  737557
  771147
  459066
  479362
  398871
  440909
  433373
  445105
  459621
  521634
  502592
  525308
  513054
  184735
  382172
  441770
  418689
  442135
  439011
  486008
  498616
  564559
  548039
  549648
  665351
  667278
  705020
  563762
  619310
  797382
  796543
  188447
  406074
  457060
  461901
  465784
  481247
  525695
  491124
  508877
  810863
  385031
  458322
  570833
  692188
  785195
  498880
  570241
  557402
  548601
  565062
  710418
  716076
  665255
  669456
  707933
  561240
  641109
  759908
  469130
  521902
  479178
  470888
  483075
  484174
  515369
  565706
  552052
  555015
  667546
  665101
  667829
  598216
  791812
  792816
  452864
  456701
  524950
  529448
  494452
  538265
  492643
  529236
  421445
  441897
  439006
  458019
  472894
  493808
  501031
  471506
  545635
  570528
  563299
  565333
  650859
]
4.49 ms
(1.82%)
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
  184735
  188447
  382172
  385031
  398871
  406074
  418689
  421445
  426245
  427771
  433373
  439006
  439011
  440909
  441770
  441897
  442135
  445105
  452864
  456701
  457060
  458019
  458322
  459066
  459210
  459325
  459621
  461050
  461901
  465784
  469130
  470888
  471506
  472894
  477415
  479178
  479362
  481247
  481678
  483075
  484174
  486008
  486808
  491124
  492643
  493808
  494452
  498616
  498880
  501031
  502592
  508877
  513054
  515369
  521634
  521902
  524950
  525308
  525695
  529236
  529448
  538265
  545635
  547967
  548039
  548601
  549595
  549648
  552052
  555015
  557402
  560103
  561240
  561372
  563299
  563762
  564559
  565062
  565333
  565706
  570241
  570528
  570833
  573300
  598216
  618504
  619310
  641109
  645736
  650859
  652353
  652501
  659459
  662925
  665101
  665255
  665351
  667278
  667546
  667829
  668796
  669456
  692188
  692319
  705020
  707933
  708254
  710418
  716076
  737557
  759908
  762285
  771147
  781609
  785195
  791812
  792816
  796543
  797382
  810863
]
1.92 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "секс сзади"
]
1.68 ms
(0.68%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс сзад"
]
1.58 ms
(0.64%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.41 ms
(0.57%)
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.