Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.23 ms
(84.16%)
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
  398676
  402085
  402093
  402312
  402335
  408994
  411289
  417943
  418159
  418454
  418479
  418627
  422231
  423260
  425679
  427249
  429367
  433879
  435958
  438987
  444546
  447142
  455145
  455558
  458436
  459498
  461459
  461973
  462591
  466594
  468627
  470194
  470510
  471372
  473047
  473751
  474060
  474376
  474719
  475606
  477393
  478864
  479482
  485994
  487251
  487313
  491739
  492708
  493349
  493460
  495449
  496013
  496047
  500043
  512373
  512647
  517311
  521332
  521876
  522083
  522682
  526027
  526968
  536809
  538427
  548764
  551624
  552784
  554164
  554722
  557433
  558511
  558855
  559759
  560846
  564076
  567674
  569846
  570460
  571381
  571848
  573780
  573857
  575114
  577959
  578342
  580295
  590081
  594095
  594868
  595819
  598145
  603166
  603428
  603913
  608441
  615651
  626618
  628063
  628420
  636522
  642679
  668613
  671083
  676517
  709661
  737110
  739780
  743355
  747952
  754205
  758893
  765448
  785274
  789876
  795120
  806031
  806877
  806892
  810119
]
17.10 ms
(10.34%)
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
  754205
  418454
  461973
  474060
  474719
  526027
  626618
  491739
  423260
  789876
  475606
  425679
  548764
  462591
  459498
  485994
  558855
  470510
  411289
  810119
  417943
  538427
  470194
  402085
  474376
  590081
  594095
  737110
  806877
  628420
  512647
  473047
  564076
  567674
  398676
  557433
  575114
  595819
  552784
  422231
  473751
  598145
  739780
  603428
  433879
  461459
  521876
  455145
  571848
  487251
  455558
  468627
  558511
  559759
  577959
  594868
  458436
  427249
  435958
  438987
  466594
  492708
  493349
  496047
  495449
  496013
  487313
  493460
  522083
  402093
  478864
  608441
  536809
  668613
  636522
  642679
  806892
  743355
  758893
  747952
  603913
  615651
  709661
  785274
  408994
  676517
  418159
  603166
  447142
  418479
  795120
  418627
  429367
  500043
  560846
  551624
  569846
  570460
  571381
  573780
  573857
  580295
  402312
  479482
  477393
  402335
  444546
  522682
  512373
  517311
  521332
  526968
  471372
  806031
  765448
  554164
  578342
  671083
  554722
  628063
]
2.51 ms
(1.52%)
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
  398676
  402085
  402093
  402312
  402335
  408994
  411289
  417943
  418159
  418454
  418479
  418627
  422231
  423260
  425679
  427249
  429367
  433879
  435958
  438987
  444546
  447142
  455145
  455558
  458436
  459498
  461459
  461973
  462591
  466594
  468627
  470194
  470510
  471372
  473047
  473751
  474060
  474376
  474719
  475606
  477393
  478864
  479482
  485994
  487251
  487313
  491739
  492708
  493349
  493460
  495449
  496013
  496047
  500043
  512373
  512647
  517311
  521332
  521876
  522083
  522682
  526027
  526968
  536809
  538427
  548764
  551624
  552784
  554164
  554722
  557433
  558511
  558855
  559759
  560846
  564076
  567674
  569846
  570460
  571381
  571848
  573780
  573857
  575114
  577959
  578342
  580295
  590081
  594095
  594868
  595819
  598145
  603166
  603428
  603913
  608441
  615651
  626618
  628063
  628420
  636522
  642679
  668613
  671083
  676517
  709661
  737110
  739780
  743355
  747952
  754205
  758893
  765448
  785274
  789876
  795120
  806031
  806877
  806892
  810119
]
1.81 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "19 летние отсос"
]
1.73 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "18 19 лет минет оральн секс"
]
1.56 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "18 19 лет минет оральн секс"
]

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.