Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
161.69 ms
(86.41%)
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
  336986
  396676
  415365
  416943
  422657
  423039
  423283
  426737
  429292
  436440
  440711
  443749
  444027
  463124
  470080
  473529
  484097
  485308
  486658
  487087
  489820
  489931
  491286
  491365
  491663
  491666
  491671
  491672
  492727
  496448
  497424
  499794
  501804
  505238
  508198
  508437
  508848
  508850
  508857
  508865
  508881
  511713
  512900
  513662
  514781
  517223
  519690
  519695
  521802
  522072
  522569
  522837
  524199
  524717
  525235
  527630
  528092
  531583
  539101
  540614
  540928
  541879
  544937
  548257
  548651
  548671
  550047
  552632
  554366
  561085
  566791
  567223
  570922
  574805
  574810
  575093
  575458
  575473
  575482
  575493
  575520
  575754
  576030
  576063
  576413
  577023
  580673
  580675
  597244
  600472
  602232
  605523
  606690
  651944
  653520
  653554
  653560
  653561
  670540
  695124
  709814
  712514
  713684
  715421
  726306
  735727
  740414
  742151
  752773
  754805
  763814
  766422
  766687
  778344
  778569
  794508
  806331
  807689
  819165
  821871
]
17.38 ms
(9.29%)
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
  485308
  566791
  492727
  575754
  440711
  489931
  528092
  735727
  531583
  525235
  497424
  600472
  740414
  519690
  544937
  499794
  436440
  444027
  819165
  561085
  670540
  715421
  763814
  766422
  754805
  742151
  489820
  550047
  580673
  470080
  508437
  426737
  580675
  491666
  423039
  653554
  473529
  415365
  575458
  575473
  486658
  821871
  540614
  605523
  778569
  778344
  501804
  548671
  651944
  508865
  517223
  575493
  522569
  505238
  508848
  514781
  524199
  597244
  496448
  695124
  512900
  577023
  709814
  752773
  570922
  540928
  574810
  575520
  606690
  463124
  511713
  491663
  491672
  508850
  508881
  491671
  602232
  429292
  521802
  807689
  653560
  423283
  522072
  487087
  522837
  576413
  576030
  513662
  766687
  396676
  712514
  713684
  794508
  443749
  416943
  336986
  422657
  491286
  519695
  548257
  567223
  575482
  574805
  576063
  552632
  575093
  653520
  548651
  554366
  726306
  539101
  491365
  508857
  524717
  527630
  484097
  653561
  806331
  508198
  541879
]
2.43 ms
(1.30%)
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
  336986
  396676
  415365
  416943
  422657
  423039
  423283
  426737
  429292
  436440
  440711
  443749
  444027
  463124
  470080
  473529
  484097
  485308
  486658
  487087
  489820
  489931
  491286
  491365
  491663
  491666
  491671
  491672
  492727
  496448
  497424
  499794
  501804
  505238
  508198
  508437
  508848
  508850
  508857
  508865
  508881
  511713
  512900
  513662
  514781
  517223
  519690
  519695
  521802
  522072
  522569
  522837
  524199
  524717
  525235
  527630
  528092
  531583
  539101
  540614
  540928
  541879
  544937
  548257
  548651
  548671
  550047
  552632
  554366
  561085
  566791
  567223
  570922
  574805
  574810
  575093
  575458
  575473
  575482
  575493
  575520
  575754
  576030
  576063
  576413
  577023
  580673
  580675
  597244
  600472
  602232
  605523
  606690
  651944
  653520
  653554
  653560
  653561
  670540
  695124
  709814
  712514
  713684
  715421
  726306
  735727
  740414
  742151
  752773
  754805
  763814
  766422
  766687
  778344
  778569
  794508
  806331
  807689
  819165
  821871
]
1.63 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "бдсм 18-19 летние"
]
1.48 ms
(0.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.39 ms
(0.74%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "бдсм 18 19 лет"
]
1.12 ms
(0.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "бдсм 18 19 лет"
]

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.