Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
263.30 ms
(52.28%)
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
  98711
  135519
  301402
  384047
  386923
  398837
  403214
  419842
  422273
  423842
  424224
  426818
  432433
  433740
  437381
  438605
  441125
  441479
  441806
  445290
  446282
  447783
  453527
  454629
  468266
  475457
  475887
  482599
  485925
  509145
  513815
  519954
  520804
  521032
  521218
  524216
  526919
  528658
  528847
  529579
  530617
  533508
  533540
  535900
  536497
  548136
  549277
  551493
  551967
  556843
  559748
  561755
  565453
  566005
  571127
  573224
  574984
  577174
  581974
  587108
  587152
  587582
  589579
  589977
  591512
  592142
  593137
  593241
  596569
  601189
  602164
  603508
  604190
  607533
  615316
  618329
  618341
  618947
  619890
  623501
  626470
  629509
  629594
  632790
  639060
  644034
  644108
  662863
  669320
  687108
  690952
  706436
  714376
  725418
  748594
  749608
  750407
  753004
  755511
  756538
  757459
  758583
  766926
  768419
  776643
  778248
  784359
  784651
  786530
  788337
  794028
  802307
  803146
  804088
  804131
  805791
  810221
  813363
  813365
  813367
]
230.03 ms
(45.67%)
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
  438605
  602164
  424224
  433740
  524216
  565453
  687108
  520804
  521032
  441125
  437381
  528847
  604190
  423842
  441806
  632790
  422273
  593137
  526919
  591512
  445290
  447783
  536497
  623501
  519954
  587152
  766926
  426818
  776643
  403214
  577174
  813367
  748594
  753004
  725418
  804131
  587108
  644034
  559748
  135519
  802307
  513815
  639060
  301402
  98711
  453527
  475457
  573224
  662863
  805791
  758583
  784359
  786530
  794028
  454629
  468266
  706436
  603508
  750407
  757459
  607533
  528658
  384047
  419842
  521218
  629509
  529579
  548136
  561755
  669320
  714376
  596569
  619890
  589977
  629594
  601189
  618341
  788337
  813365
  755511
  804088
  756538
  386923
  566005
  482599
  530617
  581974
  587582
  784651
  749608
  533508
  535900
  475887
  551493
  556843
  690952
  509145
  533540
  549277
  593241
  441479
  485925
  551967
  589579
  810221
  768419
  615316
  432433
  398837
  446282
  571127
  574984
  626470
  644108
  592142
  618329
  618947
  778248
  803146
  813363
]
3.98 ms
(0.79%)
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
  98711
  135519
  301402
  384047
  386923
  398837
  403214
  419842
  422273
  423842
  424224
  426818
  432433
  433740
  437381
  438605
  441125
  441479
  441806
  445290
  446282
  447783
  453527
  454629
  468266
  475457
  475887
  482599
  485925
  509145
  513815
  519954
  520804
  521032
  521218
  524216
  526919
  528658
  528847
  529579
  530617
  533508
  533540
  535900
  536497
  548136
  549277
  551493
  551967
  556843
  559748
  561755
  565453
  566005
  571127
  573224
  574984
  577174
  581974
  587108
  587152
  587582
  589579
  589977
  591512
  592142
  593137
  593241
  596569
  601189
  602164
  603508
  604190
  607533
  615316
  618329
  618341
  618947
  619890
  623501
  626470
  629509
  629594
  632790
  639060
  644034
  644108
  662863
  669320
  687108
  690952
  706436
  714376
  725418
  748594
  749608
  750407
  753004
  755511
  756538
  757459
  758583
  766926
  768419
  776643
  778248
  784359
  784651
  786530
  788337
  794028
  802307
  803146
  804088
  804131
  805791
  810221
  813363
  813365
  813367
]
1.84 ms
(0.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жопой трется"
]
1.60 ms
(0.32%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп трет"
]
1.47 ms
(0.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(0.28%)
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.