Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.19 ms
(81.38%)
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
  10934
  12731
  45306
  51635
  58201
  69631
  73421
  91379
  92019
  97156
  137159
  163536
  191139
  193883
  206386
  213627
  304679
  311235
  382233
  382739
  385088
  385342
  385759
  386879
  387012
  387334
  388862
  389257
  389355
  390166
  391729
  392097
  396265
  396331
  397769
  397807
  397872
  400042
  400492
  402030
  402618
  402941
  402980
  403153
  407684
  408546
  409941
  410745
  411720
  411904
  413731
  419062
  424268
  427544
  429584
  433684
  434072
  440068
  446042
  446783
  448218
  448338
  451043
  452240
  452253
  452830
  454400
  456245
  457019
  457631
  457736
  457739
  459204
  459647
  460850
  464362
  465019
  465685
  465899
  466888
  468284
  468357
  469408
  470007
  471850
  472682
  474486
  476086
  477576
  478976
  479127
  488775
  491214
  495336
  496803
  498125
  498838
  499893
  505089
  507389
  513582
  514116
  521200
  525749
  527697
  541626
  542915
  545628
  550360
  556901
  565880
  572630
  589365
  621344
  759629
  775607
  784740
  799472
  807681
  808000
]
21.67 ms
(12.67%)
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
  385342
  193883
  206386
  191139
  392097
  51635
  97156
  387012
  386879
  387334
  396265
  402980
  408546
  409941
  411904
  413731
  424268
  452240
  457019
  469408
  468284
  488775
  457739
  491214
  513582
  468357
  478976
  565880
  542915
  545628
  550360
  556901
  572630
  589365
  621344
  799472
  775607
  808000
  807681
  759629
  784740
  10934
  311235
  411720
  419062
  433684
  459647
  12731
  45306
  92019
  163536
  390166
  396331
  400492
  403153
  448338
  58201
  397872
  434072
  457631
  460850
  465899
  446042
  446783
  457736
  470007
  476086
  527697
  499893
  521200
  525749
  496803
  541626
  498125
  505089
  507389
  397807
  385759
  382739
  385088
  137159
  213627
  391729
  304679
  382233
  69631
  73421
  91379
  388862
  389257
  389355
  397769
  400042
  402030
  402618
  402941
  429584
  407684
  427544
  410745
  440068
  477576
  448218
  451043
  452830
  454400
  459204
  465685
  471850
  472682
  479127
  452253
  456245
  464362
  466888
  474486
  514116
  495336
  498838
  465019
]
3.02 ms
(1.77%)
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
  10934
  12731
  45306
  51635
  58201
  69631
  73421
  91379
  92019
  97156
  137159
  163536
  191139
  193883
  206386
  213627
  304679
  311235
  382233
  382739
  385088
  385342
  385759
  386879
  387012
  387334
  388862
  389257
  389355
  390166
  391729
  392097
  396265
  396331
  397769
  397807
  397872
  400042
  400492
  402030
  402618
  402941
  402980
  403153
  407684
  408546
  409941
  410745
  411720
  411904
  413731
  419062
  424268
  427544
  429584
  433684
  434072
  440068
  446042
  446783
  448218
  448338
  451043
  452240
  452253
  452830
  454400
  456245
  457019
  457631
  457736
  457739
  459204
  459647
  460850
  464362
  465019
  465685
  465899
  466888
  468284
  468357
  469408
  470007
  471850
  472682
  474486
  476086
  477576
  478976
  479127
  488775
  491214
  495336
  496803
  498125
  498838
  499893
  505089
  507389
  513582
  514116
  521200
  525749
  527697
  541626
  542915
  545628
  550360
  556901
  565880
  572630
  589365
  621344
  759629
  775607
  784740
  799472
  807681
  808000
]
2.29 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "дам порно"
]
1.90 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дам порн"
]
1.43 ms
(0.83%)
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.