Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.02 ms
(90.46%)
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
  385470
  392068
  397660
  416887
  423586
  437707
  437742
  440721
  444984
  451090
  455177
  457328
  458180
  460032
  460475
  460491
  460683
  471533
  483075
  488475
  489155
  492964
  505924
  515381
  522435
  524816
  525443
  527150
  527771
  531454
  531913
  536907
  540758
  545058
  546078
  547711
  553705
  556635
  557836
  577586
  578766
  580748
  583363
  586560
  589713
  591961
  592416
  594627
  595633
  602496
  602564
  604688
  610163
  610485
  610997
  614409
  618289
  621528
  621792
  628625
  631863
  634952
  638386
  638404
  638441
  639687
  649862
  664240
  666044
  666068
  666403
  666414
  668547
  676612
  676649
  683010
  689139
  690278
  696340
  697430
  700731
  705152
  707233
  708643
  709350
  709519
  710966
  716795
  718881
  720951
  723783
  724916
  727000
  733314
  738247
  743638
  751517
  751667
  753192
  755329
  764000
  764009
  771305
  772332
  772336
  782335
  782387
  784992
  789402
  793701
  794433
  796291
  801078
  801686
  809309
  812670
  813214
  813683
  814091
  823682
]
12.96 ms
(5.55%)
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
  416887
  814091
  813683
  666414
  772332
  782335
  794433
  782387
  813214
  440721
  700731
  705152
  536907
  460475
  649862
  666403
  709519
  716795
  628625
  621528
  738247
  743638
  751667
  771305
  697430
  460683
  553705
  583363
  690278
  666068
  683010
  689139
  696340
  594627
  591961
  602496
  610485
  610997
  618289
  589713
  638404
  531454
  557836
  577586
  444984
  423586
  457328
  489155
  488475
  720951
  796291
  809309
  764009
  724916
  801686
  437742
  437707
  483075
  527771
  631863
  638441
  789402
  772336
  793701
  801078
  733314
  755329
  524816
  525443
  540758
  547711
  676649
  638386
  586560
  595633
  602564
  634952
  592416
  604688
  527150
  515381
  708643
  392068
  451090
  460032
  505924
  522435
  578766
  707233
  668547
  614409
  610163
  723783
  764000
  751517
  812670
  385470
  397660
  727000
  823682
  455177
  460491
  471533
  546078
  556635
  580748
  718881
  676612
  664240
  621792
  639687
  784992
  753192
  709350
  710966
  458180
  531913
  492964
  545058
  666044
]
2.69 ms
(1.15%)
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
  385470
  392068
  397660
  416887
  423586
  437707
  437742
  440721
  444984
  451090
  455177
  457328
  458180
  460032
  460475
  460491
  460683
  471533
  483075
  488475
  489155
  492964
  505924
  515381
  522435
  524816
  525443
  527150
  527771
  531454
  531913
  536907
  540758
  545058
  546078
  547711
  553705
  556635
  557836
  577586
  578766
  580748
  583363
  586560
  589713
  591961
  592416
  594627
  595633
  602496
  602564
  604688
  610163
  610485
  610997
  614409
  618289
  621528
  621792
  628625
  631863
  634952
  638386
  638404
  638441
  639687
  649862
  664240
  666044
  666068
  666403
  666414
  668547
  676612
  676649
  683010
  689139
  690278
  696340
  697430
  700731
  705152
  707233
  708643
  709350
  709519
  710966
  716795
  718881
  720951
  723783
  724916
  727000
  733314
  738247
  743638
  751517
  751667
  753192
  755329
  764000
  764009
  771305
  772332
  772336
  782335
  782387
  784992
  789402
  793701
  794433
  796291
  801078
  801686
  809309
  812670
  813214
  813683
  814091
  823682
]
2.05 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur condom"
]
1.59 ms
(0.68%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.68%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск condom"
]
1.40 ms
(0.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск condom"
]

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.