Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.67 ms
(84.08%)
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
  95855
  95982
  142993
  282010
  381940
  383439
  384373
  386288
  388028
  388903
  391184
  391920
  397881
  400638
  401307
  404459
  407324
  412288
  416166
  419873
  425987
  473212
  477878
  480073
  480398
  489241
  509809
  516040
  518553
  522609
  530310
  530799
  532833
  532999
  536332
  541216
  553494
  554966
  563534
  567343
  581348
  585971
  587970
  592307
  593743
  596815
  599677
  599963
  600269
  601622
  603616
  604567
  608035
  609603
  609802
  609991
  616343
  619408
  621976
  623296
  633815
  641148
  644314
  649136
  651276
  668550
  670098
  677707
  677729
  677958
  692786
  694484
  698457
  699516
  699756
  703080
  705549
  706599
  706939
  707333
  708449
  710425
  711998
  720830
  721830
  724147
  724182
  729826
  744624
  770307
  770732
  770877
  770882
  770912
  789959
  792560
  793340
  797562
  801967
  802112
  802161
  807951
  808112
  809504
  811792
  815190
  815214
  815442
  815608
  815752
  816259
  816905
  816968
  817024
  817319
  818387
  818456
  818460
  819571
  823809
]
16.78 ms
(9.89%)
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
  599963
  401307
  509809
  381940
  587970
  404459
  553494
  532999
  724182
  633815
  808112
  388028
  397881
  707333
  585971
  609991
  724147
  699756
  567343
  282010
  386288
  95855
  815442
  818460
  823809
  816259
  473212
  518553
  536332
  694484
  699516
  706599
  554966
  623296
  710425
  383439
  818456
  477878
  711998
  621976
  142993
  816905
  817024
  815214
  819571
  815752
  480073
  532833
  649136
  670098
  698457
  651276
  708449
  720830
  604567
  609802
  603616
  592307
  609603
  644314
  596815
  599677
  600269
  601622
  608035
  616343
  793340
  802161
  770912
  792560
  770877
  744624
  770732
  641148
  807951
  809504
  419873
  593743
  95982
  522609
  412288
  425987
  480398
  541216
  581348
  391920
  384373
  391184
  815608
  816968
  817319
  818387
  815190
  489241
  530310
  530799
  677707
  677958
  703080
  705549
  706939
  721830
  668550
  677729
  692786
  619408
  801967
  802112
  811792
  729826
  770307
  770882
  789959
  797562
  407324
  416166
  516040
  388903
  400638
  563534
]
3.25 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
  95855
  95982
  142993
  282010
  381940
  383439
  384373
  386288
  388028
  388903
  391184
  391920
  397881
  400638
  401307
  404459
  407324
  412288
  416166
  419873
  425987
  473212
  477878
  480073
  480398
  489241
  509809
  516040
  518553
  522609
  530310
  530799
  532833
  532999
  536332
  541216
  553494
  554966
  563534
  567343
  581348
  585971
  587970
  592307
  593743
  596815
  599677
  599963
  600269
  601622
  603616
  604567
  608035
  609603
  609802
  609991
  616343
  619408
  621976
  623296
  633815
  641148
  644314
  649136
  651276
  668550
  670098
  677707
  677729
  677958
  692786
  694484
  698457
  699516
  699756
  703080
  705549
  706599
  706939
  707333
  708449
  710425
  711998
  720830
  721830
  724147
  724182
  729826
  744624
  770307
  770732
  770877
  770882
  770912
  789959
  792560
  793340
  797562
  801967
  802112
  802161
  807951
  808112
  809504
  811792
  815190
  815214
  815442
  815608
  815752
  816259
  816905
  816968
  817024
  817319
  818387
  818456
  818460
  819571
  823809
]
2.11 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "threesome anal milf"
]
1.88 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс втро анал milf"
]
1.58 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс втро анал milf"
]
1.41 ms
(0.83%)
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.