Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.28 ms
(81.69%)
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
  34394
  187252
  191511
  194309
  199188
  259942
  377287
  383567
  387436
  389697
  391156
  400807
  411572
  450165
  453100
  454225
  454267
  455005
  455910
  458126
  459830
  459919
  461016
  462130
  462315
  463803
  463825
  466077
  466997
  467036
  467039
  467043
  471589
  474874
  475080
  475294
  476257
  476260
  480480
  480745
  483355
  483368
  485458
  485727
  485733
  485752
  486816
  487933
  498217
  498300
  498722
  504823
  510813
  511424
  513785
  514823
  516053
  518730
  518774
  518864
  518869
  519143
  519151
  522594
  524887
  525138
  525492
  525511
  529323
  530555
  533459
  537942
  549245
  549583
  550636
  558299
  563779
  565931
  567427
  577662
  588519
  589575
  605076
  607132
  612987
  667486
  678778
  678790
  678791
  678804
  693308
  696317
  698765
  705887
  710264
  713941
  719900
  732959
  733471
  733481
  734113
  736000
  738305
  738339
  738343
  744345
  745336
  758762
  770898
  772875
  773884
  775972
  779593
  781965
  789207
  794750
  802326
  810775
  811094
  812521
]
17.43 ms
(11.55%)
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
  525138
  483368
  474874
  504823
  537942
  475294
  525511
  483355
  463803
  475080
  476257
  485458
  485727
  463825
  471589
  450165
  467039
  476260
  485733
  529323
  498300
  518774
  459919
  466997
  549583
  667486
  565931
  567427
  589575
  607132
  810775
  480480
  519151
  485752
  513785
  518730
  519143
  487933
  518864
  518869
  462315
  467043
  732959
  383567
  772875
  736000
  734113
  775972
  455910
  461016
  510813
  524887
  522594
  525492
  678791
  453100
  400807
  466077
  454225
  454267
  516053
  678804
  693308
  705887
  612987
  738305
  745336
  387436
  259942
  34394
  713941
  811094
  744345
  794750
  812521
  733471
  738343
  779593
  187252
  389697
  486816
  455005
  467036
  480745
  549245
  678778
  678790
  391156
  498722
  459830
  514823
  199188
  550636
  194309
  411572
  462130
  511424
  533459
  498217
  588519
  458126
  191511
  530555
  558299
  563779
  710264
  696317
  698765
  577662
  789207
  770898
  773884
  758762
  733481
  738339
  605076
  719900
  781965
  802326
  377287
]
3.10 ms
(2.06%)
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
  34394
  187252
  191511
  194309
  199188
  259942
  377287
  383567
  387436
  389697
  391156
  400807
  411572
  450165
  453100
  454225
  454267
  455005
  455910
  458126
  459830
  459919
  461016
  462130
  462315
  463803
  463825
  466077
  466997
  467036
  467039
  467043
  471589
  474874
  475080
  475294
  476257
  476260
  480480
  480745
  483355
  483368
  485458
  485727
  485733
  485752
  486816
  487933
  498217
  498300
  498722
  504823
  510813
  511424
  513785
  514823
  516053
  518730
  518774
  518864
  518869
  519143
  519151
  522594
  524887
  525138
  525492
  525511
  529323
  530555
  533459
  537942
  549245
  549583
  550636
  558299
  563779
  565931
  567427
  577662
  588519
  589575
  605076
  607132
  612987
  667486
  678778
  678790
  678791
  678804
  693308
  696317
  698765
  705887
  710264
  713941
  719900
  732959
  733471
  733481
  734113
  736000
  738305
  738339
  738343
  744345
  745336
  758762
  770898
  772875
  773884
  775972
  779593
  781965
  789207
  794750
  802326
  810775
  811094
  812521
]
2.08 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "старухи в порн"
]
1.81 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "бабушк в порн"
]
1.49 ms
(0.98%)
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.