Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
430.15 ms
(94.90%)
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
  129916
  181454
  382285
  386062
  386678
  393693
  395583
  395664
  395698
  398157
  399380
  411218
  411507
  445665
  455311
  460090
  468749
  503359
  511378
  532212
  552068
  554070
  554188
  557250
  560514
  563328
  565383
  585540
  586612
  596584
  598111
  600182
  604625
  606641
  607253
  609240
  612438
  613929
  620685
  620711
  624653
  625408
  628651
  633615
  633722
  634541
  637527
  637690
  638727
  639178
  640033
  649276
  666654
  677347
  681490
  682080
  682964
  683587
  686357
  693489
  708919
  717656
  718877
  719728
  720458
  720873
  722597
  722646
  724690
  727797
  732261
  734388
  734461
  741996
  743331
  745250
  747181
  747368
  749456
  756488
  756523
  757549
  760816
  761970
  763199
  767857
  767861
  771015
  775852
  776219
  777190
  777674
  777948
  778839
  779417
  785776
  786824
  790256
  795826
  798766
  799016
  799276
  800196
  800387
  800410
  803342
  804478
  805695
  806192
  807396
  809211
  817244
  817272
  817748
  820977
  821189
  823454
  823720
  823721
  827971
]
13.48 ms
(2.98%)
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
  786824
  807396
  743331
  799276
  806192
  724690
  732261
  761970
  749456
  756488
  785776
  398157
  677347
  734461
  455311
  554070
  640033
  181454
  745250
  717656
  596584
  633615
  445665
  734388
  800196
  511378
  604625
  563328
  720458
  666654
  682080
  557250
  625408
  586612
  606641
  609240
  620685
  628651
  639178
  777674
  795826
  777948
  778839
  779417
  798766
  727797
  747181
  760816
  763199
  777190
  805695
  720873
  411507
  612438
  386062
  686357
  771015
  620711
  799016
  411218
  607253
  386678
  395664
  821189
  827971
  683587
  613929
  129916
  817748
  823720
  747368
  708919
  598111
  638727
  532212
  565383
  382285
  722646
  649276
  800410
  767857
  767861
  681490
  393693
  817272
  820977
  817244
  693489
  637690
  600182
  634541
  809211
  741996
  757549
  624653
  633722
  823721
  722597
  803342
  800387
  503359
  552068
  460090
  395698
  399380
  775852
  804478
  823454
  560514
  554188
  718877
  682964
  719728
  585540
  790256
  756523
  395583
  776219
  468749
  637527
]
2.51 ms
(0.55%)
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
  129916
  181454
  382285
  386062
  386678
  393693
  395583
  395664
  395698
  398157
  399380
  411218
  411507
  445665
  455311
  460090
  468749
  503359
  511378
  532212
  552068
  554070
  554188
  557250
  560514
  563328
  565383
  585540
  586612
  596584
  598111
  600182
  604625
  606641
  607253
  609240
  612438
  613929
  620685
  620711
  624653
  625408
  628651
  633615
  633722
  634541
  637527
  637690
  638727
  639178
  640033
  649276
  666654
  677347
  681490
  682080
  682964
  683587
  686357
  693489
  708919
  717656
  718877
  719728
  720458
  720873
  722597
  722646
  724690
  727797
  732261
  734388
  734461
  741996
  743331
  745250
  747181
  747368
  749456
  756488
  756523
  757549
  760816
  761970
  763199
  767857
  767861
  771015
  775852
  776219
  777190
  777674
  777948
  778839
  779417
  785776
  786824
  790256
  795826
  798766
  799016
  799276
  800196
  800387
  800410
  803342
  804478
  805695
  806192
  807396
  809211
  817244
  817272
  817748
  820977
  821189
  823454
  823720
  823721
  827971
]
2.18 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blowjob first"
]
1.88 ms
(0.41%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(0.38%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс first"
]
1.35 ms
(0.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "минет оральн секс first"
]

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.