Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.28 ms
(83.73%)
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
  6663
  154127
  154133
  197472
  382207
  382821
  383635
  384306
  384422
  384752
  386929
  388053
  388374
  394187
  396073
  405520
  409887
  412814
  416020
  416515
  416583
  416597
  416611
  416613
  416616
  416621
  416632
  416659
  416669
  416694
  416696
  416703
  416712
  416746
  419167
  424614
  426390
  429608
  441125
  442548
  444524
  446002
  448351
  449930
  449970
  451337
  454793
  466633
  468949
  470479
  471074
  476847
  482115
  483684
  483731
  483736
  485468
  487291
  488721
  488841
  489361
  491860
  494295
  497691
  497697
  497916
  499872
  500333
  503816
  511953
  512442
  513846
  514231
  514233
  514248
  515546
  517638
  519181
  522169
  523196
  526160
  526179
  528504
  529205
  530268
  536264
  545379
  545404
  545445
  545455
  547486
  547489
  550550
  550816
  556900
  571726
  575401
  577038
  578003
  583689
  584008
  584362
  591021
  599619
  609097
  614956
  619102
  635889
  656932
  668660
  671043
  672939
  709674
  767731
  780165
  780179
  800515
  801610
  817875
  825878
]
17.92 ms
(9.85%)
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
  487291
  488721
  494295
  499872
  394187
  388053
  386929
  416020
  416583
  416703
  416515
  416621
  416712
  416669
  416696
  489361
  491860
  468949
  514233
  545379
  656932
  550816
  591021
  384306
  416616
  446002
  384422
  388374
  513846
  514248
  545404
  609097
  488841
  599619
  800515
  635889
  780165
  780179
  767731
  383635
  382821
  197472
  396073
  416694
  429608
  530268
  571726
  614956
  801610
  451337
  514231
  619102
  384752
  154127
  154133
  382207
  6663
  405520
  412814
  416611
  424614
  441125
  416632
  416659
  426390
  416746
  419167
  442548
  444524
  409887
  416597
  416613
  817875
  825878
  449970
  470479
  471074
  483731
  476847
  482115
  485468
  448351
  449930
  454793
  503816
  536264
  511953
  512442
  526160
  528504
  497691
  497697
  500333
  515546
  522169
  523196
  526179
  529205
  497916
  517638
  519181
  466633
  483684
  483736
  545455
  547486
  556900
  577038
  583689
  547489
  550550
  575401
  578003
  584008
  545445
  584362
  668660
  671043
  672939
  709674
]
4.55 ms
(2.50%)
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
  6663
  154127
  154133
  197472
  382207
  382821
  383635
  384306
  384422
  384752
  386929
  388053
  388374
  394187
  396073
  405520
  409887
  412814
  416020
  416515
  416583
  416597
  416611
  416613
  416616
  416621
  416632
  416659
  416669
  416694
  416696
  416703
  416712
  416746
  419167
  424614
  426390
  429608
  441125
  442548
  444524
  446002
  448351
  449930
  449970
  451337
  454793
  466633
  468949
  470479
  471074
  476847
  482115
  483684
  483731
  483736
  485468
  487291
  488721
  488841
  489361
  491860
  494295
  497691
  497697
  497916
  499872
  500333
  503816
  511953
  512442
  513846
  514231
  514233
  514248
  515546
  517638
  519181
  522169
  523196
  526160
  526179
  528504
  529205
  530268
  536264
  545379
  545404
  545445
  545455
  547486
  547489
  550550
  550816
  556900
  571726
  575401
  577038
  578003
  583689
  584008
  584362
  591021
  599619
  609097
  614956
  619102
  635889
  656932
  668660
  671043
  672939
  709674
  767731
  780165
  780179
  800515
  801610
  817875
  825878
]
1.91 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hardcore riding"
]
1.80 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "хардкор riding"
]
1.74 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "хардкор riding"
]
1.67 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.