Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.07 ms
(87.74%)
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
  8064
  9637
  12708
  13373
  50344
  92130
  107712
  117479
  135519
  159865
  163135
  202807
  210302
  237173
  353299
  365863
  381873
  382215
  382750
  383053
  384258
  385045
  385239
  385291
  385425
  386023
  386385
  387000
  387132
  387374
  387477
  387680
  388471
  389675
  391607
  395349
  395940
  397838
  398799
  398874
  400409
  401485
  402119
  404084
  405775
  417293
  418565
  419943
  422321
  422408
  427204
  438560
  443144
  445483
  449084
  457719
  470592
  470690
  475278
  478357
  487982
  496130
  503979
  510928
  524993
  529679
  530118
  531012
  536978
  542106
  548100
  553481
  575000
  583509
  587310
  590366
  593006
  603007
  604367
  623509
  626655
  629696
  631784
  631870
  642864
  651591
  655507
  667174
  669196
  687070
  688525
  700038
  713686
  715701
  725517
  739158
  739789
  746385
  755287
  762693
  766380
  769479
  769493
  771353
  772078
  778251
  781171
  782071
  785577
  788464
  790519
  791848
  796426
  797062
  797483
  803887
  805608
  807161
  812222
  817270
]
10.06 ms
(6.39%)
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
  755287
  388471
  365863
  438560
  470592
  449084
  387680
  13373
  387374
  382750
  385291
  381873
  397838
  402119
  548100
  651591
  655507
  713686
  669196
  688525
  603007
  590366
  778251
  788464
  803887
  805608
  812222
  772078
  791848
  746385
  715701
  395349
  422321
  817270
  524993
  529679
  583509
  587310
  593006
  631784
  762693
  405775
  107712
  210302
  389675
  478357
  531012
  700038
  626655
  629696
  790519
  781171
  766380
  8064
  782071
  725517
  739158
  385239
  202807
  387477
  404084
  503979
  553481
  575000
  163135
  353299
  395940
  50344
  470690
  384258
  12708
  530118
  739789
  387000
  400409
  401485
  383053
  135519
  92130
  387132
  510928
  667174
  687070
  604367
  631870
  642864
  807161
  796426
  797062
  769479
  771353
  769493
  623509
  785577
  797483
  475278
  385425
  419943
  386385
  385045
  237173
  382215
  398799
  422408
  418565
  443144
  487982
  536978
  496130
  542106
  117479
  159865
  457719
  398874
  427204
  445483
  417293
  386023
  391607
  9637
]
2.84 ms
(1.81%)
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
  8064
  9637
  12708
  13373
  50344
  92130
  107712
  117479
  135519
  159865
  163135
  202807
  210302
  237173
  353299
  365863
  381873
  382215
  382750
  383053
  384258
  385045
  385239
  385291
  385425
  386023
  386385
  387000
  387132
  387374
  387477
  387680
  388471
  389675
  391607
  395349
  395940
  397838
  398799
  398874
  400409
  401485
  402119
  404084
  405775
  417293
  418565
  419943
  422321
  422408
  427204
  438560
  443144
  445483
  449084
  457719
  470592
  470690
  475278
  478357
  487982
  496130
  503979
  510928
  524993
  529679
  530118
  531012
  536978
  542106
  548100
  553481
  575000
  583509
  587310
  590366
  593006
  603007
  604367
  623509
  626655
  629696
  631784
  631870
  642864
  651591
  655507
  667174
  669196
  687070
  688525
  700038
  713686
  715701
  725517
  739158
  739789
  746385
  755287
  762693
  766380
  769479
  769493
  771353
  772078
  778251
  781171
  782071
  785577
  788464
  790519
  791848
  796426
  797062
  797483
  803887
  805608
  807161
  812222
  817270
]
1.99 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "сочная попка"
]
1.60 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "шикарная жоп"
]
1.57 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "шикарная жоп"
]
1.24 ms
(0.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.