Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.24 ms
(86.71%)
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
  468826
  480390
  530724
  530725
  530728
  532262
  532359
  532364
  534227
  534240
  534243
  534245
  534246
  534253
  534255
  534259
  534260
  534262
  534276
  534286
  534289
  534294
  534303
  534310
  534314
  534317
  534319
  534851
  535019
  535020
  535373
  535825
  535828
  535829
  535830
  536332
  536341
  537107
  537117
  550954
  564765
  570730
  577394
  580424
  581596
  586668
  587180
  589116
  595758
  595992
  596193
  604430
  609962
  614032
  615772
  618647
  643072
  643106
  647352
  650343
  650388
  650421
  650425
  650456
  676397
  684173
  693642
  697766
  713569
  713574
  744307
  757362
  759896
  760839
  765232
  771005
  771033
  775800
  775814
  776566
  782629
  786813
  792005
  792633
  792655
  807542
  808461
  808622
  811393
  812911
  814736
  814738
  814741
  814752
  814757
  814777
  814778
  814781
  814800
  814806
  814808
  814818
  814825
  814831
  814841
  814852
  814867
  814871
  814876
  814887
  814888
  814889
  814894
  814908
  814911
  814912
  814914
  814928
  814929
  814932
]
14.53 ms
(7.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
  534310
  532262
  534259
  534227
  535829
  534240
  534243
  534314
  535828
  535830
  570730
  564765
  650388
  713574
  604430
  587180
  614032
  618647
  609962
  643106
  811393
  775800
  765232
  771005
  814736
  814741
  814818
  814781
  814911
  814929
  537117
  532364
  534289
  577394
  713569
  650456
  650425
  595758
  596193
  643072
  615772
  775814
  792655
  792005
  812911
  744307
  771033
  814777
  814757
  814778
  814800
  814867
  814912
  534317
  536332
  647352
  684173
  776566
  808461
  814806
  814831
  814894
  814932
  814752
  814887
  814841
  814852
  814876
  480390
  530725
  534851
  530724
  534245
  534260
  534276
  534319
  535825
  536341
  537107
  530728
  534262
  534286
  534294
  532359
  534253
  534255
  535373
  550954
  650343
  676397
  595992
  586668
  782629
  786813
  759896
  807542
  760839
  757362
  697766
  792633
  808622
  535019
  814888
  814914
  814825
  814871
  814889
  580424
  468826
  534246
  589116
  535020
  814808
  814908
  814738
  814928
  534303
  581596
  693642
  650421
]
2.64 ms
(1.39%)
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
  468826
  480390
  530724
  530725
  530728
  532262
  532359
  532364
  534227
  534240
  534243
  534245
  534246
  534253
  534255
  534259
  534260
  534262
  534276
  534286
  534289
  534294
  534303
  534310
  534314
  534317
  534319
  534851
  535019
  535020
  535373
  535825
  535828
  535829
  535830
  536332
  536341
  537107
  537117
  550954
  564765
  570730
  577394
  580424
  581596
  586668
  587180
  589116
  595758
  595992
  596193
  604430
  609962
  614032
  615772
  618647
  643072
  643106
  647352
  650343
  650388
  650421
  650425
  650456
  676397
  684173
  693642
  697766
  713569
  713574
  744307
  757362
  759896
  760839
  765232
  771005
  771033
  775800
  775814
  776566
  782629
  786813
  792005
  792633
  792655
  807542
  808461
  808622
  811393
  812911
  814736
  814738
  814741
  814752
  814757
  814777
  814778
  814781
  814800
  814806
  814808
  814818
  814825
  814831
  814841
  814852
  814867
  814871
  814876
  814887
  814888
  814889
  814894
  814908
  814911
  814912
  814914
  814928
  814929
  814932
]
2.26 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.20 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "brazzers tits"
]
1.81 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "brazzers сиськ"
]
1.74 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "brazzers сиськ"
]

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.