Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.86 ms
(86.05%)
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
  192968
  233376
  282494
  382907
  385743
  386194
  386514
  386705
  387186
  388066
  388078
  388122
  389116
  389178
  390533
  391175
  391893
  391897
  401586
  401591
  404257
  405479
  406091
  409727
  417067
  420562
  421182
  426698
  426727
  429391
  443685
  445776
  447540
  453691
  453852
  461385
  461478
  470078
  470548
  470597
  471545
  473321
  476838
  484385
  492676
  497575
  501178
  501785
  504168
  505922
  506786
  523305
  533679
  534147
  543654
  543736
  543943
  546664
  546667
  547988
  547991
  557944
  557973
  566447
  575515
  588899
  596577
  596990
  597557
  598565
  598571
  613381
  643986
  651906
  651945
  654206
  654471
  654505
  659287
  659410
  661244
  661289
  671000
  672490
  679067
  683031
  683291
  691675
  700941
  721307
  721318
  721417
  721568
  736055
  739052
  740797
  741950
  743644
  743893
  744441
  747145
  758973
  762217
  770141
  781414
  782036
  784324
  784700
  788101
  790654
  792511
  795151
  796545
  797402
  798693
  799674
  799929
  800556
  809779
  810192
]
16.09 ms
(8.45%)
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
  386705
  792511
  721568
  386514
  406091
  597557
  654206
  721417
  417067
  651906
  471545
  233376
  445776
  781414
  784324
  533679
  758973
  388078
  453852
  429391
  401591
  523305
  575515
  391893
  453691
  505922
  543736
  387186
  596990
  679067
  790654
  784700
  426727
  401586
  691675
  613381
  741950
  671000
  661289
  744441
  389178
  461385
  659410
  390533
  557944
  501785
  721318
  739052
  501178
  443685
  470548
  747145
  651945
  659287
  798693
  809779
  506786
  404257
  484385
  547991
  566447
  782036
  740797
  596577
  504168
  762217
  788101
  643986
  389116
  391175
  800556
  473321
  420562
  391897
  386194
  476838
  654471
  654505
  743644
  797402
  534147
  588899
  683031
  543654
  810192
  282494
  388066
  721307
  546664
  683291
  382907
  736055
  770141
  426698
  470078
  546667
  672490
  700941
  598565
  743893
  421182
  470597
  557973
  796545
  795151
  492676
  192968
  661244
  405479
  409727
  547988
  598571
  385743
  497575
  388122
  543943
  799929
  799674
  461478
  447540
]
3.41 ms
(1.79%)
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
  192968
  233376
  282494
  382907
  385743
  386194
  386514
  386705
  387186
  388066
  388078
  388122
  389116
  389178
  390533
  391175
  391893
  391897
  401586
  401591
  404257
  405479
  406091
  409727
  417067
  420562
  421182
  426698
  426727
  429391
  443685
  445776
  447540
  453691
  453852
  461385
  461478
  470078
  470548
  470597
  471545
  473321
  476838
  484385
  492676
  497575
  501178
  501785
  504168
  505922
  506786
  523305
  533679
  534147
  543654
  543736
  543943
  546664
  546667
  547988
  547991
  557944
  557973
  566447
  575515
  588899
  596577
  596990
  597557
  598565
  598571
  613381
  643986
  651906
  651945
  654206
  654471
  654505
  659287
  659410
  661244
  661289
  671000
  672490
  679067
  683031
  683291
  691675
  700941
  721307
  721318
  721417
  721568
  736055
  739052
  740797
  741950
  743644
  743893
  744441
  747145
  758973
  762217
  770141
  781414
  782036
  784324
  784700
  788101
  790654
  792511
  795151
  796545
  797402
  798693
  799674
  799929
  800556
  809779
  810192
]
1.86 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "руское втроем"
]
1.76 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск секс втро"
]
1.72 ms
(0.90%)
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.