Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.41 ms
(81.38%)
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
  14534
  397714
  400912
  425118
  428387
  428408
  428415
  436031
  436044
  442696
  447314
  447571
  451548
  451551
  451565
  451570
  451571
  451579
  451583
  451591
  451602
  453965
  455111
  460806
  462037
  462045
  472340
  472341
  472393
  473225
  474058
  477387
  478086
  484841
  487150
  489998
  490000
  490019
  491387
  497568
  508837
  511750
  512652
  521897
  521942
  521943
  523282
  523291
  523292
  523300
  523316
  523702
  523951
  523956
  524704
  524705
  524732
  525942
  525962
  527206
  533465
  534114
  544393
  551185
  551416
  558307
  560639
  562223
  562274
  565358
  565372
  565375
  565379
  565395
  565487
  566235
  568001
  570197
  570242
  570312
  571627
  571865
  572809
  573081
  573094
  573568
  573717
  573817
  575121
  575524
  578380
  579106
  589378
  592385
  595764
  597999
  598679
  603475
  606694
  614110
  626866
  636275
  641756
  654803
  659258
  661237
  661281
  661283
  663254
  664444
  675531
  675806
  677362
  704233
  742203
  744978
  748547
  765853
  776503
  805164
]
18.26 ms
(11.58%)
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
  455111
  462037
  523282
  742203
  451579
  478086
  428415
  436044
  659258
  675806
  521942
  654803
  589378
  14534
  603475
  472340
  523702
  523956
  474058
  477387
  573094
  573717
  675531
  442696
  453965
  527206
  524705
  565379
  661237
  400912
  436031
  565358
  663254
  776503
  744978
  451551
  472393
  524704
  490000
  490019
  524732
  525942
  562223
  451602
  447314
  512652
  566235
  451591
  451565
  565375
  571627
  551416
  573568
  614110
  748547
  397714
  462045
  521897
  572809
  597999
  533465
  511750
  573817
  661283
  805164
  508837
  551185
  606694
  765853
  473225
  451571
  565372
  487150
  641756
  497568
  523300
  425118
  592385
  562274
  570242
  664444
  565487
  521943
  491387
  523951
  568001
  573081
  544393
  575524
  626866
  428408
  451548
  523292
  595764
  472341
  428387
  523291
  578380
  579106
  558307
  575121
  570197
  677362
  636275
  704233
  447571
  451583
  451570
  460806
  523316
  525962
  534114
  571865
  598679
  484841
  489998
  661281
  560639
  570312
  565395
]
3.90 ms
(2.47%)
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
  14534
  397714
  400912
  425118
  428387
  428408
  428415
  436031
  436044
  442696
  447314
  447571
  451548
  451551
  451565
  451570
  451571
  451579
  451583
  451591
  451602
  453965
  455111
  460806
  462037
  462045
  472340
  472341
  472393
  473225
  474058
  477387
  478086
  484841
  487150
  489998
  490000
  490019
  491387
  497568
  508837
  511750
  512652
  521897
  521942
  521943
  523282
  523291
  523292
  523300
  523316
  523702
  523951
  523956
  524704
  524705
  524732
  525942
  525962
  527206
  533465
  534114
  544393
  551185
  551416
  558307
  560639
  562223
  562274
  565358
  565372
  565375
  565379
  565395
  565487
  566235
  568001
  570197
  570242
  570312
  571627
  571865
  572809
  573081
  573094
  573568
  573717
  573817
  575121
  575524
  578380
  579106
  589378
  592385
  595764
  597999
  598679
  603475
  606694
  614110
  626866
  636275
  641756
  654803
  659258
  661237
  661281
  661283
  663254
  664444
  675531
  675806
  677362
  704233
  742203
  744978
  748547
  765853
  776503
  805164
]
1.98 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian interracial sex"
]
1.82 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск межрасов секс"
]
1.77 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 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.