Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.73 ms
(86.53%)
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
  197609
  265847
  421610
  462225
  469422
  476705
  485296
  535972
  539197
  539706
  539954
  546231
  550945
  554940
  556261
  557060
  558403
  562161
  571379
  572881
  574090
  585260
  587108
  588058
  588074
  588427
  589604
  591869
  600650
  610065
  610196
  615977
  622485
  622511
  627671
  628048
  628340
  636440
  637197
  637328
  637375
  643447
  649738
  649799
  650538
  652321
  661427
  661674
  663345
  670318
  671056
  671200
  677232
  677250
  677689
  681538
  684890
  686481
  687366
  694193
  698459
  700033
  700062
  703019
  704292
  706771
  707481
  708131
  711197
  722252
  722285
  722433
  722963
  725269
  727277
  727582
  736340
  737866
  738479
  739805
  740270
  746711
  747415
  749011
  749046
  749074
  749591
  749696
  751339
  752371
  752440
  753640
  754153
  761473
  769031
  770880
  777738
  782542
  782744
  784480
  785100
  785200
  785340
  785473
  789231
  791882
  793108
  796385
  796394
  796397
  796401
  796411
  796738
  797083
  800648
  802231
  805065
  805480
  807879
]
13.25 ms
(7.36%)
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
  574090
  722252
  722285
  677689
  684890
  704292
  649799
  671056
  671200
  615977
  636440
  637197
  588074
  589604
  600650
  622511
  628340
  785100
  791882
  796411
  796738
  793108
  805480
  727582
  737866
  746711
  749074
  749591
  752371
  752440
  753640
  754153
  770880
  800648
  725269
  736340
  749011
  749696
  739805
  740270
  738479
  727277
  747415
  751339
  761473
  769031
  610196
  628048
  698459
  700062
  711197
  722433
  796394
  796401
  805065
  485296
  558403
  556261
  585260
  785200
  777738
  802231
  796385
  749046
  782542
  785473
  535972
  661674
  722963
  708131
  785340
  789231
  797083
  782744
  784480
  796397
  807879
  469422
  421610
  462225
  197609
  265847
  476705
  539706
  532226
  539197
  539954
  571379
  572881
  550945
  557060
  546231
  554940
  652321
  661427
  663345
  670318
  677232
  694193
  706771
  707481
  649738
  677250
  681538
  686481
  700033
  650538
  687366
  703019
  562161
  588058
  643447
  622485
  637328
  637375
  587108
  588427
  591869
  610065
  627671
]
2.58 ms
(1.43%)
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
  197609
  265847
  421610
  462225
  469422
  476705
  485296
  535972
  539197
  539706
  539954
  546231
  550945
  554940
  556261
  557060
  558403
  562161
  571379
  572881
  574090
  585260
  587108
  588058
  588074
  588427
  589604
  591869
  600650
  610065
  610196
  615977
  622485
  622511
  627671
  628048
  628340
  636440
  637197
  637328
  637375
  643447
  649738
  649799
  650538
  652321
  661427
  661674
  663345
  670318
  671056
  671200
  677232
  677250
  677689
  681538
  684890
  686481
  687366
  694193
  698459
  700033
  700062
  703019
  704292
  706771
  707481
  708131
  711197
  722252
  722285
  722433
  722963
  725269
  727277
  727582
  736340
  737866
  738479
  739805
  740270
  746711
  747415
  749011
  749046
  749074
  749591
  749696
  751339
  752371
  752440
  753640
  754153
  761473
  769031
  770880
  777738
  782542
  782744
  784480
  785100
  785200
  785340
  785473
  789231
  791882
  793108
  796385
  796394
  796397
  796401
  796411
  796738
  797083
  800648
  802231
  805065
  805480
  807879
]
2.25 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "моя влажная мастурбац…"
]
2.20 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мокрая мастурбац"
]
2.09 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(1.04%)
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.