Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.31 ms
(78.71%)
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
  393585
  400638
  402678
  405921
  409767
  414651
  415145
  417880
  419245
  419677
  419694
  421288
  423980
  425523
  427494
  428424
  429713
  432131
  432791
  443162
  443216
  443392
  443780
  445835
  446863
  448327
  449142
  451265
  451521
  452040
  453159
  453229
  454599
  457500
  459457
  460040
  465976
  466212
  466973
  467036
  479700
  479779
  480742
  481663
  492682
  493544
  494233
  498620
  501290
  511774
  515076
  516979
  520511
  521049
  521790
  523562
  523663
  528265
  534313
  534787
  537922
  541337
  544790
  555394
  557812
  559058
  560080
  576681
  576699
  577357
  580424
  580756
  583247
  585740
  586917
  600381
  604093
  606583
  606816
  619604
  620154
  623364
  624799
  624802
  646219
  649566
  659437
  673051
  675936
  684996
  695183
  720258
  722512
  748210
  748253
  750060
  766911
  789494
  790034
  792663
  795437
  798677
  806157
  806323
  807557
  807936
  814568
  814861
  814883
  814945
  815002
  815170
  815252
  815427
  815851
  816260
  819823
  822692
  824791
  827420
]
24.19 ms
(15.57%)
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
  819823
  492682
  405921
  414651
  453159
  467036
  443780
  480742
  393585
  457500
  466212
  460040
  494233
  432131
  425523
  528265
  400638
  402678
  443162
  415145
  419245
  419677
  421288
  443216
  443392
  409767
  417880
  419694
  427494
  815002
  822692
  824791
  815170
  827420
  814861
  814883
  815252
  814568
  814945
  815427
  815851
  816260
  452040
  459457
  451265
  453229
  454599
  479700
  445835
  466973
  479779
  481663
  501290
  521049
  521790
  534313
  537922
  498620
  515076
  523562
  523663
  511774
  516979
  520511
  534787
  465976
  493544
  576699
  580424
  560080
  583247
  541337
  544790
  555394
  576681
  577357
  675936
  684996
  695183
  720258
  646219
  649566
  659437
  673051
  557812
  559058
  580756
  600381
  606583
  624799
  624802
  585740
  604093
  606816
  619604
  620154
  586917
  790034
  792663
  807557
  789494
  806157
  748210
  795437
  748253
  766911
  750060
  623364
  722512
  798677
  806323
  807936
  429713
  432791
  448327
  449142
  451521
  423980
  428424
  446863
]
2.40 ms
(1.55%)
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
  393585
  400638
  402678
  405921
  409767
  414651
  415145
  417880
  419245
  419677
  419694
  421288
  423980
  425523
  427494
  428424
  429713
  432131
  432791
  443162
  443216
  443392
  443780
  445835
  446863
  448327
  449142
  451265
  451521
  452040
  453159
  453229
  454599
  457500
  459457
  460040
  465976
  466212
  466973
  467036
  479700
  479779
  480742
  481663
  492682
  493544
  494233
  498620
  501290
  511774
  515076
  516979
  520511
  521049
  521790
  523562
  523663
  528265
  534313
  534787
  537922
  541337
  544790
  555394
  557812
  559058
  560080
  576681
  576699
  577357
  580424
  580756
  583247
  585740
  586917
  600381
  604093
  606583
  606816
  619604
  620154
  623364
  624799
  624802
  646219
  649566
  659437
  673051
  675936
  684996
  695183
  720258
  722512
  748210
  748253
  750060
  766911
  789494
  790034
  792663
  795437
  798677
  806157
  806323
  807557
  807936
  814568
  814861
  814883
  814945
  815002
  815170
  815252
  815427
  815851
  816260
  819823
  822692
  824791
  827420
]
1.94 ms
(1.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анилингус волосатая"
]
1.81 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "анилингус волосатая ж…"
]
1.57 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.18 ms
(0.76%)
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.