Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
182.26 ms
(87.21%)
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
  91344
  102086
  117844
  121555
  160126
  182285
  233353
  288045
  382278
  382821
  386023
  387281
  388150
  391493
  392906
  394598
  395472
  397529
  398074
  398384
  400672
  404470
  405143
  406881
  409310
  409680
  411025
  413391
  415561
  421093
  422335
  428223
  428231
  428956
  441834
  451337
  455004
  467601
  469080
  476142
  480470
  484457
  491368
  493715
  498449
  504144
  505094
  508292
  510024
  513846
  514854
  523201
  529621
  529626
  531336
  531787
  532741
  532826
  532847
  533544
  534560
  534567
  538879
  539023
  539239
  545428
  545457
  547058
  547499
  550917
  564387
  568264
  576439
  630798
  633744
  636958
  639731
  641562
  651132
  656826
  662026
  669386
  672913
  699397
  722378
  722380
  734417
  751437
  752612
  753614
  755925
  765260
  766591
  783425
  787514
  788107
  788567
  789529
  789964
  794977
  799697
  801975
  809165
  816167
  816650
  817011
  817157
  817300
  817754
  819545
  819606
  822969
  824148
  824247
  827827
  827828
  827837
  827851
  827875
  827949
]
16.60 ms
(7.94%)
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
  734417
  182285
  391493
  469080
  387281
  395472
  398074
  816167
  508292
  531787
  547499
  550917
  630798
  400672
  827828
  827851
  493715
  498449
  576439
  722378
  656826
  672913
  751437
  766591
  809165
  636958
  523201
  824247
  827949
  405143
  819545
  421093
  160126
  765260
  441834
  476142
  455004
  233353
  564387
  669386
  722380
  102086
  788567
  411025
  532741
  639731
  752612
  817157
  819606
  827827
  817011
  510024
  533544
  755925
  406881
  788107
  539239
  534567
  545428
  121555
  633744
  409310
  491368
  394598
  415561
  816650
  817300
  817754
  641562
  794977
  799697
  398384
  404470
  484457
  532847
  382278
  789529
  386023
  428223
  480470
  532826
  568264
  513846
  545457
  91344
  413391
  824148
  827875
  539023
  529621
  783425
  699397
  382821
  428231
  451337
  422335
  467601
  514854
  534560
  538879
  662026
  753614
  547058
  505094
  801975
  117844
  288045
  428956
  409680
  531336
  787514
  789964
  504144
  392906
  388150
  397529
  822969
  827837
  529626
  651132
]
2.65 ms
(1.27%)
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
  91344
  102086
  117844
  121555
  160126
  182285
  233353
  288045
  382278
  382821
  386023
  387281
  388150
  391493
  392906
  394598
  395472
  397529
  398074
  398384
  400672
  404470
  405143
  406881
  409310
  409680
  411025
  413391
  415561
  421093
  422335
  428223
  428231
  428956
  441834
  451337
  455004
  467601
  469080
  476142
  480470
  484457
  491368
  493715
  498449
  504144
  505094
  508292
  510024
  513846
  514854
  523201
  529621
  529626
  531336
  531787
  532741
  532826
  532847
  533544
  534560
  534567
  538879
  539023
  539239
  545428
  545457
  547058
  547499
  550917
  564387
  568264
  576439
  630798
  633744
  636958
  639731
  641562
  651132
  656826
  662026
  669386
  672913
  699397
  722378
  722380
  734417
  751437
  752612
  753614
  755925
  765260
  766591
  783425
  787514
  788107
  788567
  789529
  789964
  794977
  799697
  801975
  809165
  816167
  816650
  817011
  817157
  817300
  817754
  819545
  819606
  822969
  824148
  824247
  827827
  827828
  827837
  827851
  827875
  827949
]
2.00 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "extreme ass sex"
]
1.90 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "хардкор жоп секс"
]
1.88 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.