Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.08 ms
(81.00%)
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
  12405
  107874
  243071
  343398
  381748
  385125
  387304
  389789
  392527
  416875
  416933
  417530
  417955
  418724
  419353
  421653
  422500
  423247
  423498
  424549
  426467
  426632
  426635
  426805
  426911
  427172
  429278
  430585
  431513
  431682
  433883
  452995
  453801
  456212
  456363
  456710
  456726
  463026
  465971
  466956
  470087
  479345
  484023
  484464
  487768
  487982
  491178
  491365
  491611
  492155
  499042
  500494
  504740
  507441
  508989
  515884
  516452
  521287
  522412
  524717
  526314
  527717
  527769
  530470
  532694
  532912
  533019
  534742
  534853
  535585
  536012
  537758
  537806
  538891
  539101
  540317
  540357
  541102
  541597
  544783
  544910
  547058
  550062
  550067
  550071
  550557
  559198
  563876
  565246
  565842
  568478
  569725
  572011
  578002
  590876
  600402
  603999
  620244
  622731
  623842
  629007
  630801
  638052
  648524
  653520
  665649
  689483
  689964
  699480
  709306
  720422
  747195
  747228
  764485
  775587
  784735
  814697
  817073
  817182
  824051
]
19.53 ms
(11.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
  465971
  456726
  418724
  107874
  392527
  381748
  12405
  430585
  824051
  817073
  817182
  814697
  537758
  487982
  466956
  527769
  530470
  540357
  515884
  532694
  533019
  526314
  534742
  499042
  500494
  507441
  534853
  537806
  491178
  550071
  578002
  541102
  550557
  665649
  689964
  648524
  689483
  569725
  629007
  775587
  764485
  638052
  699480
  709306
  426632
  385125
  487768
  527717
  565246
  539101
  484023
  550067
  429278
  603999
  630801
  479345
  522412
  470087
  559198
  565842
  491365
  343398
  389789
  387304
  419353
  426635
  423498
  421653
  424549
  416933
  431682
  452995
  456710
  456363
  492155
  535585
  536012
  538891
  516452
  544783
  568478
  541597
  550062
  547058
  720422
  622731
  784735
  431513
  426911
  427172
  521287
  422500
  590876
  747195
  747228
  453801
  600402
  623842
  463026
  417955
  524717
  508989
  416875
  532912
  620244
  426805
  243071
  426467
  484464
  540317
  544910
  563876
  433883
  491611
  504740
  653520
  572011
  417530
  423247
  456212
]
4.22 ms
(2.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
  12405
  107874
  243071
  343398
  381748
  385125
  387304
  389789
  392527
  416875
  416933
  417530
  417955
  418724
  419353
  421653
  422500
  423247
  423498
  424549
  426467
  426632
  426635
  426805
  426911
  427172
  429278
  430585
  431513
  431682
  433883
  452995
  453801
  456212
  456363
  456710
  456726
  463026
  465971
  466956
  470087
  479345
  484023
  484464
  487768
  487982
  491178
  491365
  491611
  492155
  499042
  500494
  504740
  507441
  508989
  515884
  516452
  521287
  522412
  524717
  526314
  527717
  527769
  530470
  532694
  532912
  533019
  534742
  534853
  535585
  536012
  537758
  537806
  538891
  539101
  540317
  540357
  541102
  541597
  544783
  544910
  547058
  550062
  550067
  550071
  550557
  559198
  563876
  565246
  565842
  568478
  569725
  572011
  578002
  590876
  600402
  603999
  620244
  622731
  623842
  629007
  630801
  638052
  648524
  653520
  665649
  689483
  689964
  699480
  709306
  720422
  747195
  747228
  764485
  775587
  784735
  814697
  817073
  817182
  824051
]
2.40 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "slave girl bondage"
]
2.10 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "доминирован девушк бдсм"
]
1.60 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.96%)
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.