Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.04 ms
(55.79%)
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
  310679
  386751
  388757
  389431
  390574
  391917
  391945
  391994
  404698
  406062
  406371
  410430
  421228
  423495
  443822
  444003
  444733
  445787
  448350
  448819
  448845
  450226
  453826
  460289
  460673
  464936
  466263
  468097
  468955
  470286
  472319
  474003
  477548
  477961
  478036
  484639
  484739
  486341
  486810
  486834
  487360
  493515
  496074
  496554
  502102
  505843
  508575
  522918
  525133
  527750
  527873
  541074
  555752
  561028
  566760
  571217
  578701
  582797
  584364
  586564
  588357
  596000
  609071
  629428
  644278
  644643
  648211
  651635
  656546
  660716
  675479
  680295
  684029
  703080
  707416
  710018
  714122
  714574
  714587
  717535
  722062
  727742
  727777
  728345
  729243
  730357
  740479
  748695
  750868
  753242
  756406
  761521
  766896
  767058
  767604
  786454
  786525
  791846
  792533
  793232
  799093
  799146
  801944
  802723
  803805
  807422
  812229
  814926
  815347
  815559
  815699
  815714
  815869
  815897
  816968
  817841
  818387
  820327
  821036
  824363
]
130.69 ms
(34.55%)
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
  310679
  386751
  388757
  389431
  390574
  391917
  391945
  391994
  404698
  406062
  406371
  410430
  421228
  423495
  443822
  444003
  444733
  445787
  448350
  448819
  448845
  450226
  453826
  460289
  460673
  464936
  466263
  468097
  468955
  470286
  472319
  474003
  477548
  477961
  478036
  484639
  484739
  486341
  486810
  486834
  487360
  493515
  496074
  496554
  502102
  505843
  508575
  522918
  525133
  527750
  527873
  541074
  555752
  561028
  566760
  571217
  578701
  582797
  584364
  586564
  588357
  596000
  609071
  629428
  644278
  644643
  648211
  651635
  656546
  660716
  675479
  680295
  684029
  703080
  707416
  710018
  714122
  714574
  714587
  717535
  722062
  727742
  727777
  728345
  729243
  730357
  740479
  748695
  750868
  753242
  756406
  761521
  766896
  767058
  767604
  786454
  786525
  791846
  792533
  793232
  799093
  799146
  801944
  802723
  803805
  807422
  812229
  814926
  815347
  815559
  815699
  815714
  815869
  815897
  816968
  817841
  818387
  820327
  821036
  824363
]
28.71 ms
(7.59%)
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
  730357
  767058
  729243
  753242
  714574
  714587
  803805
  477548
  493515
  648211
  660716
  707416
  656546
  727777
  714122
  722062
  525133
  824363
  675479
  807422
  812229
  727742
  728345
  748695
  799146
  505843
  310679
  586564
  468097
  820327
  508575
  527750
  386751
  421228
  448350
  390574
  410430
  584364
  680295
  588357
  793232
  750868
  710018
  444003
  470286
  406371
  487360
  578701
  717535
  609071
  423495
  468955
  484739
  460289
  389431
  406062
  486834
  448819
  522918
  786525
  756406
  802723
  766896
  391945
  466263
  444733
  484639
  460673
  388757
  453826
  450226
  761521
  767604
  791846
  478036
  792533
  477961
  445787
  391994
  474003
  527873
  464936
  541074
  582797
  496074
  448845
  629428
  561028
  404698
  496554
  486341
  815714
  815897
  816968
  818387
  814926
  815559
  815699
  815869
  821036
  815347
  817841
  486810
  502102
  566760
  555752
  571217
  684029
  703080
  651635
  596000
  801944
  786454
  799093
  740479
  644278
  644643
  443822
  472319
  391917
]
2.51 ms
(0.66%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "волосатые зрелки анал…"
]
2.09 ms
(0.55%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая зрелая женщин анал"
]
1.56 ms
(0.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.