Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.09 ms
(85.43%)
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
  390575
  398300
  408885
  412725
  417478
  428174
  430347
  445775
  508353
  513472
  515267
  529583
  529709
  529753
  531794
  532732
  535185
  536035
  542142
  547479
  548947
  548957
  550904
  564518
  565575
  568770
  573734
  574109
  576590
  576979
  577313
  580989
  584021
  584257
  584298
  584961
  585898
  588929
  590806
  592633
  602293
  604105
  604767
  605155
  611437
  612997
  623207
  634067
  639363
  640375
  642165
  648671
  652954
  656851
  657467
  657537
  657562
  658774
  658785
  658850
  660043
  660415
  664094
  664717
  664733
  671032
  672315
  672926
  687325
  696108
  697994
  700924
  705452
  706520
  711628
  717543
  722284
  736971
  740909
  742304
  742316
  742321
  742351
  743208
  745462
  747310
  749129
  749202
  749215
  749391
  751013
  752587
  752620
  752625
  756830
  761164
  765248
  770413
  771178
  776524
  777001
  778731
  783948
  785544
  785582
  791328
  792064
  792065
  793281
  793297
  796930
  799938
  800537
  800551
  800807
  805647
  808328
  813195
  823317
]
12.50 ms
(8.60%)
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
  776524
  565575
  584298
  652954
  696108
  700924
  584961
  585898
  592633
  611437
  792065
  805647
  751013
  765248
  785544
  743208
  749391
  761164
  604105
  799938
  697994
  529583
  736971
  584257
  398300
  412725
  547479
  664094
  664733
  687325
  576590
  749129
  749215
  752587
  745462
  778731
  742321
  771178
  574109
  752620
  823317
  536035
  531794
  515267
  529753
  535185
  656851
  657537
  705452
  722284
  548947
  623207
  793297
  791328
  752625
  740909
  756830
  706520
  783948
  792064
  813195
  445775
  604767
  408885
  573734
  513472
  508353
  584021
  595376
  428174
  529709
  430347
  417478
  532732
  564518
  576979
  542142
  568770
  577313
  657467
  672315
  660415
  602293
  796930
  742351
  742316
  747310
  742304
  770413
  777001
  390575
  580989
  550904
  658850
  671032
  672926
  658774
  658785
  648671
  657562
  660043
  664717
  711628
  717543
  548957
  612997
  640375
  634067
  639363
  588929
  590806
  605155
  642165
  793281
  808328
  785582
  800537
  800551
  800807
  749202
]
2.48 ms
(1.71%)
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
  390575
  398300
  408885
  412725
  417478
  428174
  430347
  445775
  508353
  513472
  515267
  529583
  529709
  529753
  531794
  532732
  535185
  536035
  542142
  547479
  548947
  548957
  550904
  564518
  565575
  568770
  573734
  574109
  576590
  576979
  577313
  580989
  584021
  584257
  584298
  584961
  585898
  588929
  590806
  592633
  602293
  604105
  604767
  605155
  611437
  612997
  623207
  634067
  639363
  640375
  642165
  648671
  652954
  656851
  657467
  657537
  657562
  658774
  658785
  658850
  660043
  660415
  664094
  664717
  664733
  671032
  672315
  672926
  687325
  696108
  697994
  700924
  705452
  706520
  711628
  717543
  722284
  736971
  740909
  742304
  742316
  742321
  742351
  743208
  745462
  747310
  749129
  749202
  749215
  749391
  751013
  752587
  752620
  752625
  756830
  761164
  765248
  770413
  771178
  776524
  777001
  778731
  783948
  785544
  785582
  791328
  792064
  792065
  793281
  793297
  796930
  799938
  800537
  800551
  800807
  805647
  808328
  813195
  823317
]
1.63 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo ass anal"
]
1.54 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло жоп анал"
]
1.53 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.