Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
172.75 ms
(85.31%)
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
  391027
  400182
  405221
  413108
  414047
  420392
  426435
  428035
  434530
  435180
  437089
  437749
  441402
  442263
  442325
  442370
  444736
  444742
  446754
  447247
  450195
  453569
  454447
  454944
  461259
  463962
  465938
  466876
  467489
  467514
  467725
  471313
  479473
  479767
  484123
  484139
  489016
  490559
  491382
  491410
  495629
  497320
  499506
  505966
  507101
  508486
  509096
  509259
  509824
  510121
  510690
  511814
  512244
  512249
  513298
  513873
  516404
  517938
  520057
  520575
  521059
  522791
  526127
  527042
  527128
  528367
  529445
  532799
  534041
  544846
  552855
  558266
  559687
  560138
  561925
  564696
  567623
  568761
  573779
  574793
  575205
  575746
  579501
  580631
  581805
  582708
  584228
  586499
  586652
  586676
  588405
  591259
  593476
  594007
  601333
  605458
  609203
  611301
  626441
  628090
  628324
  634475
  639277
  640888
  641949
  643935
  645973
  646894
  648634
  653580
  661977
  672671
  720291
  723352
  724291
  726707
  759329
  762221
  762234
  805601
]
17.82 ms
(8.80%)
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
  582708
  544846
  561925
  564696
  568761
  573779
  574793
  575205
  575746
  579501
  645973
  672671
  653580
  661977
  648634
  552855
  559687
  560138
  567623
  580631
  581805
  584228
  643935
  609203
  586652
  586676
  593476
  601333
  634475
  639277
  586499
  588405
  591259
  594007
  605458
  805601
  762221
  726707
  759329
  724291
  762234
  611301
  720291
  723352
  405221
  420392
  461259
  465938
  479473
  400182
  413108
  434530
  463962
  467489
  467725
  391027
  435180
  467514
  426435
  437089
  437749
  441402
  444742
  446754
  450195
  454944
  479767
  442263
  442325
  509096
  516404
  520057
  527042
  484123
  489016
  491382
  495629
  505966
  513298
  522791
  526127
  507101
  508486
  510121
  510690
  512244
  513873
  517938
  528367
  484139
  490559
  497320
  499506
  509259
  511814
  512249
  520575
  529445
  527128
  646894
  558266
  626441
  640888
  628090
  628324
  641949
  521059
  414047
  444736
  428035
  442370
  447247
  491410
  454447
  466876
  471313
  453569
  509824
  532799
  534041
]
4.26 ms
(2.10%)
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
  391027
  400182
  405221
  413108
  414047
  420392
  426435
  428035
  434530
  435180
  437089
  437749
  441402
  442263
  442325
  442370
  444736
  444742
  446754
  447247
  450195
  453569
  454447
  454944
  461259
  463962
  465938
  466876
  467489
  467514
  467725
  471313
  479473
  479767
  484123
  484139
  489016
  490559
  491382
  491410
  495629
  497320
  499506
  505966
  507101
  508486
  509096
  509259
  509824
  510121
  510690
  511814
  512244
  512249
  513298
  513873
  516404
  517938
  520057
  520575
  521059
  522791
  526127
  527042
  527128
  528367
  529445
  532799
  534041
  544846
  552855
  558266
  559687
  560138
  561925
  564696
  567623
  568761
  573779
  574793
  575205
  575746
  579501
  580631
  581805
  582708
  584228
  586499
  586652
  586676
  588405
  591259
  593476
  594007
  601333
  605458
  609203
  611301
  626441
  628090
  628324
  634475
  639277
  640888
  641949
  643935
  645973
  646894
  648634
  653580
  661977
  672671
  720291
  723352
  724291
  726707
  759329
  762221
  762234
  805601
]
2.09 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.06 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "new cock"
]
1.97 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "new cock"
]
1.55 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "new cock"
]

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.