Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.99 ms
(83.35%)
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
  45306
  118226
  123029
  359011
  365912
  384289
  386734
  388757
  391959
  396110
  400946
  401137
  401201
  406799
  408586
  411761
  412604
  418840
  422901
  423025
  423609
  424462
  426003
  426395
  426434
  435391
  435413
  443953
  450104
  452832
  460305
  461315
  464161
  466212
  469778
  478078
  487422
  493515
  510794
  513144
  518762
  520684
  521210
  522857
  530465
  533090
  535706
  536271
  545342
  547420
  555290
  555387
  568060
  584252
  585726
  592027
  604346
  605256
  605405
  614833
  620140
  620175
  620978
  626566
  644296
  644330
  649113
  651685
  656546
  660732
  660994
  665936
  670111
  671701
  671724
  672159
  674688
  680295
  692331
  703142
  703533
  703547
  705452
  710018
  716784
  720047
  720375
  720442
  720714
  724260
  729243
  729691
  730361
  731328
  731844
  744463
  748551
  761430
  765434
  767058
  767287
  775869
  780950
  788187
  788629
  791000
  791846
  793232
  795310
  798725
  800463
  803450
  803805
  812109
  815807
  816082
  817878
  823174
  824265
  826834
]
14.60 ms
(9.74%)
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
  400946
  426434
  443953
  411761
  401137
  522857
  672159
  605405
  775869
  780950
  461315
  521210
  535706
  530465
  649113
  705452
  692331
  555290
  620175
  795310
  765434
  788629
  826834
  823174
  487422
  720442
  724260
  767058
  729243
  803805
  359011
  815807
  816082
  533090
  703533
  605256
  791000
  731844
  396110
  592027
  731328
  391959
  466212
  435413
  388757
  478078
  406799
  384289
  817878
  800463
  720714
  660994
  798725
  45306
  426003
  464161
  720047
  123029
  422901
  518762
  520684
  788187
  729691
  408586
  365912
  510794
  423025
  614833
  435391
  418840
  720375
  670111
  620140
  401201
  651685
  680295
  716784
  793232
  730361
  710018
  585726
  620978
  791846
  450104
  118226
  426395
  513144
  665936
  744463
  555387
  671724
  748551
  812109
  660732
  767287
  424462
  412604
  386734
  568060
  469778
  423609
  452832
  803450
  604346
  644296
  644330
  703547
  824265
  493515
  656546
  626566
  761430
  536271
  460305
  545342
  547420
  584252
  671701
  674688
  703142
]
2.63 ms
(1.75%)
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
  45306
  118226
  123029
  359011
  365912
  384289
  386734
  388757
  391959
  396110
  400946
  401137
  401201
  406799
  408586
  411761
  412604
  418840
  422901
  423025
  423609
  424462
  426003
  426395
  426434
  435391
  435413
  443953
  450104
  452832
  460305
  461315
  464161
  466212
  469778
  478078
  487422
  493515
  510794
  513144
  518762
  520684
  521210
  522857
  530465
  533090
  535706
  536271
  545342
  547420
  555290
  555387
  568060
  584252
  585726
  592027
  604346
  605256
  605405
  614833
  620140
  620175
  620978
  626566
  644296
  644330
  649113
  651685
  656546
  660732
  660994
  665936
  670111
  671701
  671724
  672159
  674688
  680295
  692331
  703142
  703533
  703547
  705452
  710018
  716784
  720047
  720375
  720442
  720714
  724260
  729243
  729691
  730361
  731328
  731844
  744463
  748551
  761430
  765434
  767058
  767287
  775869
  780950
  788187
  788629
  791000
  791846
  793232
  795310
  798725
  800463
  803450
  803805
  812109
  815807
  816082
  817878
  823174
  824265
  826834
]
2.32 ms
(1.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy anal fuck"
]
2.05 ms
(1.37%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.00 ms
(1.33%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая анал секс"
]
1.37 ms
(0.91%)
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.