Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.79 ms
(88.21%)
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
  522877
  522917
  541366
  541592
  541634
  541635
  541636
  541656
  541690
  541698
  541699
  541738
  541806
  541822
  541828
  541830
  541872
  541885
  541889
  541895
  542190
  542198
  543471
  543475
  544281
  544478
  544627
  551225
  551919
  556785
  559127
  560387
  561028
  562823
  562826
  562832
  562837
  563450
  563536
  565351
  566502
  566503
  567424
  571028
  571240
  571434
  572544
  573764
  573765
  573914
  574258
  576623
  576628
  576629
  576630
  576634
  576673
  576689
  576690
  576691
  576696
  576704
  576706
  576720
  577349
  577360
  577368
  577384
  579345
  580256
  581349
  581383
  582179
  583533
  583897
  584712
  587833
  593441
  598407
  600316
  600837
  603247
  605338
  605345
  607707
  615735
  615746
  619405
  619483
  620150
  622331
  622381
  622953
  622976
  622978
  622979
  624155
  628314
  634746
  641370
  643731
  644324
  649106
  649196
  652223
  652541
  652544
  662137
  663546
  670955
  672122
  689702
  690803
  699397
  699574
  702061
  703519
  709748
  724135
  727812
]
17.02 ms
(7.19%)
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
  567424
  562826
  622953
  622978
  624155
  542190
  670955
  576690
  541895
  577384
  652541
  562837
  572544
  622976
  598407
  615735
  576689
  703519
  577360
  541889
  522877
  576628
  541636
  571240
  641370
  622381
  542198
  690803
  628314
  620150
  634746
  615746
  580256
  724135
  649196
  672122
  644324
  559127
  727812
  709748
  652223
  576634
  649106
  543475
  522917
  577349
  581383
  573764
  573914
  605345
  593441
  566502
  571434
  541872
  560387
  702061
  573765
  566503
  543471
  576630
  576706
  622331
  576673
  583897
  619405
  541822
  643731
  562823
  576704
  571028
  605338
  576691
  541828
  603247
  541698
  544627
  579345
  541366
  622979
  541699
  541806
  563450
  582179
  652544
  541656
  619483
  556785
  563536
  541634
  551225
  544281
  607707
  663546
  541738
  689702
  551919
  562832
  576720
  583533
  561028
  541690
  600316
  699397
  576623
  541635
  581349
  544478
  576696
  699574
  600837
  541592
  565351
  577368
  662137
  584712
  587833
  541830
  576629
  574258
  541885
]
3.42 ms
(1.44%)
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
  522877
  522917
  541366
  541592
  541634
  541635
  541636
  541656
  541690
  541698
  541699
  541738
  541806
  541822
  541828
  541830
  541872
  541885
  541889
  541895
  542190
  542198
  543471
  543475
  544281
  544478
  544627
  551225
  551919
  556785
  559127
  560387
  561028
  562823
  562826
  562832
  562837
  563450
  563536
  565351
  566502
  566503
  567424
  571028
  571240
  571434
  572544
  573764
  573765
  573914
  574258
  576623
  576628
  576629
  576630
  576634
  576673
  576689
  576690
  576691
  576696
  576704
  576706
  576720
  577349
  577360
  577368
  577384
  579345
  580256
  581349
  581383
  582179
  583533
  583897
  584712
  587833
  593441
  598407
  600316
  600837
  603247
  605338
  605345
  607707
  615735
  615746
  619405
  619483
  620150
  622331
  622381
  622953
  622976
  622978
  622979
  624155
  628314
  634746
  641370
  643731
  644324
  649106
  649196
  652223
  652541
  652544
  662137
  663546
  670955
  672122
  689702
  690803
  699397
  699574
  702061
  703519
  709748
  724135
  727812
]
2.29 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "retro anal sex"
]
1.78 ms
(0.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ретр анал секс"
]
1.73 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "ретр анал секс"
]
1.66 ms
(0.70%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.