Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.19 ms
(84.75%)
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
  384133
  395584
  399931
  400550
  401014
  401185
  401958
  402599
  403236
  405261
  407664
  411755
  412772
  419711
  428466
  429824
  432351
  439709
  447862
  449089
  469366
  486008
  513114
  513629
  524473
  524480
  532587
  533515
  542421
  543025
  544269
  545292
  549956
  553354
  556641
  561026
  561598
  564697
  565337
  566860
  569727
  569954
  580133
  582348
  587232
  590318
  591020
  591688
  591715
  593194
  594110
  594491
  599115
  604404
  607102
  641687
  644323
  649832
  650843
  651005
  651665
  681012
  681131
  690020
  692116
  698224
  710548
  718497
  721748
  724352
  726621
  726675
  727834
  742839
  745452
  752715
  765023
  765934
  766441
  770167
  772928
  773342
  774163
  775355
  777361
  779224
  781164
  781457
  782935
  786040
  787274
  789716
  789735
  791034
  791504
  793294
  799224
  800206
  801081
  802112
  802783
  805541
  805607
  811277
  812833
  813445
  813651
  814288
  815231
  816719
  816838
  817292
  818177
  818204
  818469
  818609
  820793
  826543
  828871
]
15.85 ms
(9.31%)
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
  781164
  802112
  727834
  726675
  791504
  400550
  411755
  399931
  826543
  818204
  828871
  544269
  789716
  789735
  774163
  384133
  564697
  556641
  698224
  793294
  742839
  765023
  726621
  721748
  779224
  401014
  407664
  439709
  513114
  395584
  402599
  403236
  818177
  486008
  524480
  532587
  580133
  649832
  681012
  582348
  590318
  607102
  587232
  591688
  775355
  782935
  800206
  786040
  805607
  811277
  812833
  766441
  787274
  765934
  772928
  724352
  644323
  777361
  401958
  419711
  412772
  432351
  428466
  524473
  816838
  820793
  813651
  816719
  817292
  828044
  543025
  651665
  692116
  781457
  745452
  799224
  813445
  818469
  818609
  815231
  533515
  549956
  542421
  561598
  569727
  651005
  718497
  770167
  752715
  773342
  447862
  545292
  690020
  650843
  561026
  604404
  641687
  594491
  591020
  591715
  791034
  805541
  405261
  401185
  513629
  429824
  814288
  449089
  469366
  553354
  565337
  566860
  569954
  681131
  710548
  593194
  594110
  599115
  802783
  801081
]
2.36 ms
(1.39%)
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
  384133
  395584
  399931
  400550
  401014
  401185
  401958
  402599
  403236
  405261
  407664
  411755
  412772
  419711
  428466
  429824
  432351
  439709
  447862
  449089
  469366
  486008
  513114
  513629
  524473
  524480
  532587
  533515
  542421
  543025
  544269
  545292
  549956
  553354
  556641
  561026
  561598
  564697
  565337
  566860
  569727
  569954
  580133
  582348
  587232
  590318
  591020
  591688
  591715
  593194
  594110
  594491
  599115
  604404
  607102
  641687
  644323
  649832
  650843
  651005
  651665
  681012
  681131
  690020
  692116
  698224
  710548
  718497
  721748
  724352
  726621
  726675
  727834
  742839
  745452
  752715
  765023
  765934
  766441
  770167
  772928
  773342
  774163
  775355
  777361
  779224
  781164
  781457
  782935
  786040
  787274
  789716
  789735
  791034
  791504
  793294
  799224
  800206
  801081
  802112
  802783
  805541
  805607
  811277
  812833
  813445
  813651
  814288
  815231
  816719
  816838
  817292
  818177
  818204
  818469
  818609
  820793
  826543
  828871
]
2.11 ms
(1.24%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.10 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "brunette mom"
]
1.91 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "черноволосая mom"
]
1.64 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "черноволосая mom"
]

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.