Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
363.51 ms
(93.61%)
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
  21220
  69969
  251476
  305626
  366321
  382378
  386103
  394233
  403045
  403050
  425939
  456885
  515118
  515198
  538868
  550448
  550663
  552013
  560408
  566981
  567145
  578470
  588625
  600105
  603145
  605610
  607103
  607203
  608042
  612106
  613471
  618873
  620856
  621686
  622216
  622540
  631601
  637061
  649561
  663359
  663910
  663932
  663955
  663975
  664302
  664825
  665134
  665498
  667510
  667850
  668453
  670476
  676445
  676469
  676528
  677011
  681322
  682511
  691994
  696964
  696970
  696972
  696977
  696981
  700660
  709639
  710970
  712830
  719817
  720429
  722652
  722664
  722919
  724904
  727650
  731693
  732167
  734907
  735587
  735602
  735814
  741248
  741652
  743096
  743126
  743127
  744315
  744326
  744359
  745003
  745818
  748145
  748386
  754128
  754206
  759405
  759560
  759564
  759565
  759572
  759575
  759642
  767960
  767961
  773620
  774155
  788095
  788471
  788749
  789283
  800700
  806031
  812097
  812115
  812129
  812150
  816232
  821375
  821798
  826097
]
15.47 ms
(3.98%)
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
  550448
  305626
  744359
  816232
  826097
  515118
  515198
  550663
  691994
  637061
  812097
  759564
  812150
  767961
  741248
  748145
  774155
  722664
  622540
  741652
  456885
  649561
  800700
  366321
  69969
  821375
  663932
  676528
  676445
  677011
  712830
  719817
  600105
  605610
  788471
  788749
  724904
  759575
  735587
  767960
  735814
  745003
  700660
  21220
  386103
  667850
  670476
  696981
  696964
  789283
  754128
  567145
  251476
  425939
  538868
  578470
  664302
  663910
  676469
  696977
  663359
  696970
  603145
  613471
  621686
  812115
  735602
  745818
  773620
  727650
  732167
  744326
  608042
  612106
  722919
  403050
  394233
  382378
  403045
  682511
  722652
  667510
  668453
  681322
  620856
  744315
  788095
  731693
  754206
  743126
  759560
  759642
  759572
  709639
  743127
  560408
  734907
  821798
  552013
  566981
  665134
  665498
  696972
  720429
  663955
  663975
  664825
  710970
  588625
  607203
  622216
  631601
  607103
  618873
  806031
  812129
  743096
  748386
  759565
  759405
]
2.55 ms
(0.66%)
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
  21220
  69969
  251476
  305626
  366321
  382378
  386103
  394233
  403045
  403050
  425939
  456885
  515118
  515198
  538868
  550448
  550663
  552013
  560408
  566981
  567145
  578470
  588625
  600105
  603145
  605610
  607103
  607203
  608042
  612106
  613471
  618873
  620856
  621686
  622216
  622540
  631601
  637061
  649561
  663359
  663910
  663932
  663955
  663975
  664302
  664825
  665134
  665498
  667510
  667850
  668453
  670476
  676445
  676469
  676528
  677011
  681322
  682511
  691994
  696964
  696970
  696972
  696977
  696981
  700660
  709639
  710970
  712830
  719817
  720429
  722652
  722664
  722919
  724904
  727650
  731693
  732167
  734907
  735587
  735602
  735814
  741248
  741652
  743096
  743126
  743127
  744315
  744326
  744359
  745003
  745818
  748145
  748386
  754128
  754206
  759405
  759560
  759564
  759565
  759572
  759575
  759642
  767960
  767961
  773620
  774155
  788095
  788471
  788749
  789283
  800700
  806031
  812097
  812115
  812129
  812150
  816232
  821375
  821798
  826097
]
2.16 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "old girl"
]
1.78 ms
(0.46%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.43%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "old девушк"
]
1.20 ms
(0.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "old девушк"
]

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.