Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.97 ms
(87.55%)
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
  358453
  373724
  410299
  418534
  425431
  443086
  452641
  452964
  468220
  496076
  520419
  531565
  537972
  548969
  548973
  549004
  554827
  567684
  576534
  584346
  591006
  593809
  599939
  603634
  604184
  604358
  609288
  612905
  619668
  620975
  620977
  623275
  624302
  629711
  630341
  630345
  631526
  632921
  636941
  641006
  648410
  651510
  651731
  656484
  656582
  656826
  656888
  657536
  660701
  661656
  661973
  663715
  668085
  672272
  692040
  692096
  693441
  693492
  696104
  698841
  703625
  704023
  707217
  707558
  707608
  715700
  715934
  719919
  721959
  721977
  722378
  723158
  726229
  728669
  729290
  734411
  734452
  734964
  736283
  736809
  737444
  740087
  742362
  747625
  751308
  752752
  756331
  757052
  758504
  760436
  761762
  765097
  767154
  767257
  767804
  769033
  769846
  769895
  772783
  773384
  774698
  777028
  778390
  778424
  778878
  778893
  781368
  782436
  783349
  785855
  791157
  793266
  794378
  795920
  801312
  814533
  823719
  824579
  826804
]
12.57 ms
(6.97%)
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
  777028
  767804
  751308
  612905
  778878
  757052
  769846
  734964
  772783
  604184
  418534
  452641
  520419
  443086
  425431
  452964
  373724
  824579
  531565
  468220
  778424
  756331
  742362
  794378
  537972
  549004
  584346
  651510
  651731
  656582
  661973
  668085
  693441
  703625
  648410
  656484
  660701
  663715
  672272
  693492
  696104
  698841
  707217
  707558
  707608
  656888
  657536
  661656
  692096
  630341
  636941
  591006
  593809
  603634
  619668
  620977
  624302
  629711
  599939
  604358
  609288
  630345
  791157
  734988
  726229
  631526
  632921
  641006
  704023
  721959
  692040
  358453
  410299
  814533
  823719
  826804
  496076
  548973
  567684
  719919
  722378
  656826
  715700
  715934
  721977
  723158
  548969
  554827
  576534
  620975
  623275
  774698
  778893
  785855
  793266
  801312
  778390
  781368
  782436
  783349
  795920
  728669
  729290
  734411
  734452
  736283
  736809
  737444
  740087
  747625
  752752
  758504
  760436
  761762
  765097
  767154
  767257
  769033
  769895
  773384
]
2.83 ms
(1.57%)
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
  358453
  373724
  410299
  418534
  425431
  443086
  452641
  452964
  468220
  496076
  520419
  531565
  537972
  548969
  548973
  549004
  554827
  567684
  576534
  584346
  591006
  593809
  599939
  603634
  604184
  604358
  609288
  612905
  619668
  620975
  620977
  623275
  624302
  629711
  630341
  630345
  631526
  632921
  636941
  641006
  648410
  651510
  651731
  656484
  656582
  656826
  656888
  657536
  660701
  661656
  661973
  663715
  668085
  672272
  692040
  692096
  693441
  693492
  696104
  698841
  703625
  704023
  707217
  707558
  707608
  715700
  715934
  719919
  721959
  721977
  722378
  723158
  726229
  728669
  729290
  734411
  734452
  734964
  736283
  736809
  737444
  740087
  742362
  747625
  751308
  752752
  756331
  757052
  758504
  760436
  761762
  765097
  767154
  767257
  767804
  769033
  769846
  769895
  772783
  773384
  774698
  777028
  778390
  778424
  778878
  778893
  781368
  782436
  783349
  785855
  791157
  793266
  794378
  795920
  801312
  814533
  823719
  824579
  826804
]
2.01 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam amateur anal"
]
1.80 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер любительск анал"
]
1.58 ms
(0.87%)
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.