Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.76 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 2.25 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "два в киске"
]
3 16.63 ms
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
  456585
  485970
  494290
  491385
  507352
  623644
  515571
  584537
  556050
  359918
  381812
  420252
  449322
  466646
  447705
  404927
  388903
  452444
  511228
  526121
  462236
  435064
  476529
  430956
  511577
  492610
  511294
  395513
  398756
  411954
  429873
  409783
  457267
  607924
  404240
  466231
  571979
  380962
  382636
  509199
  810867
  382697
  388754
  338025
  403268
  147400
  233147
  546966
  605655
  608775
  581626
  516171
  445971
  400834
  405699
  419459
  441495
  478111
  526122
  531326
  521030
  488750
  555014
  543623
  551099
  551810
  582605
  741046
  442647
  36832
  385436
  401184
  429375
  439365
  444449
  485944
  521595
  124494
  167756
  382078
  359441
  96239
  47689
  123147
  389553
  399727
  400944
  408709
  424985
  425354
  426721
  482450
  450243
  487307
  517081
  469600
  602337
  188129
  332249
  382365
  391204
  391904
  398908
  453855
  466299
  466712
  479727
  29403
  381846
  474056
  476681
  388066
  514458
  524430
  507415
  444022
  418534
  445945
  548666
  420216
]
4 3.17 ms
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
  29403
  36832
  47689
  96239
  123147
  124494
  147400
  167756
  188129
  233147
  332249
  338025
  359441
  359918
  380962
  381812
  381846
  382078
  382365
  382636
  382697
  385436
  388066
  388754
  388903
  389553
  391204
  391904
  395513
  398756
  398908
  399727
  400834
  400944
  401184
  403268
  404240
  404927
  405699
  408709
  409783
  411954
  418534
  419459
  420216
  420252
  424985
  425354
  426721
  429375
  429873
  430956
  435064
  439365
  441495
  442647
  444022
  444449
  445945
  445971
  447705
  449322
  450243
  452444
  453855
  456585
  457267
  462236
  466231
  466299
  466646
  466712
  469600
  474056
  476529
  476681
  478111
  479727
  482450
  485944
  485970
  487307
  488750
  491385
  492610
  494290
  507352
  507415
  509199
  511228
  511294
  511577
  514458
  515571
  516171
  517081
  521030
  521595
  524430
  526121
  526122
  531326
  543623
  546966
  548666
  551099
  551810
  555014
  556050
  571979
  581626
  582605
  584537
  602337
  605655
  607924
  608775
  623644
  741046
  810867
]
5 236.18 ms
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
  29403
  36832
  47689
  96239
  123147
  124494
  147400
  167756
  188129
  233147
  332249
  338025
  359441
  359918
  380962
  381812
  381846
  382078
  382365
  382636
  382697
  385436
  388066
  388754
  388903
  389553
  391204
  391904
  395513
  398756
  398908
  399727
  400834
  400944
  401184
  403268
  404240
  404927
  405699
  408709
  409783
  411954
  418534
  419459
  420216
  420252
  424985
  425354
  426721
  429375
  429873
  430956
  435064
  439365
  441495
  442647
  444022
  444449
  445945
  445971
  447705
  449322
  450243
  452444
  453855
  456585
  457267
  462236
  466231
  466299
  466646
  466712
  469600
  474056
  476529
  476681
  478111
  479727
  482450
  485944
  485970
  487307
  488750
  491385
  492610
  494290
  507352
  507415
  509199
  511228
  511294
  511577
  514458
  515571
  516171
  517081
  521030
  521595
  524430
  526121
  526122
  531326
  543623
  546966
  548666
  551099
  551810
  555014
  556050
  571979
  581626
  582605
  584537
  602337
  605655
  607924
  608775
  623644
  741046
  810867
]
6 2.14 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "два в вагин"
]
7 1.89 ms
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.