Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.88 ms
(84.77%)
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
  70745
  82217
  168687
  354774
  382874
  387304
  398043
  398105
  406578
  415036
  415917
  419951
  429546
  460952
  460956
  473060
  478425
  491448
  492411
  499485
  512213
  512215
  512955
  515884
  519956
  521230
  522193
  534207
  550721
  550752
  550763
  550764
  550985
  551028
  551105
  551941
  551949
  551972
  551995
  552030
  552897
  552917
  554305
  554415
  556389
  556409
  558391
  558423
  558427
  558431
  559856
  559863
  559866
  559873
  559896
  559897
  559917
  559918
  559920
  565475
  565483
  572725
  572730
  572732
  572737
  574642
  576536
  578685
  584794
  586623
  588390
  590958
  590960
  590972
  591849
  593023
  595792
  598515
  603191
  603458
  610669
  613857
  619411
  619427
  619438
  619449
  619455
  619459
  622201
  622336
  622615
  622618
  622626
  623528
  623619
  634866
  643028
  664267
  673041
  694193
  702445
  710206
  712166
  713474
  721756
  722426
  724460
  724480
  736172
  737132
  737136
  742126
  742486
  742925
  761271
  763322
  780631
  792763
  805919
  810051
]
14.79 ms
(9.30%)
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
  521230
  574642
  551972
  551949
  552897
  792763
  713474
  473060
  556409
  558431
  559873
  598515
  534207
  406578
  554305
  590972
  499485
  551028
  415036
  415917
  70745
  622626
  761271
  558391
  722426
  710206
  522193
  558423
  619427
  763322
  613857
  519956
  576536
  742126
  572732
  551105
  590960
  559897
  590958
  387304
  354774
  512955
  591849
  603191
  491448
  565483
  559896
  559917
  559920
  694193
  673041
  622336
  736172
  478425
  512213
  572737
  556389
  643028
  586623
  554415
  565475
  559856
  559866
  623528
  619455
  622618
  382874
  603458
  619438
  742925
  742486
  552917
  558427
  550721
  593023
  398043
  572725
  780631
  559863
  398105
  168687
  429546
  619449
  460956
  610669
  492411
  572730
  702445
  712166
  588390
  634866
  622615
  724480
  724460
  721756
  551995
  550763
  551941
  512215
  805919
  552030
  584794
  550764
  550752
  559918
  595792
  82217
  460952
  623619
  737136
  550985
  578685
  619411
  664267
  419951
  622201
  515884
  810051
  619459
  737132
]
2.60 ms
(1.64%)
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
  70745
  82217
  168687
  354774
  382874
  387304
  398043
  398105
  406578
  415036
  415917
  419951
  429546
  460952
  460956
  473060
  478425
  491448
  492411
  499485
  512213
  512215
  512955
  515884
  519956
  521230
  522193
  534207
  550721
  550752
  550763
  550764
  550985
  551028
  551105
  551941
  551949
  551972
  551995
  552030
  552897
  552917
  554305
  554415
  556389
  556409
  558391
  558423
  558427
  558431
  559856
  559863
  559866
  559873
  559896
  559897
  559917
  559918
  559920
  565475
  565483
  572725
  572730
  572732
  572737
  574642
  576536
  578685
  584794
  586623
  588390
  590958
  590960
  590972
  591849
  593023
  595792
  598515
  603191
  603458
  610669
  613857
  619411
  619427
  619438
  619449
  619455
  619459
  622201
  622336
  622615
  622618
  622626
  623528
  623619
  634866
  643028
  664267
  673041
  694193
  702445
  710206
  712166
  713474
  721756
  722426
  724460
  724480
  736172
  737132
  737136
  742126
  742486
  742925
  761271
  763322
  780631
  792763
  805919
  810051
]
2.06 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fuck japanese"
]
1.61 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс японк азиатк"
]
1.59 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс японк азиатк"
]
1.57 ms
(0.98%)
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.