Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.05 ms
(79.27%)
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
  191474
  233486
  385010
  390775
  397083
  401388
  403725
  410229
  410660
  413161
  414662
  417823
  421345
  423148
  424486
  425643
  427898
  428516
  429416
  430278
  432696
  432731
  437006
  437044
  439655
  443144
  445709
  446011
  455322
  457190
  462271
  464260
  476814
  480518
  483146
  483205
  488130
  490098
  494068
  498075
  501518
  503241
  506080
  510029
  512421
  513530
  514936
  516945
  518077
  518484
  521226
  522968
  523663
  535698
  537550
  539463
  542500
  542541
  544747
  544893
  545292
  547733
  547800
  549292
  559704
  567110
  568310
  569166
  573312
  575942
  583022
  585731
  589414
  593112
  610112
  615709
  620057
  625150
  629940
  631870
  669196
  669867
  671901
  683158
  695367
  695415
  705424
  721707
  725231
  725442
  725514
  729826
  729829
  730965
  735948
  738276
  738851
  754300
  759768
  760079
  771650
  777522
  778986
  786545
  789144
  794128
  799091
  800063
  801480
  801963
  803355
  803887
  811029
  812114
  814288
  814828
  816783
  824169
  824758
  828455
]
29.82 ms
(15.65%)
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
  735948
  439655
  480518
  385010
  233486
  430278
  437006
  814288
  510029
  512421
  483205
  593112
  760079
  778986
  799091
  423148
  476814
  513530
  824758
  390775
  428516
  414662
  814828
  535698
  445709
  539463
  494068
  516945
  514936
  583022
  542500
  544747
  544893
  568310
  585731
  625150
  811029
  725231
  725442
  801963
  730965
  759768
  771650
  410660
  429416
  403725
  547733
  620057
  671901
  432696
  410229
  518484
  521226
  501518
  462271
  483146
  559704
  567110
  683158
  569166
  615709
  729826
  725514
  629940
  424486
  432731
  464260
  537550
  786545
  397083
  488130
  573312
  695367
  669867
  721707
  425643
  413161
  523663
  503241
  518077
  545292
  547800
  610112
  729829
  446011
  455322
  427898
  669196
  803887
  777522
  801480
  816783
  794128
  421345
  417823
  490098
  522968
  542541
  705424
  437044
  498075
  575942
  812114
  191474
  401388
  443144
  695415
  589414
  631870
  738276
  800063
  506080
  824169
  828455
  457190
  549292
  803355
  789144
  738851
  754300
]
2.94 ms
(1.54%)
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
  191474
  233486
  385010
  390775
  397083
  401388
  403725
  410229
  410660
  413161
  414662
  417823
  421345
  423148
  424486
  425643
  427898
  428516
  429416
  430278
  432696
  432731
  437006
  437044
  439655
  443144
  445709
  446011
  455322
  457190
  462271
  464260
  476814
  480518
  483146
  483205
  488130
  490098
  494068
  498075
  501518
  503241
  506080
  510029
  512421
  513530
  514936
  516945
  518077
  518484
  521226
  522968
  523663
  535698
  537550
  539463
  542500
  542541
  544747
  544893
  545292
  547733
  547800
  549292
  559704
  567110
  568310
  569166
  573312
  575942
  583022
  585731
  589414
  593112
  610112
  615709
  620057
  625150
  629940
  631870
  669196
  669867
  671901
  683158
  695367
  695415
  705424
  721707
  725231
  725442
  725514
  729826
  729829
  730965
  735948
  738276
  738851
  754300
  759768
  760079
  771650
  777522
  778986
  786545
  789144
  794128
  799091
  800063
  801480
  801963
  803355
  803887
  811029
  812114
  814288
  814828
  816783
  824169
  824758
  828455
]
2.07 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "gorgeous milf"
]
1.68 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "шикарная milf"
]
1.49 ms
(0.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "шикарная milf"
]

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.