Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
179.38 ms
(87.94%)
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
  233335
  385288
  385816
  389979
  396408
  397843
  402261
  416163
  418132
  419155
  420322
  421346
  426666
  426984
  428027
  429125
  432395
  432396
  432412
  432464
  433433
  433676
  435620
  452538
  453011
  457749
  460354
  460356
  460507
  461955
  465830
  465835
  465882
  465921
  466045
  469157
  478693
  480091
  486329
  503877
  505992
  534475
  536084
  536100
  552112
  560334
  561917
  565831
  572917
  578328
  580027
  591420
  616989
  617778
  618808
  627154
  627181
  636719
  638840
  662833
  677847
  698619
  698782
  703944
  714395
  721738
  725889
  728996
  731456
  734703
  736886
  739156
  740578
  742330
  744346
  745006
  745081
  746575
  749538
  750224
  750401
  750552
  752336
  756277
  756480
  756702
  757514
  758906
  760624
  760688
  760934
  761575
  766051
  767548
  767989
  768697
  768888
  769366
  770236
  771049
  771353
  772168
  772243
  772635
  776032
  777264
  777731
  777767
  779070
  781051
  782106
  788485
  790500
  791036
  793099
  796476
  796994
  802944
  806764
  811103
]
14.94 ms
(7.32%)
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
  767548
  770236
  771049
  771353
  745081
  749538
  750224
  750552
  758906
  760934
  728996
  740578
  742330
  746575
  752336
  756702
  766051
  768888
  769366
  725889
  734703
  736886
  745006
  750401
  756277
  760624
  760688
  761575
  772168
  772243
  772635
  617778
  627181
  698619
  698782
  777264
  777731
  777767
  779070
  781051
  782106
  790500
  796994
  802944
  806764
  466045
  402261
  233335
  385816
  429125
  461955
  433433
  421346
  416163
  428027
  435620
  418132
  480091
  457749
  505992
  536084
  503877
  536100
  534475
  486329
  552112
  565831
  580027
  572917
  560334
  561917
  578328
  677847
  703944
  714395
  662833
  721738
  616989
  636719
  618808
  591420
  638840
  788485
  776032
  793099
  796476
  731456
  744346
  757514
  739156
  756480
  767989
  768697
  627154
  791036
  811103
  426666
  432395
  432464
  453011
  460356
  465830
  478693
  385288
  389979
  420322
  433676
  460507
  465835
  465882
  465921
  469157
  396408
  397843
  432412
  460354
  419155
  426984
  432396
  452538
]
2.60 ms
(1.27%)
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
  233335
  385288
  385816
  389979
  396408
  397843
  402261
  416163
  418132
  419155
  420322
  421346
  426666
  426984
  428027
  429125
  432395
  432396
  432412
  432464
  433433
  433676
  435620
  452538
  453011
  457749
  460354
  460356
  460507
  461955
  465830
  465835
  465882
  465921
  466045
  469157
  478693
  480091
  486329
  503877
  505992
  534475
  536084
  536100
  552112
  560334
  561917
  565831
  572917
  578328
  580027
  591420
  616989
  617778
  618808
  627154
  627181
  636719
  638840
  662833
  677847
  698619
  698782
  703944
  714395
  721738
  725889
  728996
  731456
  734703
  736886
  739156
  740578
  742330
  744346
  745006
  745081
  746575
  749538
  750224
  750401
  750552
  752336
  756277
  756480
  756702
  757514
  758906
  760624
  760688
  760934
  761575
  766051
  767548
  767989
  768697
  768888
  769366
  770236
  771049
  771353
  772168
  772243
  772635
  776032
  777264
  777731
  777767
  779070
  781051
  782106
  788485
  790500
  791036
  793099
  796476
  796994
  802944
  806764
  811103
]
2.04 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в колготках молодые и%…"
]
1.75 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "колготк молодые"
]
1.74 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.75%)
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.