Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
182.28 ms
(87.45%)
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
  388346
  391945
  421582
  422180
  423837
  423995
  424271
  437188
  438532
  438619
  439281
  439325
  439343
  439362
  442921
  444421
  445212
  446251
  447281
  449626
  450077
  450367
  450948
  452362
  452574
  452791
  455603
  459046
  463693
  470068
  473515
  477145
  477246
  483079
  493411
  495800
  511137
  511857
  512143
  519699
  520953
  521677
  523640
  534451
  543899
  545677
  546381
  555565
  556445
  560345
  564102
  571726
  577023
  587020
  587312
  597130
  598540
  598814
  600936
  602203
  605874
  619299
  619636
  620253
  623280
  661424
  662102
  666491
  667045
  679491
  679974
  680562
  689036
  689170
  689886
  690684
  701962
  702864
  706717
  708846
  718678
  725507
  738926
  739089
  742359
  745126
  751285
  751546
  751692
  758076
  758335
  766415
  769023
  770387
  777829
  778768
  780164
  780268
  783004
  783041
  784351
  784681
  785870
  788360
  791206
  791212
  791445
  795380
  795721
  803882
  806815
  807244
  807595
  807902
  808796
  808984
  808998
  812039
  813558
  826953
]
16.35 ms
(7.84%)
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
  808998
  766415
  751546
  795380
  769023
  598540
  751285
  388346
  813558
  564102
  679491
  619636
  806815
  791212
  788360
  808796
  738926
  623280
  791206
  438532
  758335
  477246
  519699
  555565
  511137
  543899
  597130
  785870
  439343
  452791
  450367
  667045
  587312
  450948
  446251
  423837
  439281
  422180
  706717
  680562
  605874
  598814
  600936
  808984
  784351
  791445
  807902
  751692
  739089
  742359
  807244
  439362
  520953
  495800
  523640
  725507
  571726
  511857
  477145
  421582
  452362
  442921
  445212
  424271
  449626
  470068
  512143
  826953
  666491
  708846
  778768
  812039
  780164
  783041
  803882
  780268
  661424
  459046
  391945
  452574
  718678
  423995
  689036
  602203
  438619
  439325
  483079
  546381
  690684
  556445
  807595
  784681
  745126
  770387
  620253
  444421
  450077
  463693
  473515
  521677
  493411
  545677
  783004
  447281
  534451
  577023
  560345
  701962
  662102
  702864
  679974
  689886
  587020
  619299
  758076
  777829
  795721
  455603
  689170
  437188
]
2.74 ms
(1.32%)
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
  388346
  391945
  421582
  422180
  423837
  423995
  424271
  437188
  438532
  438619
  439281
  439325
  439343
  439362
  442921
  444421
  445212
  446251
  447281
  449626
  450077
  450367
  450948
  452362
  452574
  452791
  455603
  459046
  463693
  470068
  473515
  477145
  477246
  483079
  493411
  495800
  511137
  511857
  512143
  519699
  520953
  521677
  523640
  534451
  543899
  545677
  546381
  555565
  556445
  560345
  564102
  571726
  577023
  587020
  587312
  597130
  598540
  598814
  600936
  602203
  605874
  619299
  619636
  620253
  623280
  661424
  662102
  666491
  667045
  679491
  679974
  680562
  689036
  689170
  689886
  690684
  701962
  702864
  706717
  708846
  718678
  725507
  738926
  739089
  742359
  745126
  751285
  751546
  751692
  758076
  758335
  766415
  769023
  770387
  777829
  778768
  780164
  780268
  783004
  783041
  784351
  784681
  785870
  788360
  791206
  791212
  791445
  795380
  795721
  803882
  806815
  807244
  807595
  807902
  808796
  808984
  808998
  812039
  813558
  826953
]
2.04 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian dildo riding"
]
1.92 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(0.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск дилд riding"
]
1.47 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск дилд riding"
]

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.