Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.12 ms
(83.24%)
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
  382948
  389317
  458571
  469035
  469765
  529703
  530411
  531992
  533178
  538834
  542202
  545154
  545923
  545980
  551719
  557486
  564279
  582197
  586566
  588562
  589136
  603425
  607435
  618380
  623912
  625907
  628358
  629743
  637801
  638485
  662030
  663212
  666409
  668082
  669867
  669989
  670770
  679708
  681074
  681122
  683668
  687691
  694569
  700385
  704731
  705358
  708828
  713614
  714332
  714453
  716160
  716805
  721562
  721707
  721751
  727910
  733334
  739176
  749016
  763604
  769382
  771867
  775100
  776954
  777197
  779202
  786598
  788403
  789174
  794709
  796503
  797206
  800140
  800414
  801389
  801859
  803270
  805113
  805123
  805957
  807451
  807869
  808608
  811274
  813693
  813950
  814114
  814578
  814610
  815402
  816584
  816659
  817315
  817355
  817527
  817872
  818429
  818434
  818514
  818743
  819225
  819477
  819486
  819735
  820131
  821773
  821916
  824409
  824509
  824737
  825070
  825472
  825936
  826017
  826057
  826211
  826316
  827115
  827316
  828712
]
16.04 ms
(10.18%)
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
  800414
  801389
  382948
  681074
  807869
  557486
  586566
  582197
  669989
  714332
  668082
  714453
  797206
  776954
  749016
  807451
  769382
  771867
  458571
  663212
  389317
  681122
  803270
  811274
  763604
  469765
  814114
  814610
  815402
  816584
  817872
  818429
  818434
  818514
  819225
  825936
  826017
  826316
  826211
  816659
  819735
  820131
  824409
  826057
  827115
  827316
  813693
  813950
  817527
  819477
  821773
  824509
  825472
  814578
  817315
  817355
  818743
  819486
  821916
  825070
  824737
  828712
  469035
  529703
  530411
  531992
  533178
  538834
  551719
  542202
  545154
  545923
  679708
  683668
  694569
  700385
  704731
  705358
  713614
  662030
  670770
  708828
  666409
  669867
  687691
  716160
  716805
  721562
  721707
  721751
  545980
  564279
  588562
  589136
  623912
  603425
  607435
  637801
  628358
  629743
  618380
  625907
  638485
  775100
  777197
  779202
  786598
  794709
  796503
  808608
  788403
  789174
  800140
  801859
  805113
  805123
  805957
  727910
  733334
  739176
]
3.00 ms
(1.90%)
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
  382948
  389317
  458571
  469035
  469765
  529703
  530411
  531992
  533178
  538834
  542202
  545154
  545923
  545980
  551719
  557486
  564279
  582197
  586566
  588562
  589136
  603425
  607435
  618380
  623912
  625907
  628358
  629743
  637801
  638485
  662030
  663212
  666409
  668082
  669867
  669989
  670770
  679708
  681074
  681122
  683668
  687691
  694569
  700385
  704731
  705358
  708828
  713614
  714332
  714453
  716160
  716805
  721562
  721707
  721751
  727910
  733334
  739176
  749016
  763604
  769382
  771867
  775100
  776954
  777197
  779202
  786598
  788403
  789174
  794709
  796503
  797206
  800140
  800414
  801389
  801859
  803270
  805113
  805123
  805957
  807451
  807869
  808608
  811274
  813693
  813950
  814114
  814578
  814610
  815402
  816584
  816659
  817315
  817355
  817527
  817872
  818429
  818434
  818514
  818743
  819225
  819477
  819486
  819735
  820131
  821773
  821916
  824409
  824509
  824737
  825070
  825472
  825936
  826017
  826057
  826211
  826316
  827115
  827316
  828712
]
2.08 ms
(1.32%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hair milf"
]
1.99 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hair milf"
]
1.69 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hair milf"
]
1.61 ms
(1.02%)
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.