Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
182.26 ms
(85.81%)
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
  69969
  311697
  383119
  385634
  385826
  389258
  389565
  391149
  391241
  393027
  419094
  419273
  425641
  425916
  432414
  440533
  446175
  456062
  466905
  472657
  473542
  474442
  475491
  494952
  506487
  509632
  527321
  531265
  532985
  536217
  544613
  568671
  578404
  583569
  586268
  591015
  603795
  604916
  606792
  610107
  610163
  612233
  613697
  621840
  626351
  630666
  636719
  640865
  642115
  643455
  650374
  653004
  657143
  666483
  685492
  714942
  716364
  716534
  718287
  718919
  724797
  724839
  725004
  726052
  727972
  728467
  728563
  728615
  730280
  731609
  733445
  734218
  737828
  738212
  738475
  739646
  740057
  741199
  746587
  747942
  747951
  749047
  749969
  750692
  751478
  759107
  759812
  761609
  761834
  763697
  765408
  766242
  766519
  768144
  769256
  775617
  779949
  779973
  781060
  781097
  783768
  784103
  784340
  786713
  788386
  788662
  792591
  794590
  796283
  796720
  798535
  800071
  801064
  801982
  808619
  808712
  811130
  819926
  824848
  825073
]
16.98 ms
(8.00%)
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
  784340
  808619
  724839
  725004
  730280
  739646
  765408
  759812
  747942
  751478
  741199
  761609
  630666
  642115
  775617
  779949
  432414
  475491
  440533
  801064
  825073
  531265
  568671
  583569
  653004
  650374
  610107
  591015
  610163
  643455
  801982
  796720
  728563
  726052
  728467
  746587
  666483
  781097
  750692
  466905
  509632
  626351
  796283
  759107
  734218
  728615
  740057
  798535
  456062
  604916
  425641
  425916
  419273
  472657
  473542
  474442
  527321
  532985
  716534
  586268
  636719
  808712
  788386
  800071
  769256
  727972
  768144
  731609
  446175
  391149
  391241
  603795
  738212
  385826
  385634
  393027
  69969
  389565
  419094
  819926
  824848
  494952
  536217
  506487
  544613
  578404
  657143
  685492
  718287
  718919
  714942
  716364
  613697
  621840
  640865
  606792
  612233
  779973
  811130
  781060
  784103
  794590
  749047
  783768
  788662
  792591
  737828
  724797
  738475
  766519
  733445
  747951
  766242
  749969
  761834
  763697
  786713
  383119
  311697
  389258
]
4.12 ms
(1.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cumshot tits"
]
3.14 ms
(1.48%)
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
  69969
  311697
  383119
  385634
  385826
  389258
  389565
  391149
  391241
  393027
  419094
  419273
  425641
  425916
  432414
  440533
  446175
  456062
  466905
  472657
  473542
  474442
  475491
  494952
  506487
  509632
  527321
  531265
  532985
  536217
  544613
  568671
  578404
  583569
  586268
  591015
  603795
  604916
  606792
  610107
  610163
  612233
  613697
  621840
  626351
  630666
  636719
  640865
  642115
  643455
  650374
  653004
  657143
  666483
  685492
  714942
  716364
  716534
  718287
  718919
  724797
  724839
  725004
  726052
  727972
  728467
  728563
  728615
  730280
  731609
  733445
  734218
  737828
  738212
  738475
  739646
  740057
  741199
  746587
  747942
  747951
  749047
  749969
  750692
  751478
  759107
  759812
  761609
  761834
  763697
  765408
  766242
  766519
  768144
  769256
  775617
  779949
  779973
  781060
  781097
  783768
  784103
  784340
  786713
  788386
  788662
  792591
  794590
  796283
  796720
  798535
  800071
  801064
  801982
  808619
  808712
  811130
  819926
  824848
  825073
]
2.04 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cumshot сиськ"
]
2.03 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cumshot сиськ"
]

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.