Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.11 ms
(86.32%)
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
  97156
  150261
  150405
  184359
  219172
  338098
  381811
  386853
  393239
  398753
  398995
  403162
  403938
  454456
  467793
  470924
  477633
  479067
  490160
  532681
  533527
  535402
  536063
  536202
  542513
  543925
  545090
  549527
  554876
  562588
  566412
  566418
  566583
  567462
  572219
  578739
  579569
  584605
  587629
  588019
  589141
  603600
  603646
  603658
  605410
  619275
  622090
  622183
  630712
  630818
  633832
  635636
  635780
  635788
  636510
  645046
  645050
  649627
  651423
  652122
  653154
  653384
  653603
  653615
  653880
  653907
  654261
  654274
  654292
  654689
  654695
  660084
  661536
  661954
  664729
  672281
  674515
  679415
  690049
  692463
  692845
  693794
  696167
  696982
  696986
  699428
  705322
  707970
  712634
  713444
  714404
  714548
  716378
  716564
  718964
  719726
  720208
  724329
  725166
  729220
  730753
  732792
  732793
  732838
  733024
  733074
  733577
  734098
  734388
  734413
  739956
  744509
  748436
  749548
  759669
  759760
  760534
  762268
  762269
  787691
]
15.18 ms
(8.39%)
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
  403162
  690049
  490160
  543925
  672281
  645046
  716378
  725166
  744509
  733074
  635636
  393239
  542513
  562588
  566583
  718964
  588019
  734388
  762268
  733577
  734098
  692463
  467793
  454456
  97156
  545090
  654695
  579569
  338098
  398753
  479067
  549527
  699428
  398995
  567462
  572219
  705322
  714548
  587629
  605410
  734413
  732792
  748436
  184359
  381811
  536063
  532681
  660084
  719726
  679415
  716564
  720208
  630818
  749548
  762269
  732838
  713444
  403938
  470924
  654689
  661954
  696982
  578739
  603600
  622183
  633832
  696986
  645050
  693794
  654261
  150261
  536202
  654292
  535402
  533527
  566412
  566418
  712634
  622090
  636510
  730753
  732793
  724329
  729220
  733024
  760534
  787691
  739956
  619275
  589141
  759760
  759669
  219172
  584605
  477633
  653384
  664729
  654274
  661536
  674515
  150405
  386853
  554876
  651423
  652122
  707970
  714404
  649627
  653154
  692845
  653603
  653615
  653880
  653907
  696167
  603646
  603658
  630712
  635780
  635788
]
2.69 ms
(1.49%)
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
  97156
  150261
  150405
  184359
  219172
  338098
  381811
  386853
  393239
  398753
  398995
  403162
  403938
  454456
  467793
  470924
  477633
  479067
  490160
  532681
  533527
  535402
  536063
  536202
  542513
  543925
  545090
  549527
  554876
  562588
  566412
  566418
  566583
  567462
  572219
  578739
  579569
  584605
  587629
  588019
  589141
  603600
  603646
  603658
  605410
  619275
  622090
  622183
  630712
  630818
  633832
  635636
  635780
  635788
  636510
  645046
  645050
  649627
  651423
  652122
  653154
  653384
  653603
  653615
  653880
  653907
  654261
  654274
  654292
  654689
  654695
  660084
  661536
  661954
  664729
  672281
  674515
  679415
  690049
  692463
  692845
  693794
  696167
  696982
  696986
  699428
  705322
  707970
  712634
  713444
  714404
  714548
  716378
  716564
  718964
  719726
  720208
  724329
  725166
  729220
  730753
  732792
  732793
  732838
  733024
  733074
  733577
  734098
  734388
  734413
  739956
  744509
  748436
  749548
  759669
  759760
  760534
  762268
  762269
  787691
]
2.08 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "swinger wife amateur"
]
1.69 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "свингер жен любительск"
]
1.59 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "свингер жен любительск"
]
1.52 ms
(0.84%)
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.