Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.71 ms
(83.67%)
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
  191715
  236765
  327659
  384455
  385427
  398967
  400993
  422996
  431046
  449342
  454195
  454202
  465352
  467032
  470461
  474794
  477908
  480780
  482254
  482609
  484640
  490190
  492272
  493876
  496108
  508669
  511417
  515904
  523950
  529035
  536377
  540791
  542764
  543448
  545538
  546969
  552250
  554321
  556405
  557514
  558037
  560400
  563160
  563421
  564188
  565998
  569519
  569954
  575077
  577039
  577366
  577388
  577409
  578007
  579359
  582804
  588389
  605581
  607096
  609962
  621467
  628175
  633165
  651887
  663428
  663916
  663921
  664817
  664837
  665101
  665188
  665214
  665215
  665224
  665233
  665273
  665416
  665444
  665940
  666776
  667212
  667546
  667833
  669786
  673990
  676432
  682145
  687430
  690682
  693944
  713990
  715455
  716299
  716324
  721280
  724504
  732361
  734146
  741191
  750189
  756877
  757891
  762248
  763283
  785879
  788007
  788275
  801223
  804991
  806355
  806356
  808449
  810285
  814848
  815318
  817050
  818815
  824427
  824466
  825092
]
20.02 ms
(10.97%)
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
  543448
  560400
  663428
  664837
  693944
  666776
  682145
  724504
  398967
  400993
  482254
  465352
  454202
  470461
  484640
  490190
  492272
  508669
  385427
  327659
  824466
  817050
  482609
  511417
  515904
  569954
  563160
  565998
  578007
  665940
  667546
  669786
  664817
  665101
  665214
  667833
  663916
  663921
  667212
  715455
  546969
  605581
  588389
  607096
  609962
  621467
  785879
  788007
  804991
  810285
  732361
  734146
  756877
  808449
  763283
  741191
  750189
  716299
  716324
  721280
  806356
  477908
  556405
  431046
  422996
  540791
  523950
  529035
  545538
  577366
  577409
  579359
  582804
  628175
  633165
  757891
  762248
  384455
  236765
  191715
  815318
  814848
  818815
  824427
  825092
  474794
  449342
  480780
  454195
  536377
  496108
  467032
  493876
  542764
  575077
  554321
  563421
  552250
  557514
  558037
  569519
  577388
  665188
  665233
  665273
  665416
  673990
  651887
  665215
  665224
  713990
  665444
  676432
  687430
  690682
  564188
  577039
  788275
  801223
  806355
]
3.06 ms
(1.68%)
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
  191715
  236765
  327659
  384455
  385427
  398967
  400993
  422996
  431046
  449342
  454195
  454202
  465352
  467032
  470461
  474794
  477908
  480780
  482254
  482609
  484640
  490190
  492272
  493876
  496108
  508669
  511417
  515904
  523950
  529035
  536377
  540791
  542764
  543448
  545538
  546969
  552250
  554321
  556405
  557514
  558037
  560400
  563160
  563421
  564188
  565998
  569519
  569954
  575077
  577039
  577366
  577388
  577409
  578007
  579359
  582804
  588389
  605581
  607096
  609962
  621467
  628175
  633165
  651887
  663428
  663916
  663921
  664817
  664837
  665101
  665188
  665214
  665215
  665224
  665233
  665273
  665416
  665444
  665940
  666776
  667212
  667546
  667833
  669786
  673990
  676432
  682145
  687430
  690682
  693944
  713990
  715455
  716299
  716324
  721280
  724504
  732361
  734146
  741191
  750189
  756877
  757891
  762248
  763283
  785879
  788007
  788275
  801223
  804991
  806355
  806356
  808449
  810285
  814848
  815318
  817050
  818815
  824427
  824466
  825092
]
1.93 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young in bathroom"
]
1.72 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young ван"
]
1.47 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young ван"
]

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.