Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.43 ms
(82.90%)
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
  385676
  388845
  390455
  392170
  401944
  408085
  416839
  417343
  419421
  424376
  427262
  427942
  430377
  434741
  440655
  441546
  444698
  445093
  445605
  446611
  448313
  450312
  451890
  451990
  452070
  452223
  453190
  453539
  454640
  456893
  457563
  457578
  457735
  467735
  469590
  469618
  469704
  470848
  471170
  471442
  472332
  476227
  476460
  476468
  476564
  479207
  480597
  481557
  481751
  482490
  484010
  484075
  484161
  484163
  484506
  487045
  488543
  489087
  490586
  492289
  493547
  497034
  497236
  499720
  500114
  503792
  504024
  508436
  511259
  514942
  518223
  519374
  522856
  523047
  525062
  526019
  527435
  527601
  532355
  533313
  541558
  542456
  545365
  545965
  547717
  548316
  552955
  555995
  556401
  561509
  561600
  562364
  563333
  565362
  567086
  567563
  568077
  569632
  582235
  585163
  586086
  591149
  599227
  601543
  603652
  606636
  607244
  628730
  633155
  633408
  643315
  649905
  668005
  690410
  691598
  725527
  746006
  768390
  789846
  821352
]
19.15 ms
(11.64%)
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
  444698
  552955
  487045
  479207
  385676
  469590
  484506
  457563
  481751
  525062
  522856
  561509
  643315
  633408
  419421
  448313
  392170
  821352
  453539
  503792
  508436
  514942
  500114
  527435
  541558
  562364
  567086
  591149
  601543
  526019
  527601
  452223
  499720
  519374
  569632
  691598
  649905
  545365
  561600
  606636
  607244
  725527
  768390
  789846
  416839
  417343
  490586
  482490
  511259
  585163
  430377
  497034
  427262
  476468
  472332
  388845
  408085
  424376
  469618
  451890
  469704
  532355
  471170
  457578
  476460
  440655
  467735
  401944
  427942
  484163
  493547
  492289
  390455
  450312
  484075
  476564
  504024
  497236
  563333
  567563
  690410
  668005
  633155
  452070
  488543
  470848
  568077
  582235
  545965
  548316
  542456
  555995
  586086
  746006
  446611
  489087
  445605
  547717
  456893
  471442
  441546
  445093
  454640
  484161
  453190
  481557
  523047
  476227
  484010
  451990
  480597
  556401
  457735
  518223
  533313
  565362
  599227
  603652
  628730
  434741
]
2.83 ms
(1.72%)
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
  385676
  388845
  390455
  392170
  401944
  408085
  416839
  417343
  419421
  424376
  427262
  427942
  430377
  434741
  440655
  441546
  444698
  445093
  445605
  446611
  448313
  450312
  451890
  451990
  452070
  452223
  453190
  453539
  454640
  456893
  457563
  457578
  457735
  467735
  469590
  469618
  469704
  470848
  471170
  471442
  472332
  476227
  476460
  476468
  476564
  479207
  480597
  481557
  481751
  482490
  484010
  484075
  484161
  484163
  484506
  487045
  488543
  489087
  490586
  492289
  493547
  497034
  497236
  499720
  500114
  503792
  504024
  508436
  511259
  514942
  518223
  519374
  522856
  523047
  525062
  526019
  527435
  527601
  532355
  533313
  541558
  542456
  545365
  545965
  547717
  548316
  552955
  555995
  556401
  561509
  561600
  562364
  563333
  565362
  567086
  567563
  568077
  569632
  582235
  585163
  586086
  591149
  599227
  601543
  603652
  606636
  607244
  628730
  633155
  633408
  643315
  649905
  668005
  690410
  691598
  725527
  746006
  768390
  789846
  821352
]
1.85 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big boobs outdoor"
]
1.58 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие boobs outdoor"
]
1.45 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.28 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие boobs outdoor"
]

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.