Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.29 ms
(79.40%)
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
  157194
  387490
  396397
  411846
  411848
  423633
  432650
  452282
  452283
  453161
  459835
  469272
  472914
  480411
  502283
  511391
  513032
  519230
  522342
  522863
  522875
  522898
  522918
  524949
  537614
  538681
  538949
  541587
  541588
  541632
  541633
  541635
  541646
  541656
  541688
  541699
  541804
  541831
  541833
  541871
  541888
  542195
  542954
  543478
  543496
  544472
  544478
  549314
  549976
  550831
  551225
  551919
  556785
  559123
  559378
  560077
  560924
  561028
  562831
  562836
  562840
  565423
  566503
  566684
  566702
  573763
  574258
  576638
  576653
  576686
  576703
  576710
  576712
  576723
  576726
  577357
  577363
  579345
  580579
  581295
  583581
  583837
  588211
  592003
  592388
  592444
  592450
  592492
  593365
  598348
  603273
  605345
  610047
  614745
  615743
  615748
  619483
  620148
  620153
  622364
  629898
  631058
  632502
  648204
  670951
  671764
  690832
  708468
  709654
  711907
  721611
  726881
  732823
  736241
  761323
  778541
  799091
  801907
  814646
  821422
]
26.49 ms
(15.10%)
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
  541688
  541635
  562836
  579345
  550831
  588211
  561028
  711907
  708468
  670951
  605345
  551919
  565423
  542195
  576653
  541588
  549976
  566503
  562840
  544478
  619483
  736241
  761323
  541833
  551225
  556785
  541699
  459835
  396397
  541804
  541656
  560924
  576638
  566702
  541871
  411848
  537614
  574258
  541632
  541831
  814646
  709654
  502283
  799091
  721611
  566684
  387490
  541587
  778541
  541646
  560077
  432650
  821422
  592450
  629898
  541888
  576726
  541633
  603273
  543496
  580579
  522875
  726881
  469272
  576710
  562831
  538681
  411846
  732823
  511391
  480411
  577363
  690832
  610047
  592003
  622364
  801907
  576723
  583581
  576703
  592388
  522918
  671764
  615743
  573763
  593365
  542954
  472914
  544472
  614745
  522863
  538949
  583837
  576712
  592492
  598348
  632502
  453161
  452282
  559378
  157194
  577357
  549314
  581295
  620153
  648204
  631058
  522898
  615748
  452283
  423633
  522342
  576686
  559123
  592444
  620148
  513032
  519230
  524949
  543478
]
3.36 ms
(1.91%)
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
  157194
  387490
  396397
  411846
  411848
  423633
  432650
  452282
  452283
  453161
  459835
  469272
  472914
  480411
  502283
  511391
  513032
  519230
  522342
  522863
  522875
  522898
  522918
  524949
  537614
  538681
  538949
  541587
  541588
  541632
  541633
  541635
  541646
  541656
  541688
  541699
  541804
  541831
  541833
  541871
  541888
  542195
  542954
  543478
  543496
  544472
  544478
  549314
  549976
  550831
  551225
  551919
  556785
  559123
  559378
  560077
  560924
  561028
  562831
  562836
  562840
  565423
  566503
  566684
  566702
  573763
  574258
  576638
  576653
  576686
  576703
  576710
  576712
  576723
  576726
  577357
  577363
  579345
  580579
  581295
  583581
  583837
  588211
  592003
  592388
  592444
  592450
  592492
  593365
  598348
  603273
  605345
  610047
  614745
  615743
  615748
  619483
  620148
  620153
  622364
  629898
  631058
  632502
  648204
  670951
  671764
  690832
  708468
  709654
  711907
  721611
  726881
  732823
  736241
  761323
  778541
  799091
  801907
  814646
  821422
]
2.03 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "фильм анал с мамой"
]
1.55 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фильм анал мам женщин"
]
1.52 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.20 ms
(0.69%)
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.