Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.89 ms
(85.18%)
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
  4199
  145343
  146078
  288368
  311854
  327085
  382272
  385323
  390021
  395469
  396364
  396774
  396994
  397014
  398523
  398872
  404391
  407534
  408447
  411593
  420240
  425355
  429788
  449225
  452934
  456724
  457248
  457274
  460952
  460956
  476153
  495021
  544289
  550788
  557921
  558162
  562542
  563913
  565047
  566605
  566674
  577066
  588242
  589323
  609206
  610702
  611260
  612025
  628626
  631703
  633190
  636011
  650951
  652817
  680517
  693254
  696125
  696272
  699708
  699731
  714143
  715420
  717144
  724260
  724463
  724492
  726651
  727697
  728563
  729049
  730996
  733118
  736047
  741587
  742056
  742330
  742474
  742548
  744207
  748431
  759719
  768794
  770091
  770114
  772141
  772678
  776414
  776632
  781897
  788218
  788226
  793612
  796565
  796717
  796860
  796888
  796936
  799121
  800671
  801171
  801804
  804162
  804268
  804407
  804425
  804432
  804713
  805625
  807409
  807837
  808003
  808515
  810112
  812467
  812481
  815468
  815944
  816419
  821778
  825238
]
12.34 ms
(8.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
  796565
  804268
  805625
  808003
  724260
  770091
  781897
  788218
  804162
  808515
  724463
  724492
  744207
  741587
  759719
  727697
  768794
  772678
  628626
  636011
  699708
  776632
  796888
  804407
  804425
  812467
  390021
  588242
  327085
  398872
  404391
  411593
  457248
  396364
  385323
  288368
  821778
  449225
  452934
  457274
  565047
  566605
  566674
  680517
  800671
  807409
  772141
  799121
  408447
  407534
  396774
  456724
  4199
  460952
  460956
  476153
  146078
  652817
  396994
  420240
  815468
  815944
  816419
  544289
  563913
  650951
  714143
  696125
  696272
  577066
  611260
  631703
  589323
  609206
  612025
  610702
  801171
  796717
  742474
  742330
  699731
  796936
  382272
  397014
  311854
  398523
  633190
  736047
  558162
  715420
  730996
  804713
  729049
  145343
  495021
  395469
  425355
  825238
  557921
  812481
  429788
  562542
  693254
  550788
  810112
  793612
  728563
  788226
  801804
  804432
  807837
  742056
  726651
  733118
  742548
  770114
  748431
  717144
  776414
  796860
]
3.22 ms
(2.18%)
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
  4199
  145343
  146078
  288368
  311854
  327085
  382272
  385323
  390021
  395469
  396364
  396774
  396994
  397014
  398523
  398872
  404391
  407534
  408447
  411593
  420240
  425355
  429788
  449225
  452934
  456724
  457248
  457274
  460952
  460956
  476153
  495021
  544289
  550788
  557921
  558162
  562542
  563913
  565047
  566605
  566674
  577066
  588242
  589323
  609206
  610702
  611260
  612025
  628626
  631703
  633190
  636011
  650951
  652817
  680517
  693254
  696125
  696272
  699708
  699731
  714143
  715420
  717144
  724260
  724463
  724492
  726651
  727697
  728563
  729049
  730996
  733118
  736047
  741587
  742056
  742330
  742474
  742548
  744207
  748431
  759719
  768794
  770091
  770114
  772141
  772678
  776414
  776632
  781897
  788218
  788226
  793612
  796565
  796717
  796860
  796888
  796936
  799121
  800671
  801171
  801804
  804162
  804268
  804407
  804425
  804432
  804713
  805625
  807409
  807837
  808003
  808515
  810112
  812467
  812481
  815468
  815944
  816419
  821778
  825238
]
1.77 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy tits"
]
1.55 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "волосатая сиськ"
]
1.53 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая сиськ"
]
1.49 ms
(1.01%)
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.