Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.40 ms
(49.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mouth pov"
]
191.33 ms
(45.22%)
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
  417665
  420586
  420588
  422417
  426665
  427009
  427069
  427092
  433390
  436049
  437801
  438411
  441229
  442382
  442943
  446914
  448985
  450754
  455189
  455498
  456491
  456738
  457069
  459342
  461005
  461693
  464750
  466364
  466373
  469677
  472031
  475149
  478125
  479058
  482031
  482277
  483803
  484023
  489293
  489663
  503125
  506110
  506527
  509295
  514055
  516865
  517120
  519062
  521248
  527601
  528237
  542449
  544248
  545089
  545681
  549479
  552609
  553332
  554950
  556492
  556553
  559048
  559258
  559502
  560793
  560856
  561358
  564561
  565086
  567091
  568572
  568731
  570136
  571203
  572934
  574945
  578584
  579605
  586741
  587876
  588946
  589391
  596911
  599371
  602913
  605455
  616012
  616824
  619092
  623416
  624501
  632749
  643315
  652630
  662650
  663318
  664468
  671864
  674340
  679166
  680550
  692074
  706497
  745648
  751120
  764514
  765267
  766864
  773856
  775487
  779450
  781164
  786243
  790504
  791604
  793945
  803222
  809482
  810359
  811175
]
13.80 ms
(3.26%)
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
  554950
  559048
  560856
  568572
  579605
  545681
  552609
  553332
  556553
  564561
  567091
  572934
  574945
  578584
  542449
  544248
  545089
  549479
  556492
  560793
  565086
  568731
  570136
  652630
  671864
  674340
  679166
  662650
  692074
  663318
  664468
  680550
  559258
  559502
  561358
  571203
  619092
  586741
  588946
  599371
  616012
  623416
  643315
  587876
  605455
  616824
  624501
  589391
  596911
  602913
  779450
  803222
  781164
  793945
  809482
  811175
  773856
  786243
  791604
  745648
  765267
  766864
  751120
  764514
  632749
  706497
  775487
  790504
  810359
  420586
  436049
  438411
  455498
  456738
  466373
  475149
  426665
  427009
  427092
  455189
  457069
  461693
  472031
  482277
  417665
  433390
  437801
  446914
  456491
  420588
  422417
  427069
  441229
  442943
  461005
  466364
  479058
  482031
  442382
  448985
  450754
  459342
  464750
  469677
  478125
  514055
  519062
  521248
  483803
  484023
  489663
  506110
  506527
  509295
  527601
  489293
  503125
  516865
  517120
  528237
]
2.86 ms
(0.67%)
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
  417665
  420586
  420588
  422417
  426665
  427009
  427069
  427092
  433390
  436049
  437801
  438411
  441229
  442382
  442943
  446914
  448985
  450754
  455189
  455498
  456491
  456738
  457069
  459342
  461005
  461693
  464750
  466364
  466373
  469677
  472031
  475149
  478125
  479058
  482031
  482277
  483803
  484023
  489293
  489663
  503125
  506110
  506527
  509295
  514055
  516865
  517120
  519062
  521248
  527601
  528237
  542449
  544248
  545089
  545681
  549479
  552609
  553332
  554950
  556492
  556553
  559048
  559258
  559502
  560793
  560856
  561358
  564561
  565086
  567091
  568572
  568731
  570136
  571203
  572934
  574945
  578584
  579605
  586741
  587876
  588946
  589391
  596911
  599371
  602913
  605455
  616012
  616824
  619092
  623416
  624501
  632749
  643315
  652630
  662650
  663318
  664468
  671864
  674340
  679166
  680550
  692074
  706497
  745648
  751120
  764514
  765267
  766864
  773856
  775487
  779450
  781164
  786243
  790504
  791604
  793945
  803222
  809482
  810359
  811175
]
1.81 ms
(0.43%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mouth пов"
]
1.53 ms
(0.36%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mouth пов"
]

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.