Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.55 ms
(85.65%)
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
  423499
  427093
  427913
  428035
  434276
  435972
  439587
  439663
  443158
  443812
  450195
  450219
  453082
  453557
  453558
  453563
  453569
  459698
  461580
  465024
  470657
  471313
  475181
  481242
  488978
  489410
  489963
  492320
  493475
  494277
  499783
  501960
  503322
  506820
  509824
  509993
  510692
  511938
  512533
  513491
  513873
  516320
  518596
  518965
  520542
  520717
  520843
  520877
  520940
  521505
  522284
  522976
  523226
  523764
  524083
  526499
  527128
  528272
  535369
  538854
  543614
  546641
  549500
  552855
  558266
  559795
  561345
  561380
  562938
  569303
  569389
  574476
  575467
  579501
  581216
  581805
  582317
  582693
  582708
  582712
  585101
  586339
  586676
  586677
  587854
  589023
  589917
  591203
  595711
  599551
  600833
  601333
  604960
  605470
  605833
  606757
  611301
  613853
  616205
  617175
  620341
  620739
  622462
  623434
  623472
  623642
  626024
  627380
  628324
  632794
  638115
  639277
  640888
  648634
  691720
  693955
  723352
  726707
  780085
]
15.42 ms
(8.54%)
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
  601333
  599551
  726707
  611301
  523226
  509993
  620341
  435972
  511938
  510692
  640888
  428035
  524083
  475181
  546641
  453563
  493475
  513873
  558266
  461580
  691720
  606757
  623642
  780085
  471313
  453569
  509824
  501960
  521505
  488978
  613853
  427093
  513476
  513491
  522284
  523764
  450219
  520940
  605833
  520843
  481242
  528272
  423499
  526499
  520877
  561345
  582317
  582708
  552855
  562938
  581805
  586676
  639277
  723352
  518965
  587854
  569303
  527128
  499783
  589917
  459698
  574476
  575467
  586677
  693955
  453557
  503322
  434276
  470657
  489963
  582712
  586339
  595711
  620739
  453558
  623434
  506820
  559795
  453082
  450195
  648634
  638115
  623472
  443812
  600833
  439663
  439587
  518596
  465024
  443158
  543614
  549500
  516320
  494277
  561380
  622462
  512533
  579501
  582693
  632794
  627380
  617175
  427913
  489410
  626024
  585101
  538854
  520542
  522976
  581216
  604960
  628324
  492320
  520717
  591203
  616205
  569389
  605470
  535369
  589023
]
3.19 ms
(1.77%)
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
  423499
  427093
  427913
  428035
  434276
  435972
  439587
  439663
  443158
  443812
  450195
  450219
  453082
  453557
  453558
  453563
  453569
  459698
  461580
  465024
  470657
  471313
  475181
  481242
  488978
  489410
  489963
  492320
  493475
  494277
  499783
  501960
  503322
  506820
  509824
  509993
  510692
  511938
  512533
  513491
  513873
  516320
  518596
  518965
  520542
  520717
  520843
  520877
  520940
  521505
  522284
  522976
  523226
  523764
  524083
  526499
  527128
  528272
  535369
  538854
  543614
  546641
  549500
  552855
  558266
  559795
  561345
  561380
  562938
  569303
  569389
  574476
  575467
  579501
  581216
  581805
  582317
  582693
  582708
  582712
  585101
  586339
  586676
  586677
  587854
  589023
  589917
  591203
  595711
  599551
  600833
  601333
  604960
  605470
  605833
  606757
  611301
  613853
  616205
  617175
  620341
  620739
  622462
  623434
  623472
  623642
  626024
  627380
  628324
  632794
  638115
  639277
  640888
  648634
  691720
  693955
  723352
  726707
  780085
]
2.30 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife new dick"
]
1.87 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен new член"
]
1.55 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен new член"
]

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.