Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
177.67 ms
(87.56%)
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
  382304
  382743
  387661
  388110
  392107
  401374
  408885
  408928
  415863
  415876
  418827
  423763
  429861
  446447
  448059
  448263
  454814
  457476
  465125
  465334
  465691
  467112
  468146
  471074
  471105
  471127
  472606
  472815
  476664
  477021
  477052
  483735
  483738
  495206
  499921
  511278
  511856
  513220
  514155
  515531
  526653
  529599
  536182
  537138
  538045
  540746
  550857
  550952
  551646
  555004
  557333
  559810
  564518
  567063
  569258
  571726
  574391
  575956
  580069
  581759
  583694
  589166
  591884
  600907
  602897
  604870
  607487
  607686
  613780
  615921
  616117
  620231
  620323
  622025
  648733
  653028
  660412
  666682
  669035
  669056
  671018
  671045
  672939
  686106
  686130
  695868
  697457
  713503
  713506
  718785
  739125
  750568
  751706
  760689
  768450
  772617
  782334
  782554
  800530
  802071
  803126
  803268
  803534
  803770
  805291
  807160
  807590
  807597
  807642
  811913
  812374
  812409
  813793
  819256
  821359
  821964
  822969
  826507
  827290
]
14.16 ms
(6.98%)
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
  467112
  471127
  483738
  622025
  805291
  613780
  388110
  387661
  821964
  559810
  575956
  800530
  807642
  418827
  807597
  772617
  620231
  571726
  429861
  468146
  826507
  471074
  564310
  672939
  686130
  695868
  660412
  669056
  669035
  671018
  671045
  686106
  807590
  739125
  446447
  827290
  476664
  472815
  538045
  550952
  557333
  602897
  423763
  382304
  415876
  457476
  536182
  564518
  574391
  580069
  803534
  465125
  526653
  514155
  511856
  567063
  415863
  499921
  465334
  472606
  819256
  495206
  581759
  448263
  750568
  803126
  529599
  713503
  713506
  550857
  616117
  607487
  811913
  751706
  768450
  803770
  511278
  569258
  515531
  653028
  666682
  555004
  803268
  782554
  812374
  812409
  408885
  513220
  648733
  718785
  589166
  620323
  615921
  408928
  813793
  802071
  448059
  454814
  401374
  604870
  382743
  392107
  477021
  483735
  477052
  465691
  540746
  537138
  583694
  551646
  591884
  607686
  600907
  471105
  697457
  821359
  822969
  807160
  760689
  782334
]
3.41 ms
(1.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big milf dildo"
]
3.15 ms
(1.55%)
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
  382304
  382743
  387661
  388110
  392107
  401374
  408885
  408928
  415863
  415876
  418827
  423763
  429861
  446447
  448059
  448263
  454814
  457476
  465125
  465334
  465691
  467112
  468146
  471074
  471105
  471127
  472606
  472815
  476664
  477021
  477052
  483735
  483738
  495206
  499921
  511278
  511856
  513220
  514155
  515531
  526653
  529599
  536182
  537138
  538045
  540746
  550857
  550952
  551646
  555004
  557333
  559810
  564518
  567063
  569258
  571726
  574391
  575956
  580069
  581759
  583694
  589166
  591884
  600907
  602897
  604870
  607487
  607686
  613780
  615921
  616117
  620231
  620323
  622025
  648733
  653028
  660412
  666682
  669035
  669056
  671018
  671045
  672939
  686106
  686130
  695868
  697457
  713503
  713506
  718785
  739125
  750568
  751706
  760689
  768450
  772617
  782334
  782554
  800530
  802071
  803126
  803268
  803534
  803770
  805291
  807160
  807590
  807597
  807642
  811913
  812374
  812409
  813793
  819256
  821359
  821964
  822969
  826507
  827290
]
1.74 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.73%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие milf дилд"
]
1.28 ms
(0.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие milf дилд"
]

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.