Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.30 ms
(84.17%)
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
  282465
  373803
  373859
  384547
  386774
  388177
  392721
  395306
  396113
  396543
  400957
  413356
  420807
  421443
  428177
  428738
  434874
  441042
  445711
  447642
  447690
  448511
  451616
  457955
  469613
  476075
  477543
  478908
  486635
  495824
  496869
  497420
  499503
  501541
  521294
  522970
  537960
  538448
  539145
  543548
  555801
  561685
  575351
  575618
  584706
  588878
  591164
  597041
  597560
  598479
  598553
  600118
  600537
  612441
  619360
  619829
  624349
  629169
  632118
  635339
  636642
  637396
  646662
  653533
  656452
  656562
  658072
  664536
  667129
  680236
  680281
  687310
  690251
  706508
  708063
  708677
  714667
  715399
  716633
  719292
  719772
  720967
  726176
  727486
  727874
  728762
  733786
  736198
  738390
  739230
  743087
  744689
  755677
  757522
  761000
  763431
  763433
  768854
  769496
  771898
  778574
  778930
  778938
  779659
  781057
  781327
  782529
  783710
  783714
  791328
  793440
  796323
  799830
  800566
  803556
  805722
  809827
  810860
  819255
  819415
]
14.68 ms
(9.13%)
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
  619360
  624349
  782529
  768854
  769496
  739230
  392721
  396543
  373803
  388177
  421443
  434874
  428177
  448511
  451616
  476075
  497420
  478908
  543548
  584706
  588878
  612441
  598553
  600118
  445711
  447690
  457955
  428738
  477543
  420807
  469613
  522970
  537960
  496869
  499503
  386774
  282465
  819415
  653533
  690251
  715399
  656562
  667129
  720967
  598479
  597041
  597560
  778930
  796323
  726176
  728762
  755677
  761000
  781057
  783714
  396113
  400957
  413356
  486635
  539145
  538448
  501541
  680281
  687310
  708677
  708063
  719772
  600537
  799830
  779659
  810860
  733786
  736198
  757522
  763431
  727874
  619829
  803556
  373859
  819255
  575351
  658072
  664536
  680236
  656452
  706508
  637396
  591164
  778574
  738390
  727486
  771898
  636642
  778938
  384547
  575618
  646662
  716633
  714667
  719292
  555801
  632118
  783710
  781327
  791328
  793440
  763433
  800566
  805722
  743087
  744689
  629169
  635339
  809827
  395306
  495824
  521294
  561685
  447642
  441042
]
2.83 ms
(1.76%)
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
  282465
  373803
  373859
  384547
  386774
  388177
  392721
  395306
  396113
  396543
  400957
  413356
  420807
  421443
  428177
  428738
  434874
  441042
  445711
  447642
  447690
  448511
  451616
  457955
  469613
  476075
  477543
  478908
  486635
  495824
  496869
  497420
  499503
  501541
  521294
  522970
  537960
  538448
  539145
  543548
  555801
  561685
  575351
  575618
  584706
  588878
  591164
  597041
  597560
  598479
  598553
  600118
  600537
  612441
  619360
  619829
  624349
  629169
  632118
  635339
  636642
  637396
  646662
  653533
  656452
  656562
  658072
  664536
  667129
  680236
  680281
  687310
  690251
  706508
  708063
  708677
  714667
  715399
  716633
  719292
  719772
  720967
  726176
  727486
  727874
  728762
  733786
  736198
  738390
  739230
  743087
  744689
  755677
  757522
  761000
  763431
  763433
  768854
  769496
  771898
  778574
  778930
  778938
  779659
  781057
  781327
  782529
  783710
  783714
  791328
  793440
  796323
  799830
  800566
  803556
  805722
  809827
  810860
  819255
  819415
]
2.22 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "doggy teen"
]
1.96 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рак teen"
]
1.90 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "рак teen"
]

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.