Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
117.32 ms
(81.44%)
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
  432227
  437845
  444329
  448041
  448282
  455095
  455100
  455105
  455108
  461516
  461520
  461526
  461535
  461545
  461549
  461552
  461566
  462045
  462052
  462805
  467844
  472334
  472347
  472350
  472353
  473685
  476213
  478923
  487069
  487080
  487086
  487088
  487089
  487114
  491199
  491659
  491671
  500926
  508804
  508827
  508876
  508881
  510618
  511709
  511720
  511730
  511750
  512239
  512244
  512280
  512297
  512323
  512335
  512900
  517574
  522590
  524697
  524708
  524724
  524732
  527623
  527807
  544337
  552116
  552142
  558858
  558946
  560464
  560476
  560629
  562209
  562320
  565449
  567633
  573453
  573773
  573775
  574509
  574600
  574810
  574829
  574843
  574871
  574885
  575120
  575148
  575453
  575520
  575758
  575805
  576026
  576053
  576351
  606690
  606694
  654617
  654619
  654717
  654771
  654783
  655358
  656048
  656361
  656465
  656686
  656708
  656751
  657074
  657287
  657420
  657434
  658014
  658656
  659161
  659642
  659669
  659842
  669344
  696178
  705118
]
17.60 ms
(12.21%)
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
  476213
  455108
  472353
  508876
  491199
  544337
  657420
  657434
  654717
  659642
  669344
  654619
  656361
  656751
  658014
  437845
  657074
  658656
  659161
  656048
  567633
  573453
  467844
  511750
  491659
  508804
  512244
  576053
  448282
  478923
  472350
  511709
  511720
  512280
  552142
  560476
  565449
  573773
  574885
  575805
  576026
  573775
  574509
  575453
  552116
  560464
  562209
  574600
  574810
  574871
  575520
  575758
  696178
  558858
  558946
  560629
  562320
  574843
  575148
  576351
  606690
  606694
  705118
  455095
  462052
  473685
  472334
  455100
  461520
  461526
  461535
  461549
  461552
  461566
  462805
  432227
  444329
  448041
  455105
  462045
  472347
  461516
  461545
  512323
  522590
  527623
  487086
  500926
  511730
  512335
  517574
  487069
  508881
  510618
  512297
  487080
  487089
  487114
  491671
  508827
  512239
  524697
  524708
  524724
  524732
  527807
  656708
  657287
  654617
  659842
  655358
  656465
  656686
  659669
  487088
  512900
  574829
  575120
  654771
  654783
]
2.37 ms
(1.65%)
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
  432227
  437845
  444329
  448041
  448282
  455095
  455100
  455105
  455108
  461516
  461520
  461526
  461535
  461545
  461549
  461552
  461566
  462045
  462052
  462805
  467844
  472334
  472347
  472350
  472353
  473685
  476213
  478923
  487069
  487080
  487086
  487088
  487089
  487114
  491199
  491659
  491671
  500926
  508804
  508827
  508876
  508881
  510618
  511709
  511720
  511730
  511750
  512239
  512244
  512280
  512297
  512323
  512335
  512900
  517574
  522590
  524697
  524708
  524724
  524732
  527623
  527807
  544337
  552116
  552142
  558858
  558946
  560464
  560476
  560629
  562209
  562320
  565449
  567633
  573453
  573773
  573775
  574509
  574600
  574810
  574829
  574843
  574871
  574885
  575120
  575148
  575453
  575520
  575758
  575805
  576026
  576053
  576351
  606690
  606694
  654617
  654619
  654717
  654771
  654783
  655358
  656048
  656361
  656465
  656686
  656708
  656751
  657074
  657287
  657420
  657434
  658014
  658656
  659161
  659642
  659669
  659842
  669344
  696178
  705118
]
1.87 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "куколд 18 летние"
]
1.80 ms
(1.25%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "куколд 18 19 лет"
]
1.42 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "куколд 18 19 лет"
]

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.