Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.91 ms
(84.68%)
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
  117890
  395284
  412814
  415859
  416142
  416515
  416611
  416613
  416653
  416675
  416693
  416694
  416708
  416715
  418112
  418989
  419613
  419758
  420174
  424606
  428250
  429608
  429890
  430436
  430581
  432944
  435535
  435539
  440079
  441074
  441078
  441120
  441126
  441131
  441157
  443106
  443198
  444531
  446164
  446695
  447160
  448791
  449024
  451758
  456238
  456239
  461937
  465132
  466633
  466636
  469096
  469217
  469735
  470403
  470479
  477761
  478505
  483736
  485154
  485468
  487418
  487428
  488752
  494493
  496337
  497439
  497691
  498294
  498319
  498544
  500333
  501098
  502287
  510545
  511254
  511274
  513963
  522165
  526504
  526905
  527911
  527922
  529739
  531103
  531403
  531524
  531789
  533897
  534566
  547468
  552800
  555797
  578484
  579517
  597160
  600128
  628362
  632681
  632691
  642065
  660713
  665916
  668645
  669007
  669058
  669362
  671044
  680816
  682478
  686330
  695868
  700975
  713505
  722548
  750121
  788926
  788953
  797738
  806437
  814270
]
13.14 ms
(8.31%)
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
  797738
  412814
  416611
  441078
  441126
  443106
  416142
  416693
  424606
  441157
  420174
  428250
  432944
  416613
  419613
  470479
  465132
  478505
  485154
  502287
  522165
  526504
  497691
  500333
  510545
  461937
  466633
  466636
  469735
  483736
  700975
  680816
  552800
  597160
  416708
  456238
  487428
  529739
  416515
  527922
  416675
  430436
  419758
  418989
  441120
  444531
  470403
  448791
  498544
  531103
  496337
  578484
  547468
  555797
  579517
  668645
  669007
  788953
  788926
  446164
  456239
  498294
  117890
  527911
  531524
  416694
  429608
  429890
  501098
  669058
  632691
  660713
  415859
  416653
  418112
  430581
  441131
  416715
  440079
  469217
  446695
  447160
  494493
  497439
  513963
  487418
  669362
  671044
  750121
  441074
  477761
  488752
  498319
  511254
  395284
  435539
  443198
  435535
  814270
  449024
  485468
  451758
  533897
  511274
  534566
  526905
  531403
  531789
  469096
  695868
  722548
  682478
  686330
  665916
  713505
  600128
  632681
  628362
  642065
  806437
]
3.05 ms
(1.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.55 ms
(1.61%)
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
  117890
  395284
  412814
  415859
  416142
  416515
  416611
  416613
  416653
  416675
  416693
  416694
  416708
  416715
  418112
  418989
  419613
  419758
  420174
  424606
  428250
  429608
  429890
  430436
  430581
  432944
  435535
  435539
  440079
  441074
  441078
  441120
  441126
  441131
  441157
  443106
  443198
  444531
  446164
  446695
  447160
  448791
  449024
  451758
  456238
  456239
  461937
  465132
  466633
  466636
  469096
  469217
  469735
  470403
  470479
  477761
  478505
  483736
  485154
  485468
  487418
  487428
  488752
  494493
  496337
  497439
  497691
  498294
  498319
  498544
  500333
  501098
  502287
  510545
  511254
  511274
  513963
  522165
  526504
  526905
  527911
  527922
  529739
  531103
  531403
  531524
  531789
  533897
  534566
  547468
  552800
  555797
  578484
  579517
  597160
  600128
  628362
  632681
  632691
  642065
  660713
  665916
  668645
  669007
  669058
  669362
  671044
  680816
  682478
  686330
  695868
  700975
  713505
  722548
  750121
  788926
  788953
  797738
  806437
  814270
]
1.97 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "хардкор анал масл"
]
1.84 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жесткий анал в масле"
]
1.68 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.