Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
150.16 ms
(87.35%)
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
  145635
  398124
  418773
  436055
  451517
  473962
  487254
  494588
  509298
  512087
  513632
  513670
  531736
  533655
  536295
  539317
  543546
  544967
  547782
  548644
  548957
  555547
  557529
  559420
  566397
  570868
  579218
  583232
  587491
  595455
  600731
  617552
  618475
  625921
  627414
  628559
  628566
  642963
  645745
  650305
  661619
  662150
  664181
  664573
  665081
  666981
  667363
  669899
  670963
  672836
  675344
  684500
  685742
  688173
  689877
  689885
  696758
  701344
  702318
  703218
  709676
  710777
  718825
  727048
  730508
  734251
  738491
  743920
  746098
  746592
  750204
  756496
  758953
  759072
  759823
  764071
  764237
  768725
  768757
  772166
  773747
  774661
  777753
  779641
  782108
  783954
  785362
  788662
  788874
  790139
  791723
  792368
  792706
  794212
  799150
  801430
  802932
  803385
  804232
  804679
  804702
  806596
  806801
  810092
  812040
  812292
  812296
  812538
  813196
  816644
  817650
  819822
  819836
  824611
  824710
  824857
  825183
  825579
]
11.42 ms
(6.64%)
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
  650305
  669899
  685742
  689885
  703218
  664181
  664573
  666981
  684500
  710777
  547782
  548957
  617552
  627414
  587491
  595455
  600731
  625921
  777753
  779641
  790139
  792368
  806596
  801430
  803361
  806801
  812296
  734251
  758953
  759072
  772166
  782108
  783954
  785362
  788662
  791723
  812292
  812538
  813196
  768725
  727048
  768757
  730508
  738491
  746592
  759823
  764071
  773747
  756496
  764237
  642963
  774661
  788874
  792706
  794212
  799150
  804232
  812040
  436055
  513670
  487254
  513632
  548644
  696758
  579218
  743746
  743920
  398124
  628566
  802932
  803385
  804679
  819822
  824611
  533655
  544967
  557529
  566397
  618475
  750204
  718825
  451517
  583232
  628559
  804702
  746098
  810092
  418773
  512087
  145635
  816644
  824710
  824857
  817650
  819836
  825183
  825579
  473962
  539317
  509298
  531736
  494588
  536295
  570868
  543546
  555547
  559420
  645745
  661619
  662150
  702318
  665081
  670963
  675344
  689877
  701344
  709676
  667363
  672836
  688173
]
2.91 ms
(1.69%)
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
  145635
  398124
  418773
  436055
  451517
  473962
  487254
  494588
  509298
  512087
  513632
  513670
  531736
  533655
  536295
  539317
  543546
  544967
  547782
  548644
  548957
  555547
  557529
  559420
  566397
  570868
  579218
  583232
  587491
  595455
  600731
  617552
  618475
  625921
  627414
  628559
  628566
  642963
  645745
  650305
  661619
  662150
  664181
  664573
  665081
  666981
  667363
  669899
  670963
  672836
  675344
  684500
  685742
  688173
  689877
  689885
  696758
  701344
  702318
  703218
  709676
  710777
  718825
  727048
  730508
  734251
  738491
  743920
  746098
  746592
  750204
  756496
  758953
  759072
  759823
  764071
  764237
  768725
  768757
  772166
  773747
  774661
  777753
  779641
  782108
  783954
  785362
  788662
  788874
  790139
  791723
  792368
  792706
  794212
  799150
  801430
  802932
  803385
  804232
  804679
  804702
  806596
  806801
  810092
  812040
  812292
  812296
  812538
  813196
  816644
  817650
  819822
  819836
  824611
  824710
  824857
  825183
  825579
]
2.32 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð╝ð░ÐüÐéÐâÐÇð▒ð░ÐåÐÅ ð┐ðÁÐÇðÁð┤ ð╝ÐâðÂð%ÔǪ"
]
1.94 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мастурбац жен"
]
1.45 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.