Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.29 ms
(82.57%)
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
  35405
  61498
  92019
  278472
  346082
  385851
  387874
  394521
  397658
  407504
  409008
  421653
  426897
  427062
  449084
  475727
  488576
  524401
  528791
  530666
  533553
  533591
  535552
  545114
  557561
  562502
  564576
  565200
  569220
  570701
  582729
  587908
  590447
  603119
  604682
  607690
  608783
  612245
  615075
  622849
  623276
  630071
  631999
  642639
  644253
  646066
  658772
  665277
  665658
  670404
  677951
  693210
  705396
  714531
  714690
  717105
  717156
  717649
  718551
  722195
  722880
  723941
  728048
  740917
  750030
  753565
  753645
  753651
  753690
  754490
  755908
  758056
  758331
  759938
  761161
  762827
  764242
  766508
  770022
  773852
  773984
  774218
  774640
  775111
  776029
  776188
  778283
  779376
  780242
  781982
  783242
  784137
  784659
  785412
  785521
  787230
  788244
  789604
  795211
  796712
  798823
  799487
  802634
  804847
  805267
  806159
  811075
  812306
  812359
  812712
  815518
  816606
  817203
  817785
  818096
  818197
  821089
  821492
  821574
]
15.59 ms
(10.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
  821492
  818096
  818197
  821089
  821574
  533553
  524401
  533591
  475727
  488576
  564576
  565200
  717105
  665277
  717649
  722880
  714690
  722195
  582729
  608783
  644253
  603119
  612245
  622849
  623276
  642639
  587908
  776188
  789604
  774640
  776029
  783242
  785521
  799487
  812712
  723941
  753565
  753690
  758056
  759938
  766508
  772838
  774218
  753645
  761161
  762827
  773852
  740917
  750030
  773984
  615075
  630071
  631999
  705396
  775111
  781982
  785412
  787230
  806159
  528791
  817203
  717156
  658772
  646066
  718551
  778283
  805267
  407504
  385851
  35405
  427062
  397658
  278472
  449084
  562502
  545114
  607690
  784137
  802634
  753651
  758331
  796712
  61498
  409008
  764242
  714531
  779376
  784659
  387874
  816606
  530666
  569220
  670404
  780242
  788244
  755908
  770022
  812359
  604682
  665658
  811075
  426897
  693210
  795211
  92019
  754490
  570701
  557561
  590447
  798823
  804847
  421653
  817785
  815518
  535552
  677951
  812306
  346082
  728048
  394521
]
3.18 ms
(2.08%)
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
  35405
  61498
  92019
  278472
  346082
  385851
  387874
  394521
  397658
  407504
  409008
  421653
  426897
  427062
  449084
  475727
  488576
  524401
  528791
  530666
  533553
  533591
  535552
  545114
  557561
  562502
  564576
  565200
  569220
  570701
  582729
  587908
  590447
  603119
  604682
  607690
  608783
  612245
  615075
  622849
  623276
  630071
  631999
  642639
  644253
  646066
  658772
  665277
  665658
  670404
  677951
  693210
  705396
  714531
  714690
  717105
  717156
  717649
  718551
  722195
  722880
  723941
  728048
  740917
  750030
  753565
  753645
  753651
  753690
  754490
  755908
  758056
  758331
  759938
  761161
  762827
  764242
  766508
  770022
  773852
  773984
  774218
  774640
  775111
  776029
  776188
  778283
  779376
  780242
  781982
  783242
  784137
  784659
  785412
  785521
  787230
  788244
  789604
  795211
  796712
  798823
  799487
  802634
  804847
  805267
  806159
  811075
  812306
  812359
  812712
  815518
  816606
  817203
  817785
  818096
  818197
  821089
  821492
  821574
]
2.19 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big ass babe"
]
2.13 ms
(1.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие жоп babe"
]
1.74 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большая большие жоп babe"
]

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.