Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.80 ms
(83.63%)
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
  446795
  460908
  473473
  475291
  522159
  525507
  531933
  543365
  549712
  561459
  575312
  575998
  593060
  593301
  597482
  600799
  605185
  606473
  606912
  606917
  607529
  607628
  607633
  610062
  614231
  615957
  616165
  627777
  629964
  634629
  634694
  634966
  635980
  636444
  639156
  639587
  646868
  651155
  661025
  662880
  666370
  674126
  680434
  701231
  707440
  711742
  713193
  713437
  721074
  721459
  724284
  724766
  725490
  725663
  726076
  726995
  730370
  731738
  731787
  734183
  734229
  738068
  738418
  739962
  740576
  741698
  742063
  742373
  742761
  744206
  744229
  745947
  745960
  746138
  746175
  748220
  748459
  749109
  750771
  751519
  752558
  752734
  755057
  757496
  761848
  764423
  769480
  770097
  771682
  772114
  776401
  781799
  781905
  781916
  788978
  794254
  794556
  794734
  795935
  795962
  796104
  796493
  799059
  800586
  801056
  801217
  802697
  802742
  806992
  807779
  807870
  808013
  808022
  808023
  808029
  809270
  811126
  815045
  817398
  819353
]
13.66 ms
(9.08%)
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
  607529
  607628
  606473
  607633
  639587
  606917
  615957
  629964
  634694
  593301
  605185
  634629
  636444
  639156
  781799
  796493
  799059
  800586
  801217
  802697
  811126
  776401
  781905
  796104
  806992
  808029
  724284
  725663
  731738
  734183
  734229
  746175
  764423
  794734
  795935
  801056
  807779
  731787
  742063
  745947
  750771
  752734
  730370
  738418
  740576
  742761
  746138
  749109
  757496
  751519
  755057
  726076
  738068
  739962
  744206
  745960
  748459
  769480
  610062
  627777
  634966
  711742
  713437
  721074
  795962
  807870
  808022
  808023
  809270
  475291
  752558
  460908
  819353
  815045
  817398
  446795
  473473
  522159
  531933
  525507
  543365
  549712
  575312
  561459
  661025
  666370
  674126
  680434
  701231
  707440
  713193
  646868
  651155
  662880
  721459
  575998
  616165
  597482
  606912
  614231
  635980
  593060
  600799
  794254
  802742
  808013
  794556
  748220
  772114
  781916
  788978
  724766
  771682
  726995
  742373
  725490
  741698
  744229
  761848
  770097
]
2.92 ms
(1.94%)
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
  446795
  460908
  473473
  475291
  522159
  525507
  531933
  543365
  549712
  561459
  575312
  575998
  593060
  593301
  597482
  600799
  605185
  606473
  606912
  606917
  607529
  607628
  607633
  610062
  614231
  615957
  616165
  627777
  629964
  634629
  634694
  634966
  635980
  636444
  639156
  639587
  646868
  651155
  661025
  662880
  666370
  674126
  680434
  701231
  707440
  711742
  713193
  713437
  721074
  721459
  724284
  724766
  725490
  725663
  726076
  726995
  730370
  731738
  731787
  734183
  734229
  738068
  738418
  739962
  740576
  741698
  742063
  742373
  742761
  744206
  744229
  745947
  745960
  746138
  746175
  748220
  748459
  749109
  750771
  751519
  752558
  752734
  755057
  757496
  761848
  764423
  769480
  770097
  771682
  772114
  776401
  781799
  781905
  781916
  788978
  794254
  794556
  794734
  795935
  795962
  796104
  796493
  799059
  800586
  801056
  801217
  802697
  802742
  806992
  807779
  807870
  808013
  808022
  808023
  808029
  809270
  811126
  815045
  817398
  819353
]
2.08 ms
(1.38%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.05 ms
(1.36%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "chubby трусик нижн бел"
]
2.02 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "chubby panties"
]
1.88 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "chubby трусик нижн бел"
]

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.