Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.70 ms
(87.70%)
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
  387230
  402238
  406293
  434431
  449758
  466677
  468657
  470420
  482151
  494870
  500701
  503511
  504368
  505176
  505320
  505550
  506495
  509400
  509565
  509633
  512671
  514281
  515070
  515099
  518303
  518954
  519847
  519967
  519983
  522370
  522602
  522875
  523136
  523143
  523495
  524086
  524894
  525009
  525153
  526338
  526407
  526682
  527372
  527383
  528533
  533336
  534800
  535532
  535575
  536989
  540745
  542457
  544562
  549518
  552846
  553227
  554847
  555899
  555958
  556552
  558872
  559985
  560077
  561521
  561616
  561878
  562751
  564788
  567019
  567254
  568443
  570089
  571288
  572211
  572242
  572718
  572742
  576647
  579425
  581744
  581854
  581868
  583240
  583817
  583884
  584448
  585124
  585170
  585767
  585787
  588477
  588977
  589710
  591328
  594992
  598775
  598980
  599781
  600186
  600292
  602104
  603211
  603842
  605688
  606817
  612614
  613993
  616765
  617997
  618572
  619312
  620041
  625008
  634246
  644847
  666331
  670432
  672251
  682866
  686207
]
11.83 ms
(6.70%)
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
  555958
  558872
  562751
  571288
  581854
  583884
  559985
  560077
  570089
  581868
  544562
  572718
  572742
  584448
  666331
  670432
  672251
  564788
  567019
  567254
  576647
  598775
  599781
  588977
  591328
  618572
  620041
  585170
  600292
  603211
  617997
  619312
  402238
  434431
  523136
  585124
  505320
  540745
  572242
  589710
  518954
  524894
  542457
  561878
  549518
  561616
  588477
  644847
  505550
  503511
  528533
  526338
  572211
  581744
  583817
  568443
  579425
  553227
  554847
  686207
  682866
  552846
  555899
  556552
  561521
  583240
  585767
  585787
  600186
  594992
  598980
  603842
  605688
  612614
  616765
  606817
  625008
  602104
  613993
  634246
  387230
  406293
  466677
  468657
  449758
  470420
  482151
  509633
  519847
  522602
  527372
  533336
  535532
  536989
  500701
  515070
  518303
  519967
  522370
  522875
  523143
  526682
  505176
  506495
  509400
  509565
  512671
  514281
  515099
  525009
  525153
  526407
  534800
  494870
  504368
  519983
  523495
  524086
  527383
  535575
]
2.95 ms
(1.67%)
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
  387230
  402238
  406293
  434431
  449758
  466677
  468657
  470420
  482151
  494870
  500701
  503511
  504368
  505176
  505320
  505550
  506495
  509400
  509565
  509633
  512671
  514281
  515070
  515099
  518303
  518954
  519847
  519967
  519983
  522370
  522602
  522875
  523136
  523143
  523495
  524086
  524894
  525009
  525153
  526338
  526407
  526682
  527372
  527383
  528533
  533336
  534800
  535532
  535575
  536989
  540745
  542457
  544562
  549518
  552846
  553227
  554847
  555899
  555958
  556552
  558872
  559985
  560077
  561521
  561616
  561878
  562751
  564788
  567019
  567254
  568443
  570089
  571288
  572211
  572242
  572718
  572742
  576647
  579425
  581744
  581854
  581868
  583240
  583817
  583884
  584448
  585124
  585170
  585767
  585787
  588477
  588977
  589710
  591328
  594992
  598775
  598980
  599781
  600186
  600292
  602104
  603211
  603842
  605688
  606817
  612614
  613993
  616765
  617997
  618572
  619312
  620041
  625008
  634246
  644847
  666331
  670432
  672251
  682866
  686207
]
1.93 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "заглотила сперму"
]
1.86 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "заглот сперм"
]
1.44 ms
(0.82%)
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.