Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.81 ms
(82.04%)
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
  414368
  516686
  517743
  517842
  519567
  530010
  530015
  530275
  530384
  530489
  530791
  530941
  531089
  531202
  531232
  531235
  531419
  532172
  532343
  532653
  532737
  532790
  532995
  533382
  533697
  534647
  535054
  536291
  536584
  536586
  537203
  537771
  537932
  541846
  550194
  553272
  582323
  590411
  596082
  599847
  599890
  599914
  599988
  599994
  600185
  600268
  600295
  600321
  600334
  600342
  600352
  600354
  600355
  601046
  601600
  601625
  617416
  617428
  621656
  631178
  632600
  632646
  632659
  632690
  633111
  633741
  633799
  636299
  636303
  636304
  636309
  636991
  637434
  639717
  639784
  639790
  640767
  641678
  642002
  642018
  642066
  643376
  644918
  646025
  646175
  646448
  646771
  646786
  646904
  647939
  648795
  648815
  648868
  650175
  651079
  666586
  666853
  666892
  668526
  668534
  676016
  676092
  676623
  676632
  677303
  677674
  677676
  678053
  678063
  678493
  678514
  678529
  679728
  680130
  683261
  703833
  708441
  708447
  716870
  716887
]
16.99 ms
(10.74%)
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
  646175
  650175
  676092
  600354
  643376
  617416
  414368
  530010
  531232
  532790
  537771
  530489
  532737
  536586
  530015
  533697
  679728
  651079
  646904
  648815
  632600
  601625
  600352
  636303
  600295
  600342
  640767
  517842
  519567
  646448
  532172
  532653
  596082
  599994
  600334
  677303
  633741
  517743
  666853
  678493
  678529
  641678
  632659
  633799
  537203
  676632
  648868
  708441
  708447
  600185
  642002
  642018
  633111
  639717
  536291
  644918
  530384
  531202
  532343
  535054
  530791
  531089
  531235
  531419
  582323
  541846
  646025
  646771
  648795
  677674
  678063
  678514
  683261
  646786
  666586
  676623
  599890
  639784
  600321
  601600
  642066
  599914
  600355
  636304
  636299
  637434
  639790
  631178
  632690
  636309
  703833
  716887
  680130
  590411
  534647
  537932
  716870
  636991
  533382
  530941
  550194
  668526
  668534
  647939
  621656
  601046
  600268
  617428
  632646
  516686
  599988
  553272
  676016
  536584
  530275
  532995
  599847
  678053
  666892
  677676
]
3.07 ms
(1.94%)
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
  414368
  516686
  517743
  517842
  519567
  530010
  530015
  530275
  530384
  530489
  530791
  530941
  531089
  531202
  531232
  531235
  531419
  532172
  532343
  532653
  532737
  532790
  532995
  533382
  533697
  534647
  535054
  536291
  536584
  536586
  537203
  537771
  537932
  541846
  550194
  553272
  582323
  590411
  596082
  599847
  599890
  599914
  599988
  599994
  600185
  600268
  600295
  600321
  600334
  600342
  600352
  600354
  600355
  601046
  601600
  601625
  617416
  617428
  621656
  631178
  632600
  632646
  632659
  632690
  633111
  633741
  633799
  636299
  636303
  636304
  636309
  636991
  637434
  639717
  639784
  639790
  640767
  641678
  642002
  642018
  642066
  643376
  644918
  646025
  646175
  646448
  646771
  646786
  646904
  647939
  648795
  648815
  648868
  650175
  651079
  666586
  666853
  666892
  668526
  668534
  676016
  676092
  676623
  676632
  677303
  677674
  677676
  678053
  678063
  678493
  678514
  678529
  679728
  680130
  683261
  703833
  708441
  708447
  716870
  716887
]
2.33 ms
(1.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кастинг милф групповуха"
]
2.10 ms
(1.33%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.03 ms
(1.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "кастинг милф группов секс"
]
1.90 ms
(1.20%)
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.