Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.49 ms
(82.52%)
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
  39719
  381966
  385288
  389979
  396408
  397843
  410847
  416163
  418132
  419155
  420322
  421290
  421346
  421990
  422910
  426666
  426984
  428027
  429386
  432395
  432396
  432412
  432461
  432464
  432511
  432622
  433352
  433385
  433415
  433676
  435620
  441427
  452364
  452538
  453011
  457749
  460354
  460356
  460507
  460868
  461836
  462027
  465830
  465835
  465882
  465915
  465921
  468240
  469157
  469632
  473465
  477476
  478693
  479677
  480091
  482588
  482647
  483240
  486329
  488160
  491949
  491977
  491981
  493308
  498648
  500149
  500549
  500890
  503877
  505992
  509340
  512515
  520739
  523893
  526069
  534393
  534475
  536084
  536100
  552112
  554645
  556201
  558636
  560334
  561917
  565831
  569648
  570833
  572917
  578328
  580027
  584440
  591420
  616989
  618808
  626642
  627154
  636719
  638840
  651700
  662833
  677847
  703944
  714395
  721738
  728169
  731456
  739156
  744346
  756480
  757514
  767989
  768697
  776032
  788485
  791036
  793099
  796476
  811103
  814206
]
14.83 ms
(10.24%)
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
  491977
  512515
  491981
  421346
  416163
  428027
  435620
  418132
  814206
  480091
  457749
  505992
  536084
  503877
  536100
  534475
  486329
  552112
  565831
  580027
  572917
  560334
  561917
  578328
  677847
  703944
  714395
  662833
  721738
  616989
  636719
  618808
  591420
  626642
  638840
  788485
  776032
  793099
  796476
  731456
  744346
  757514
  739156
  756480
  767989
  768697
  627154
  791036
  811103
  381966
  426666
  432395
  432464
  453011
  460356
  465830
  478693
  385288
  389979
  420322
  421990
  433676
  460507
  465835
  465882
  465921
  469157
  396408
  397843
  432412
  460354
  419155
  426984
  432396
  452538
  465915
  433352
  433385
  433415
  469632
  473465
  500149
  500549
  500890
  488160
  491949
  498648
  523893
  483240
  534393
  728169
  520739
  429386
  39719
  432511
  441427
  421290
  432461
  410847
  422910
  432622
  482647
  460868
  461836
  477476
  482588
  452364
  509340
  526069
  462027
  468240
  479677
  493308
  554645
  569648
  570833
  558636
  584440
  556201
  651700
]
2.89 ms
(2.00%)
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
  39719
  381966
  385288
  389979
  396408
  397843
  410847
  416163
  418132
  419155
  420322
  421290
  421346
  421990
  422910
  426666
  426984
  428027
  429386
  432395
  432396
  432412
  432461
  432464
  432511
  432622
  433352
  433385
  433415
  433676
  435620
  441427
  452364
  452538
  453011
  457749
  460354
  460356
  460507
  460868
  461836
  462027
  465830
  465835
  465882
  465915
  465921
  468240
  469157
  469632
  473465
  477476
  478693
  479677
  480091
  482588
  482647
  483240
  486329
  488160
  491949
  491977
  491981
  493308
  498648
  500149
  500549
  500890
  503877
  505992
  509340
  512515
  520739
  523893
  526069
  534393
  534475
  536084
  536100
  552112
  554645
  556201
  558636
  560334
  561917
  565831
  569648
  570833
  572917
  578328
  580027
  584440
  591420
  616989
  618808
  626642
  627154
  636719
  638840
  651700
  662833
  677847
  703944
  714395
  721738
  728169
  731456
  739156
  744346
  756480
  757514
  767989
  768697
  776032
  788485
  791036
  793099
  796476
  811103
  814206
]
2.03 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "молодые в колготках и%…"
]
1.89 ms
(1.30%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "молодые колготк"
]
1.84 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(1.26%)
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.