Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.35 ms
(84.83%)
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
  118359
  188369
  327786
  383124
  391204
  393081
  397772
  400999
  403315
  409881
  411920
  424478
  428463
  430393
  443703
  443706
  445199
  445920
  448715
  453101
  460141
  465617
  468076
  470965
  478016
  478929
  479521
  484730
  488310
  490902
  491412
  500422
  504344
  504456
  512593
  515815
  527658
  528274
  537157
  614523
  665217
  666826
  670496
  678779
  678804
  711297
  714162
  719016
  720609
  721572
  724875
  725359
  725369
  725399
  725553
  725566
  725570
  726468
  726480
  726491
  726520
  726527
  726530
  726531
  726542
  726558
  726958
  728239
  731814
  732054
  732848
  735550
  736425
  736957
  741437
  741460
  742235
  744980
  744986
  748151
  758433
  759847
  765299
  765305
  766570
  766618
  770179
  770603
  772114
  772318
  772885
  774172
  780665
  781650
  781676
  786277
  788154
  788232
  788277
  788601
  789294
  790382
  792633
  792636
  794641
  795577
  796857
  798939
  799950
  807522
  807538
  807610
  807617
  807621
  807636
  808510
  808690
  811983
  812969
  825038
]
15.69 ms
(9.35%)
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
  807522
  807610
  807617
  807621
  725359
  725369
  725399
  725553
  726520
  741437
  742235
  758433
  770179
  770603
  772114
  772318
  774172
  788601
  790382
  807636
  808510
  731814
  736425
  748151
  766570
  766618
  724875
  726468
  726527
  726530
  726531
  726542
  726558
  726958
  728239
  732054
  732848
  744986
  725566
  735550
  725570
  726480
  726491
  765299
  614523
  711297
  719016
  720609
  781676
  786277
  788154
  788277
  792633
  792636
  798939
  807538
  808690
  327786
  383124
  391204
  400999
  403315
  428463
  430393
  443703
  443706
  478016
  393081
  453101
  460141
  465617
  479521
  188369
  409881
  478929
  118359
  470965
  424478
  445199
  445920
  448715
  490902
  500422
  491412
  515815
  527658
  528274
  512593
  397772
  825038
  537157
  665217
  666826
  721572
  670496
  788232
  789294
  794641
  795577
  796857
  741460
  759847
  744980
  772885
  736957
  765305
  714162
  780665
  781650
  799950
  811983
  812969
  468076
  488310
  678779
  678804
  504456
  504344
  411920
  484730
]
3.85 ms
(2.29%)
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
  118359
  188369
  327786
  383124
  391204
  393081
  397772
  400999
  403315
  409881
  411920
  424478
  428463
  430393
  443703
  443706
  445199
  445920
  448715
  453101
  460141
  465617
  468076
  470965
  478016
  478929
  479521
  484730
  488310
  490902
  491412
  500422
  504344
  504456
  512593
  515815
  527658
  528274
  537157
  614523
  665217
  666826
  670496
  678779
  678804
  711297
  714162
  719016
  720609
  721572
  724875
  725359
  725369
  725399
  725553
  725566
  725570
  726468
  726480
  726491
  726520
  726527
  726530
  726531
  726542
  726558
  726958
  728239
  731814
  732054
  732848
  735550
  736425
  736957
  741437
  741460
  742235
  744980
  744986
  748151
  758433
  759847
  765299
  765305
  766570
  766618
  770179
  770603
  772114
  772318
  772885
  774172
  780665
  781650
  781676
  786277
  788154
  788232
  788277
  788601
  789294
  790382
  792633
  792636
  794641
  795577
  796857
  798939
  799950
  807522
  807538
  807610
  807617
  807621
  807636
  808510
  808690
  811983
  812969
  825038
]
1.70 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "old shaved mature"
]
1.46 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "old бритая mature"
]
1.40 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.36 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "old бритая mature"
]

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.