Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.36 ms
(86.73%)
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
  388792
  390573
  398394
  407414
  415811
  417095
  425861
  426658
  437157
  439530
  440779
  440954
  460373
  464152
  465068
  468039
  473404
  478148
  478740
  484003
  485049
  488639
  492005
  492462
  493426
  498811
  507771
  509594
  510413
  511328
  512626
  512836
  513975
  514214
  515008
  516859
  517301
  518643
  519591
  520437
  520769
  521589
  521792
  525082
  525924
  528118
  528123
  528562
  533278
  540814
  541068
  547576
  550517
  552355
  552623
  552955
  555168
  555377
  555390
  555468
  556006
  561506
  563634
  567985
  568594
  569632
  571130
  575854
  577439
  581896
  583470
  583732
  586219
  587749
  588649
  591174
  592331
  592587
  595176
  596694
  598227
  598915
  605200
  607518
  610266
  615919
  616778
  616793
  618460
  622366
  624990
  630292
  635678
  635973
  640152
  646786
  656158
  672240
  689007
  707617
  712094
  724304
  728229
  728957
  756421
  761722
  767968
  768031
  768032
  769299
  769531
  785849
  788304
  791209
  800189
  804534
  806793
  807577
  808239
]
13.31 ms
(7.94%)
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
  484003
  541068
  550517
  568594
  555390
  575854
  689007
  588649
  616793
  610266
  592331
  592587
  587749
  804534
  788304
  807577
  724304
  769299
  808239
  767968
  768031
  769531
  761722
  768032
  785849
  800189
  437157
  465068
  478740
  478148
  512626
  509594
  515008
  492005
  728957
  388792
  398394
  540814
  492462
  498811
  513975
  520437
  533278
  555377
  581896
  583732
  569632
  672240
  583470
  598227
  605200
  596694
  615919
  630292
  728229
  622366
  635973
  707617
  440779
  390573
  426658
  520769
  586219
  555168
  425861
  440954
  417095
  555468
  511328
  528123
  528562
  525924
  528118
  473404
  561506
  567985
  571130
  712094
  656158
  640152
  595176
  624990
  791209
  756421
  806793
  415811
  516859
  556006
  407414
  464152
  518643
  521589
  460373
  547576
  552955
  552355
  577439
  635678
  618460
  521792
  468039
  512836
  510413
  514214
  607518
  616778
  591174
  439530
  485049
  488639
  493426
  507771
  519591
  525082
  646786
  598915
  517301
  563634
  552623
]
2.29 ms
(1.36%)
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
  388792
  390573
  398394
  407414
  415811
  417095
  425861
  426658
  437157
  439530
  440779
  440954
  460373
  464152
  465068
  468039
  473404
  478148
  478740
  484003
  485049
  488639
  492005
  492462
  493426
  498811
  507771
  509594
  510413
  511328
  512626
  512836
  513975
  514214
  515008
  516859
  517301
  518643
  519591
  520437
  520769
  521589
  521792
  525082
  525924
  528118
  528123
  528562
  533278
  540814
  541068
  547576
  550517
  552355
  552623
  552955
  555168
  555377
  555390
  555468
  556006
  561506
  563634
  567985
  568594
  569632
  571130
  575854
  577439
  581896
  583470
  583732
  586219
  587749
  588649
  591174
  592331
  592587
  595176
  596694
  598227
  598915
  605200
  607518
  610266
  615919
  616778
  616793
  618460
  622366
  624990
  630292
  635678
  635973
  640152
  646786
  656158
  672240
  689007
  707617
  712094
  724304
  728229
  728957
  756421
  761722
  767968
  768031
  768032
  769299
  769531
  785849
  788304
  791209
  800189
  804534
  806793
  807577
  808239
]
1.89 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "riding creampie milf"
]
1.65 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "riding creampie milf"
]
1.64 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "riding creampie milf"
]

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.