Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
185.76 ms
(84.88%)
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
  210281
  391805
  392077
  418401
  418403
  422075
  436438
  437974
  438069
  448273
  449657
  455600
  456039
  456047
  456319
  458199
  458396
  460538
  461233
  462300
  463146
  470077
  470680
  471517
  472107
  473508
  473633
  474250
  474908
  474969
  476007
  476037
  476535
  476553
  477860
  479299
  480216
  480923
  481573
  484246
  485967
  486134
  486506
  487140
  490270
  491388
  491420
  493452
  495101
  495961
  496405
  498234
  498703
  501066
  501220
  505431
  507428
  509005
  510316
  513411
  513714
  514475
  517580
  518410
  519415
  519419
  521530
  522019
  522270
  523707
  525283
  543710
  544043
  546637
  547706
  547717
  551166
  551175
  551182
  553949
  554563
  556422
  557596
  557895
  558966
  560387
  562445
  563102
  563652
  564139
  565413
  568847
  576397
  579089
  581090
  594763
  597172
  598545
  598884
  599510
  607359
  612478
  622772
  651741
  663330
  667052
  669233
  691592
  699916
  719898
  736153
  739922
  764944
  765924
  778184
  786224
  794116
  818684
  819264
  825558
]
20.83 ms
(9.52%)
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
  474969
  487140
  557596
  565413
  513411
  794116
  765924
  519419
  818684
  501066
  669233
  470077
  551182
  460538
  522019
  554563
  456039
  543710
  461233
  719898
  437974
  458199
  449657
  418401
  557895
  568847
  498703
  505431
  523707
  594763
  607359
  463146
  480216
  448273
  476007
  501220
  484246
  490270
  507428
  691592
  778184
  210281
  477860
  551166
  667052
  418403
  473508
  474908
  514475
  525283
  663330
  739922
  472107
  474250
  736153
  391805
  598884
  456047
  470680
  456319
  562445
  564139
  476535
  510316
  517580
  547706
  699916
  462300
  473633
  491388
  825558
  486134
  598545
  581090
  563102
  476037
  496405
  495961
  519415
  471517
  498234
  560387
  612478
  486506
  553949
  556422
  495101
  518410
  509005
  476553
  521530
  491420
  547717
  458396
  546637
  436438
  522270
  563652
  576397
  422075
  481573
  544043
  597172
  438069
  392077
  579089
  599510
  479299
  485967
  786224
  513714
  819264
  622772
  455600
  551175
  558966
  651741
  764944
  480923
  493452
]
4.26 ms
(1.95%)
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
  210281
  391805
  392077
  418401
  418403
  422075
  436438
  437974
  438069
  448273
  449657
  455600
  456039
  456047
  456319
  458199
  458396
  460538
  461233
  462300
  463146
  470077
  470680
  471517
  472107
  473508
  473633
  474250
  474908
  474969
  476007
  476037
  476535
  476553
  477860
  479299
  480216
  480923
  481573
  484246
  485967
  486134
  486506
  487140
  490270
  491388
  491420
  493452
  495101
  495961
  496405
  498234
  498703
  501066
  501220
  505431
  507428
  509005
  510316
  513411
  513714
  514475
  517580
  518410
  519415
  519419
  521530
  522019
  522270
  523707
  525283
  543710
  544043
  546637
  547706
  547717
  551166
  551175
  551182
  553949
  554563
  556422
  557596
  557895
  558966
  560387
  562445
  563102
  563652
  564139
  565413
  568847
  576397
  579089
  581090
  594763
  597172
  598545
  598884
  599510
  607359
  612478
  622772
  651741
  663330
  667052
  669233
  691592
  699916
  719898
  736153
  739922
  764944
  765924
  778184
  786224
  794116
  818684
  819264
  825558
]
2.27 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian car sex"
]
2.10 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск вмашин секс"
]
1.80 ms
(0.82%)
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.