Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
116.27 ms
(85.01%)
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
  185038
  426841
  427798
  459236
  492419
  518257
  520200
  529333
  529920
  543780
  547108
  548269
  548811
  606109
  606334
  625086
  630707
  641366
  651948
  695609
  700868
  704522
  704622
  709886
  716197
  716256
  721900
  721991
  725163
  725469
  725502
  726085
  726309
  726928
  727408
  728877
  730693
  731112
  731137
  734077
  734461
  735904
  736256
  737363
  741880
  742590
  746854
  749443
  757311
  760509
  761021
  761252
  763611
  765028
  767639
  768059
  768164
  769230
  769334
  769715
  769911
  770058
  773380
  774114
  774317
  774406
  774410
  775002
  775024
  775129
  777445
  779793
  780158
  780167
  782925
  783862
  784857
  785118
  788564
  789504
  793731
  794758
  794952
  795298
  796010
  796018
  796172
  796256
  796741
  797225
  799626
  800618
  802085
  803746
  805357
  805894
  805952
  806147
  808193
  808952
  809778
  811399
  811411
  811443
  813304
  813574
  817209
  818595
  818777
  821796
  824839
  824902
  825453
  825837
  826534
  828030
  828221
  828299
  828387
]
11.54 ms
(8.43%)
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
  426841
  427798
  828299
  529920
  709886
  716256
  651948
  716197
  606334
  625086
  811399
  775002
  809778
  811411
  725502
  731137
  796741
  803746
  769334
  774317
  737363
  768164
  769715
  730693
  767639
  721900
  784857
  796256
  520200
  459236
  492419
  818595
  813574
  818777
  630707
  641366
  775024
  777445
  805894
  796018
  806147
  726928
  734461
  760509
  726309
  731112
  765028
  742590
  761252
  768059
  769911
  728877
  735904
  734077
  813304
  704522
  793731
  727408
  763611
  774406
  825837
  821796
  822656
  824902
  828221
  828030
  543780
  547108
  548269
  695609
  721991
  548811
  780167
  783862
  726085
  797225
  736256
  741880
  746854
  773380
  808193
  185038
  824839
  704622
  800618
  802085
  749443
  795298
  606109
  529333
  518257
  817209
  774410
  826534
  825453
  828387
  700868
  775129
  779793
  780158
  799626
  805952
  811443
  788564
  789504
  805357
  725163
  725469
  757311
  782925
  794758
  794952
  796010
  796172
  808952
  769230
  770058
  761021
  774114
  785118
]
2.33 ms
(1.70%)
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
  185038
  426841
  427798
  459236
  492419
  518257
  520200
  529333
  529920
  543780
  547108
  548269
  548811
  606109
  606334
  625086
  630707
  641366
  651948
  695609
  700868
  704522
  704622
  709886
  716197
  716256
  721900
  721991
  725163
  725469
  725502
  726085
  726309
  726928
  727408
  728877
  730693
  731112
  731137
  734077
  734461
  735904
  736256
  737363
  741880
  742590
  746854
  749443
  757311
  760509
  761021
  761252
  763611
  765028
  767639
  768059
  768164
  769230
  769334
  769715
  769911
  770058
  773380
  774114
  774317
  774406
  774410
  775002
  775024
  775129
  777445
  779793
  780158
  780167
  782925
  783862
  784857
  785118
  788564
  789504
  793731
  794758
  794952
  795298
  796010
  796018
  796172
  796256
  796741
  797225
  799626
  800618
  802085
  803746
  805357
  805894
  805952
  806147
  808193
  808952
  809778
  811399
  811411
  811443
  813304
  813574
  817209
  818595
  818777
  821796
  824839
  824902
  825453
  825837
  826534
  828030
  828221
  828299
  828387
]
1.89 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "handjob milf"
]
1.76 ms
(1.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дрочк член milf"
]
1.54 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дрочк член milf"
]
1.44 ms
(1.05%)
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.