Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.19 ms
(85.84%)
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
  73293
  193895
  381740
  383541
  386725
  386870
  391270
  396130
  439812
  458203
  461248
  464120
  503745
  515783
  531836
  533410
  534209
  537216
  541207
  541680
  548415
  549355
  553478
  564075
  565148
  565354
  565359
  565363
  591803
  596906
  613643
  618751
  622376
  623207
  646154
  656514
  665872
  666388
  673973
  676679
  693870
  695495
  699196
  700038
  702943
  706410
  713104
  716198
  716796
  717105
  725025
  725196
  729209
  729431
  733736
  736374
  736606
  737049
  738382
  740284
  741961
  743939
  744885
  747716
  759480
  759767
  764628
  766371
  768394
  771020
  773686
  774030
  776089
  776228
  780663
  781931
  783197
  785807
  785835
  787392
  788240
  789651
  792065
  793898
  794102
  794446
  794628
  800788
  801201
  801538
  802368
  805385
  805768
  806204
  811254
  811530
  814410
  814751
  815942
  817073
  817381
  817807
  817962
  818212
  818487
  819031
  819917
  821029
  821367
  821807
  822103
  822610
  822677
  822698
  823193
  823317
  823608
  823633
  824483
  826938
]
12.35 ms
(7.51%)
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
  736374
  736606
  774030
  553478
  564075
  565354
  817073
  802368
  464120
  776228
  534209
  695495
  787392
  733736
  794102
  548415
  673973
  737049
  805768
  541207
  565359
  822610
  821029
  822677
  819031
  821367
  815942
  823633
  646154
  665872
  699196
  706410
  713104
  676679
  702943
  591803
  801201
  794628
  725196
  741961
  773686
  789651
  73293
  824483
  439812
  386725
  503745
  541680
  716796
  622376
  693870
  391270
  533410
  717105
  193895
  826938
  814751
  383541
  729209
  386870
  822103
  700038
  549355
  788240
  805385
  811254
  396130
  792065
  806204
  738382
  793898
  794446
  565363
  785807
  743939
  821807
  537216
  817381
  818487
  823317
  817962
  817807
  818212
  819917
  823193
  565148
  666388
  716198
  623207
  781931
  811530
  744885
  771020
  785835
  766371
  759480
  764628
  381740
  822698
  823608
  515783
  613643
  776089
  780663
  729431
  768394
  783197
  801538
  461248
  740284
  759767
  814410
  458203
  531836
  656514
  596906
  618751
  800788
  725025
  747716
]
4.06 ms
(2.47%)
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
  73293
  193895
  381740
  383541
  386725
  386870
  391270
  396130
  439812
  458203
  461248
  464120
  503745
  515783
  531836
  533410
  534209
  537216
  541207
  541680
  548415
  549355
  553478
  564075
  565148
  565354
  565359
  565363
  591803
  596906
  613643
  618751
  622376
  623207
  646154
  656514
  665872
  666388
  673973
  676679
  693870
  695495
  699196
  700038
  702943
  706410
  713104
  716198
  716796
  717105
  725025
  725196
  729209
  729431
  733736
  736374
  736606
  737049
  738382
  740284
  741961
  743939
  744885
  747716
  759480
  759767
  764628
  766371
  768394
  771020
  773686
  774030
  776089
  776228
  780663
  781931
  783197
  785807
  785835
  787392
  788240
  789651
  792065
  793898
  794102
  794446
  794628
  800788
  801201
  801538
  802368
  805385
  805768
  806204
  811254
  811530
  814410
  814751
  815942
  817073
  817381
  817807
  817962
  818212
  818487
  819031
  819917
  821029
  821367
  821807
  822103
  822610
  822677
  822698
  823193
  823317
  823608
  823633
  824483
  826938
]
1.88 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "toilet ass fuck"
]
1.82 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "туалет жоп секс"
]
1.65 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.93%)
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.