Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.14 ms
(83.57%)
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
  12141
  29367
  185753
  188369
  233353
  293499
  366010
  385066
  389124
  391042
  391478
  391675
  393330
  397390
  400897
  401579
  402244
  406816
  413577
  414438
  419998
  422252
  423676
  423837
  424562
  425913
  427196
  428171
  429579
  432803
  435510
  436080
  437710
  437720
  438004
  438031
  439027
  439264
  439268
  439729
  440217
  441477
  441495
  441570
  443874
  443917
  443920
  444124
  446216
  449690
  451650
  452890
  454808
  456555
  456587
  459203
  459447
  461396
  462006
  463331
  466391
  468109
  470183
  470565
  470923
  470929
  475803
  478406
  480664
  481249
  481445
  486192
  490387
  491946
  492039
  494062
  494242
  498639
  500873
  502491
  505072
  509153
  509975
  510997
  512008
  519071
  519365
  521837
  523751
  537968
  546057
  547810
  549551
  550453
  556847
  559395
  565438
  571323
  571401
  571553
  572692
  583143
  584108
  588916
  591187
  591224
  598674
  605610
  610616
  630400
  651647
  659328
  668351
  721303
  741841
  751040
  759327
  792601
  797351
  800423
]
16.25 ms
(9.69%)
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
  185753
  470923
  651647
  591187
  610616
  423837
  443874
  481249
  571401
  571553
  559395
  588916
  393330
  463331
  475803
  391042
  440217
  419998
  443920
  451650
  466391
  391675
  423676
  438004
  439729
  391478
  441477
  427196
  441570
  443917
  571323
  546057
  668351
  721303
  605610
  630400
  741841
  751040
  792601
  800423
  759327
  797351
  397390
  401579
  385066
  505072
  389124
  659328
  441495
  444124
  446216
  459447
  481445
  550453
  565438
  549551
  584108
  572692
  547810
  556847
  583143
  598674
  591224
  29367
  293499
  406816
  413577
  424562
  432803
  12141
  366010
  435510
  439268
  456555
  459203
  461396
  468109
  478406
  188369
  402244
  425913
  429579
  437720
  438031
  439264
  452890
  462006
  470183
  233353
  400897
  422252
  428171
  436080
  449690
  454808
  470929
  480664
  414438
  437710
  456587
  537968
  491946
  492039
  494062
  502491
  519071
  519365
  521837
  486192
  498639
  500873
  509153
  494242
  509975
  510997
  512008
  523751
  439027
  490387
  470565
]
3.80 ms
(2.26%)
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
  12141
  29367
  185753
  188369
  233353
  293499
  366010
  385066
  389124
  391042
  391478
  391675
  393330
  397390
  400897
  401579
  402244
  406816
  413577
  414438
  419998
  422252
  423676
  423837
  424562
  425913
  427196
  428171
  429579
  432803
  435510
  436080
  437710
  437720
  438004
  438031
  439027
  439264
  439268
  439729
  440217
  441477
  441495
  441570
  443874
  443917
  443920
  444124
  446216
  449690
  451650
  452890
  454808
  456555
  456587
  459203
  459447
  461396
  462006
  463331
  466391
  468109
  470183
  470565
  470923
  470929
  475803
  478406
  480664
  481249
  481445
  486192
  490387
  491946
  492039
  494062
  494242
  498639
  500873
  502491
  505072
  509153
  509975
  510997
  512008
  519071
  519365
  521837
  523751
  537968
  546057
  547810
  549551
  550453
  556847
  559395
  565438
  571323
  571401
  571553
  572692
  583143
  584108
  588916
  591187
  591224
  598674
  605610
  610616
  630400
  651647
  659328
  668351
  721303
  741841
  751040
  759327
  792601
  797351
  800423
]
2.10 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русскую очко"
]
1.94 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск анус"
]
1.87 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск анус"
]
1.59 ms
(0.95%)
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.