Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.75 ms
(83.41%)
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
  495384
  496713
  501657
  511416
  526990
  529895
  531052
  531666
  531842
  531984
  532116
  534692
  537722
  537874
  539552
  540558
  541160
  541200
  543485
  543934
  544302
  544970
  547297
  547323
  547331
  547341
  549282
  549385
  549960
  549967
  549973
  550007
  550149
  550384
  551710
  557444
  558110
  561559
  561575
  563908
  564264
  566682
  567981
  568241
  568242
  570774
  570802
  570829
  571184
  572570
  574077
  574180
  574210
  574249
  577257
  579912
  580900
  581621
  592741
  593204
  596853
  596878
  597209
  598274
  598390
  603311
  603348
  603733
  604867
  605166
  618377
  621026
  624532
  626563
  629796
  630281
  638278
  639683
  640393
  643111
  644357
  646865
  648470
  651163
  687127
  710350
  710585
  712617
  714384
  720528
  727384
  774773
  775341
  776780
  776849
  782119
  787634
  790731
  801887
  802567
  803025
  804770
  806837
  807395
  811315
  811336
  813451
  813804
  814602
  817091
  817097
  819233
  819247
  819249
  819250
  819766
  819803
  820847
  827400
  827460
]
13.53 ms
(9.43%)
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
  511416
  541200
  550149
  551710
  549385
  564264
  544302
  561575
  570774
  581621
  648470
  651163
  549973
  605166
  603348
  621026
  817097
  819250
  820847
  817091
  819233
  819247
  819803
  827460
  827400
  819249
  813804
  814602
  819766
  496713
  534692
  537874
  495384
  531052
  531666
  531842
  532116
  537722
  539552
  540558
  501657
  529895
  531984
  526990
  543485
  547323
  547331
  547341
  549282
  549960
  550007
  557444
  566682
  568241
  574180
  577257
  543934
  570829
  574077
  579912
  580900
  541160
  544970
  547297
  550384
  558110
  567981
  568242
  646865
  687127
  710585
  714384
  710350
  712617
  720528
  549967
  561559
  563908
  570802
  571184
  572570
  574210
  574249
  596878
  597209
  604867
  639683
  596853
  598390
  638278
  592741
  598274
  603733
  624532
  626563
  629796
  630281
  640393
  643111
  593204
  603311
  618377
  644357
  774773
  775341
  782119
  790731
  802567
  806837
  811315
  813451
  776780
  776849
  787634
  801887
  803025
  804770
  807395
  811336
  727384
]
2.89 ms
(2.01%)
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
  495384
  496713
  501657
  511416
  526990
  529895
  531052
  531666
  531842
  531984
  532116
  534692
  537722
  537874
  539552
  540558
  541160
  541200
  543485
  543934
  544302
  544970
  547297
  547323
  547331
  547341
  549282
  549385
  549960
  549967
  549973
  550007
  550149
  550384
  551710
  557444
  558110
  561559
  561575
  563908
  564264
  566682
  567981
  568241
  568242
  570774
  570802
  570829
  571184
  572570
  574077
  574180
  574210
  574249
  577257
  579912
  580900
  581621
  592741
  593204
  596853
  596878
  597209
  598274
  598390
  603311
  603348
  603733
  604867
  605166
  618377
  621026
  624532
  626563
  629796
  630281
  638278
  639683
  640393
  643111
  644357
  646865
  648470
  651163
  687127
  710350
  710585
  712617
  714384
  720528
  727384
  774773
  775341
  776780
  776849
  782119
  787634
  790731
  801887
  802567
  803025
  804770
  806837
  807395
  811315
  811336
  813451
  813804
  814602
  817091
  817097
  819233
  819247
  819249
  819250
  819766
  819803
  820847
  827400
  827460
]
2.46 ms
(1.71%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "эротик mom"
]
1.66 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "эротик mom"
]
1.51 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "erotic mom"
]

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.