Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.84 ms
(85.39%)
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
  3786
  21255
  271767
  305548
  395388
  419308
  422131
  423515
  425994
  431528
  432694
  438055
  442524
  442618
  444639
  448039
  448247
  449262
  452406
  457787
  458948
  461636
  462680
  466907
  468029
  475213
  478518
  479693
  485671
  494272
  496841
  499552
  499874
  510923
  517377
  522645
  523397
  524128
  526972
  528750
  529458
  530138
  537227
  557440
  570857
  576771
  585457
  588148
  589866
  595627
  598139
  600726
  607996
  608318
  614787
  614843
  627766
  628669
  629387
  629602
  629912
  632747
  634100
  655767
  662062
  673877
  680373
  683143
  691166
  694142
  699494
  710877
  718314
  720581
  724671
  727491
  728903
  730507
  730509
  732589
  733325
  738364
  739719
  740229
  743422
  745981
  747248
  750588
  755534
  756431
  756618
  757128
  757234
  757543
  758307
  762330
  783939
  785568
  787860
  793500
  794680
  797392
  799964
  799987
  803960
  804640
  805258
  807846
  807855
  808257
  809607
  813189
  817381
  819704
  819720
  819722
  820213
  824018
  825454
  825685
]
15.51 ms
(9.08%)
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
  529458
  530138
  494272
  523397
  499874
  496841
  510923
  537227
  479693
  485671
  557440
  570857
  576771
  680373
  699494
  655767
  662062
  673877
  683143
  691166
  694142
  585457
  629912
  589866
  598139
  600726
  629602
  632747
  634100
  628669
  588148
  607996
  608318
  614787
  614843
  627766
  629387
  785568
  793500
  799987
  805258
  804640
  724671
  727491
  743422
  747248
  757234
  762330
  783939
  794680
  799964
  803960
  808257
  728903
  730507
  732589
  733325
  755534
  756618
  738364
  745981
  757128
  739719
  740229
  757543
  730509
  756431
  758307
  710877
  787860
  797392
  807846
  807855
  813189
  423515
  442618
  452406
  461636
  468029
  475213
  448247
  457787
  438055
  449262
  478518
  526972
  499552
  517377
  524128
  528750
  305548
  444639
  442524
  466907
  522645
  425994
  395388
  3786
  817381
  819720
  819722
  824018
  819704
  820213
  825454
  825685
  448039
  462680
  718314
  720581
  809607
  750588
  431528
  458948
  271767
  21255
  422131
  432694
  419308
  595627
]
3.54 ms
(2.07%)
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
  3786
  21255
  271767
  305548
  395388
  419308
  422131
  423515
  425994
  431528
  432694
  438055
  442524
  442618
  444639
  448039
  448247
  449262
  452406
  457787
  458948
  461636
  462680
  466907
  468029
  475213
  478518
  479693
  485671
  494272
  496841
  499552
  499874
  510923
  517377
  522645
  523397
  524128
  526972
  528750
  529458
  530138
  537227
  557440
  570857
  576771
  585457
  588148
  589866
  595627
  598139
  600726
  607996
  608318
  614787
  614843
  627766
  628669
  629387
  629602
  629912
  632747
  634100
  655767
  662062
  673877
  680373
  683143
  691166
  694142
  699494
  710877
  718314
  720581
  724671
  727491
  728903
  730507
  730509
  732589
  733325
  738364
  739719
  740229
  743422
  745981
  747248
  750588
  755534
  756431
  756618
  757128
  757234
  757543
  758307
  762330
  783939
  785568
  787860
  793500
  794680
  797392
  799964
  799987
  803960
  804640
  805258
  807846
  807855
  808257
  809607
  813189
  817381
  819704
  819720
  819722
  820213
  824018
  825454
  825685
]
1.84 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "compilation wife"
]
1.48 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "подборк жен"
]
1.34 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "подборк жен"
]
1.24 ms
(0.73%)
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.