Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.36 ms
(84.97%)
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
  2332
  5565
  51659
  79479
  79742
  147313
  209941
  307458
  310945
  330409
  339392
  382362
  384904
  385319
  385454
  385600
  387117
  389887
  391759
  393049
  393310
  396107
  396933
  398588
  398790
  402682
  403589
  407504
  408751
  412875
  414785
  417267
  417950
  418693
  420608
  429742
  443699
  452399
  477739
  490848
  501603
  540973
  548910
  549288
  563316
  575303
  590266
  595695
  597990
  607109
  615460
  620211
  620969
  627986
  628792
  637459
  638083
  647130
  651901
  664614
  666452
  667410
  679687
  683252
  688756
  693006
  704015
  713164
  715666
  716601
  716648
  716736
  723482
  723485
  728869
  734424
  736259
  739548
  742191
  742944
  758894
  762635
  763263
  763329
  769621
  769859
  774717
  775580
  777477
  778959
  779436
  780008
  780523
  780853
  780925
  786421
  789823
  791173
  792582
  793746
  795604
  797908
  798907
  799419
  799904
  802972
  805053
  805056
  808768
  810607
  814311
  815036
  818650
  819728
  819914
  824842
  824943
  825121
]
14.44 ms
(8.87%)
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
  774717
  777477
  778959
  779436
  786421
  791173
  792582
  798907
  805053
  805056
  810607
  2332
  79479
  420608
  79742
  385319
  398790
  418693
  429742
  51659
  339392
  396933
  501603
  477739
  443699
  414785
  563316
  797908
  789823
  716648
  407504
  408751
  742191
  417950
  412875
  452399
  307458
  827931
  402682
  384904
  723485
  607109
  728869
  715666
  310945
  382362
  389887
  490848
  540973
  666452
  693006
  704015
  713164
  575303
  590266
  637459
  597990
  799419
  808768
  734424
  762635
  739548
  775580
  780925
  387117
  396107
  5565
  393310
  716601
  595695
  780853
  793746
  403589
  549288
  815036
  679687
  620211
  769859
  417267
  209941
  147313
  385454
  391759
  330409
  398588
  818650
  819728
  819914
  824943
  825121
  814311
  824842
  548910
  647130
  664614
  683252
  716736
  651901
  667410
  688756
  615460
  620969
  628792
  638083
  795604
  780008
  799904
  736259
  802972
  769621
  742944
  763329
  758894
  763263
  764819
  627986
  723482
  780523
  385600
  393049
]
3.13 ms
(1.92%)
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
  2332
  5565
  51659
  79479
  79742
  147313
  209941
  307458
  310945
  330409
  339392
  382362
  384904
  385319
  385454
  385600
  387117
  389887
  391759
  393049
  393310
  396107
  396933
  398588
  398790
  402682
  403589
  407504
  408751
  412875
  414785
  417267
  417950
  418693
  420608
  429742
  443699
  452399
  477739
  490848
  501603
  540973
  548910
  549288
  563316
  575303
  590266
  595695
  597990
  607109
  615460
  620211
  620969
  627986
  628792
  637459
  638083
  647130
  651901
  664614
  666452
  667410
  679687
  683252
  688756
  693006
  704015
  713164
  715666
  716601
  716648
  716736
  723482
  723485
  728869
  734424
  736259
  739548
  742191
  742944
  758894
  762635
  763263
  763329
  769621
  769859
  774717
  775580
  777477
  778959
  779436
  780008
  780523
  780853
  780925
  786421
  789823
  791173
  792582
  793746
  795604
  797908
  798907
  799419
  799904
  802972
  805053
  805056
  808768
  810607
  814311
  815036
  818650
  819728
  819914
  824842
  824943
  825121
]
1.98 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "скачать минет"
]
1.76 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "скача минет оральн секс"
]
1.64 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "скача минет оральн секс"
]
1.52 ms
(0.94%)
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.