Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
222.21 ms
(90.22%)
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
  78479
  191759
  263548
  385581
  391473
  402630
  415827
  420200
  422300
  424146
  425279
  448532
  449712
  453912
  455321
  456879
  456995
  457245
  462064
  462329
  465223
  469402
  469693
  471011
  472267
  475877
  476725
  477621
  478394
  485383
  486365
  489117
  491125
  492967
  493448
  495855
  500088
  505755
  509199
  510327
  511611
  517389
  522525
  527739
  531840
  535176
  535331
  538674
  542760
  543923
  546513
  555560
  563015
  582556
  592936
  600422
  603005
  605916
  617240
  617369
  618260
  619892
  623399
  631514
  635752
  640663
  644217
  652669
  652788
  666433
  671681
  675437
  694194
  697216
  697628
  700885
  710297
  710424
  714707
  718393
  721936
  722113
  726150
  726399
  726957
  726994
  727460
  728517
  729121
  729268
  734467
  734578
  736285
  736893
  747291
  757215
  761119
  762448
  763348
  763583
  768676
  773437
  775165
  788508
  794744
  795315
  795787
  796148
  798277
  801014
  801476
  804674
  806762
  810330
  812854
  813946
  817249
  824220
  824883
  824973
]
13.82 ms
(5.61%)
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
  517389
  455321
  824973
  631514
  726150
  768676
  773437
  722113
  795787
  453912
  535176
  652669
  592936
  617369
  812854
  736285
  736893
  617240
  804674
  492967
  191759
  402630
  456995
  472267
  509199
  563015
  555560
  666433
  714707
  546513
  603005
  605916
  806762
  795315
  798277
  726399
  726957
  728517
  747291
  763348
  761119
  618260
  788508
  794744
  801014
  801476
  391473
  78479
  263548
  493448
  824220
  700885
  619892
  763583
  810330
  729121
  734467
  640663
  775165
  476725
  385581
  465223
  462064
  485383
  478394
  471011
  510327
  535331
  489117
  491125
  420200
  457245
  462329
  456879
  495855
  538674
  582556
  600422
  729268
  762448
  475877
  500088
  425279
  424146
  511611
  469402
  486365
  671681
  718393
  675437
  694194
  623399
  635752
  796148
  734578
  726994
  727460
  757215
  697628
  415827
  469693
  449712
  505755
  527739
  710424
  422300
  542760
  543923
  448532
  522525
  813946
  817249
  824883
  477621
  531840
  697216
  710297
  652788
  721936
  644217
]
2.90 ms
(1.18%)
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
  78479
  191759
  263548
  385581
  391473
  402630
  415827
  420200
  422300
  424146
  425279
  448532
  449712
  453912
  455321
  456879
  456995
  457245
  462064
  462329
  465223
  469402
  469693
  471011
  472267
  475877
  476725
  477621
  478394
  485383
  486365
  489117
  491125
  492967
  493448
  495855
  500088
  505755
  509199
  510327
  511611
  517389
  522525
  527739
  531840
  535176
  535331
  538674
  542760
  543923
  546513
  555560
  563015
  582556
  592936
  600422
  603005
  605916
  617240
  617369
  618260
  619892
  623399
  631514
  635752
  640663
  644217
  652669
  652788
  666433
  671681
  675437
  694194
  697216
  697628
  700885
  710297
  710424
  714707
  718393
  721936
  722113
  726150
  726399
  726957
  726994
  727460
  728517
  729121
  729268
  734467
  734578
  736285
  736893
  747291
  757215
  761119
  762448
  763348
  763583
  768676
  773437
  775165
  788508
  794744
  795315
  795787
  796148
  798277
  801014
  801476
  804674
  806762
  810330
  812854
  813946
  817249
  824220
  824883
  824973
]
2.14 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam sex milf"
]
2.03 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(0.66%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер секс milf"
]
1.55 ms
(0.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вебкамер секс milf"
]

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.