Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.32 ms
(84.89%)
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
  73947
  152544
  161969
  172541
  260590
  307352
  321297
  379578
  385682
  398702
  400727
  402928
  404083
  449272
  533335
  536133
  538016
  572434
  573912
  577677
  588665
  617179
  628295
  634064
  641439
  644338
  652262
  656796
  668397
  668887
  669646
  677735
  686044
  688639
  697754
  704409
  710542
  713983
  716407
  718497
  722517
  723555
  724705
  726449
  726833
  726850
  727757
  728176
  728502
  728900
  734366
  734415
  736327
  743548
  744148
  744830
  746660
  751756
  752040
  757282
  757526
  760634
  772603
  780372
  782757
  784204
  788717
  792204
  792231
  792939
  793322
  794518
  795006
  795025
  797024
  797606
  798871
  801905
  803085
  803564
  807997
  809701
  810655
  812924
  813655
  815766
  817134
  817296
  817360
  817517
  817554
  817835
  818034
  818144
  818482
  818575
  818588
  818836
  819012
  819076
  819080
  819439
  819507
  820198
  820342
  820681
  820688
  820750
  822881
  823157
  824437
  824497
  824711
  825065
  825752
  826409
  826736
  827198
  827960
  827974
]
17.00 ms
(9.79%)
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
  824497
  826409
  819080
  819439
  824437
  824711
  825065
  449272
  536133
  538016
  533335
  577677
  573912
  688639
  704409
  713983
  718497
  652262
  656796
  668397
  686044
  628295
  644338
  634064
  617179
  588665
  641439
  782757
  792939
  794518
  757282
  772603
  793322
  795006
  795025
  734415
  728176
  743548
  728900
  734366
  744148
  744830
  746660
  726449
  728502
  760634
  697754
  780372
  792204
  792231
  797024
  798871
  803564
  807997
  400727
  404083
  402928
  152544
  172541
  260590
  817517
  817554
  818482
  723555
  813655
  819012
  817134
  820750
  822881
  823157
  817360
  819507
  827974
  827960
  572434
  677735
  722517
  669646
  716407
  668887
  809701
  801905
  812924
  727757
  784204
  724705
  726833
  736327
  726850
  752040
  751756
  757526
  710542
  797606
  803085
  810655
  161969
  307352
  379578
  788717
  321297
  385682
  73947
  398702
  815766
  817296
  817835
  818034
  818575
  818836
  819076
  820688
  825752
  826736
  818144
  818588
  820198
  820342
  820681
  827198
]
2.65 ms
(1.53%)
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
  73947
  152544
  161969
  172541
  260590
  307352
  321297
  379578
  385682
  398702
  400727
  402928
  404083
  449272
  533335
  536133
  538016
  572434
  573912
  577677
  588665
  617179
  628295
  634064
  641439
  644338
  652262
  656796
  668397
  668887
  669646
  677735
  686044
  688639
  697754
  704409
  710542
  713983
  716407
  718497
  722517
  723555
  724705
  726449
  726833
  726850
  727757
  728176
  728502
  728900
  734366
  734415
  736327
  743548
  744148
  744830
  746660
  751756
  752040
  757282
  757526
  760634
  772603
  780372
  782757
  784204
  788717
  792204
  792231
  792939
  793322
  794518
  795006
  795025
  797024
  797606
  798871
  801905
  803085
  803564
  807997
  809701
  810655
  812924
  813655
  815766
  817134
  817296
  817360
  817517
  817554
  817835
  818034
  818144
  818482
  818575
  818588
  818836
  819012
  819076
  819080
  819439
  819507
  820198
  820342
  820681
  820688
  820750
  822881
  823157
  824437
  824497
  824711
  825065
  825752
  826409
  826736
  827198
  827960
  827974
]
1.74 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс лиза"
]
1.67 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ебет потом лижет"
]
1.66 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс лиза"
]
1.50 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.