Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
169.43 ms
(83.76%)
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
  383943
  390922
  401933
  405891
  410051
  410642
  412132
  413595
  416098
  417177
  417631
  419132
  419740
  420587
  420659
  421494
  422044
  424321
  425027
  425799
  425980
  426459
  427346
  429985
  430048
  430422
  437864
  438278
  443323
  443652
  445471
  446337
  448810
  450318
  452034
  452144
  453813
  453918
  458010
  460771
  464011
  464139
  464464
  466230
  466994
  467025
  471639
  472513
  473102
  473539
  477890
  479196
  480745
  481895
  482409
  482674
  483107
  484719
  489738
  491078
  491210
  492269
  493477
  495230
  495739
  495835
  497362
  499028
  501198
  504417
  506573
  507601
  507813
  508492
  508547
  510588
  511503
  514587
  514815
  514949
  515126
  515183
  516007
  516103
  521985
  522212
  532655
  533846
  534845
  536744
  537208
  538207
  544381
  551736
  557064
  559181
  559766
  561816
  562775
  562803
  565539
  566082
  567153
  572029
  573234
  573314
  580270
  581095
  588318
  590910
  591135
  591314
  593875
  602017
  603854
  614074
  618874
  646255
  675321
  682096
]
23.35 ms
(11.54%)
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
  484719
  491210
  506573
  497362
  501198
  538207
  448810
  532655
  536744
  562803
  646255
  590910
  445471
  682096
  508547
  614074
  420587
  516103
  390922
  417631
  425027
  450318
  537208
  544381
  561816
  593875
  437864
  416098
  510588
  521985
  551736
  477890
  427346
  471639
  430048
  417177
  472513
  483107
  489738
  383943
  405891
  425799
  443652
  412132
  413595
  429985
  453918
  452144
  446337
  467025
  504417
  507601
  514587
  559766
  565539
  567153
  559181
  562775
  464464
  426459
  466230
  421494
  491078
  514949
  515183
  516007
  511503
  515126
  602017
  481895
  591135
  430422
  492269
  507813
  533846
  534845
  410051
  493477
  508492
  443323
  438278
  580270
  458010
  464139
  572029
  591314
  603854
  618874
  424321
  425980
  482409
  482674
  464011
  495739
  495835
  480745
  581095
  401933
  410642
  473102
  495230
  499028
  522212
  514815
  479196
  419132
  452034
  422044
  566082
  675321
  573314
  588318
  419740
  420659
  466994
  453813
  473539
  460771
  557064
  573234
]
2.45 ms
(1.21%)
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
  383943
  390922
  401933
  405891
  410051
  410642
  412132
  413595
  416098
  417177
  417631
  419132
  419740
  420587
  420659
  421494
  422044
  424321
  425027
  425799
  425980
  426459
  427346
  429985
  430048
  430422
  437864
  438278
  443323
  443652
  445471
  446337
  448810
  450318
  452034
  452144
  453813
  453918
  458010
  460771
  464011
  464139
  464464
  466230
  466994
  467025
  471639
  472513
  473102
  473539
  477890
  479196
  480745
  481895
  482409
  482674
  483107
  484719
  489738
  491078
  491210
  492269
  493477
  495230
  495739
  495835
  497362
  499028
  501198
  504417
  506573
  507601
  507813
  508492
  508547
  510588
  511503
  514587
  514815
  514949
  515126
  515183
  516007
  516103
  521985
  522212
  532655
  533846
  534845
  536744
  537208
  538207
  544381
  551736
  557064
  559181
  559766
  561816
  562775
  562803
  565539
  566082
  567153
  572029
  573234
  573314
  580270
  581095
  588318
  590910
  591135
  591314
  593875
  602017
  603854
  614074
  618874
  646255
  675321
  682096
]
2.01 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "лижет две пизды"
]
1.85 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "лиза две вагин"
]
1.58 ms
(0.78%)
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.