Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
365.01 ms
(93.76%)
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
  90718
  106162
  201859
  203528
  401126
  408463
  411341
  422729
  428381
  428502
  439465
  444629
  444732
  449105
  449114
  449126
  454752
  455971
  456051
  458892
  459711
  460863
  461232
  467547
  467846
  469426
  469497
  469914
  472438
  474141
  475040
  476045
  480468
  480474
  480476
  480479
  480481
  480921
  482145
  486562
  487779
  489906
  490187
  491395
  492517
  492521
  495247
  500238
  500311
  502899
  504405
  505013
  507352
  507360
  507370
  507375
  507532
  510533
  514818
  514831
  515217
  515268
  515269
  515272
  515275
  515294
  518321
  519956
  520925
  522040
  523088
  526901
  529465
  533969
  547835
  548537
  548556
  548572
  548581
  551026
  551031
  554217
  560143
  560401
  560407
  560424
  560940
  560947
  561358
  565103
  570152
  574836
  576648
  581136
  581208
  585023
  586484
  586500
  592461
  593344
  593465
  593495
  593510
  593523
  598537
  607137
  615022
  620169
  659361
  663887
  675165
  675541
  677387
  681088
  682588
  684193
  691201
  706286
  721006
  734842
]
15.43 ms
(3.96%)
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
  411341
  449114
  518321
  504405
  515272
  529465
  675165
  520925
  458892
  476045
  480479
  480481
  449126
  500311
  548556
  551031
  554217
  663887
  551026
  560407
  560424
  560947
  607137
  721006
  106162
  449105
  487779
  507370
  586484
  482145
  507532
  659361
  681088
  682588
  90718
  515294
  428381
  401126
  684193
  565103
  706286
  570152
  444732
  585023
  474141
  480474
  533969
  593523
  422729
  507375
  490187
  461232
  480921
  522040
  526901
  456051
  510533
  523088
  489906
  547835
  593344
  734842
  408463
  428502
  467547
  460863
  514831
  201859
  203528
  439465
  444629
  475040
  581136
  548537
  691201
  561358
  592461
  615022
  586500
  469426
  469497
  467846
  500238
  492517
  492521
  495247
  459711
  480476
  507360
  515268
  515275
  548581
  548572
  581208
  675541
  560143
  560401
  560940
  593495
  598537
  593510
  620169
  486562
  502899
  505013
  515269
  507352
  677387
  574836
  469914
  480468
  515217
  514818
  455971
  472438
  519956
  576648
  593465
  454752
  491395
]
2.74 ms
(0.70%)
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
  90718
  106162
  201859
  203528
  401126
  408463
  411341
  422729
  428381
  428502
  439465
  444629
  444732
  449105
  449114
  449126
  454752
  455971
  456051
  458892
  459711
  460863
  461232
  467547
  467846
  469426
  469497
  469914
  472438
  474141
  475040
  476045
  480468
  480474
  480476
  480479
  480481
  480921
  482145
  486562
  487779
  489906
  490187
  491395
  492517
  492521
  495247
  500238
  500311
  502899
  504405
  505013
  507352
  507360
  507370
  507375
  507532
  510533
  514818
  514831
  515217
  515268
  515269
  515272
  515275
  515294
  518321
  519956
  520925
  522040
  523088
  526901
  529465
  533969
  547835
  548537
  548556
  548572
  548581
  551026
  551031
  554217
  560143
  560401
  560407
  560424
  560940
  560947
  561358
  565103
  570152
  574836
  576648
  581136
  581208
  585023
  586484
  586500
  592461
  593344
  593465
  593495
  593510
  593523
  598537
  607137
  615022
  620169
  659361
  663887
  675165
  675541
  677387
  681088
  682588
  684193
  691201
  706286
  721006
  734842
]
1.79 ms
(0.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fuck doctor"
]
1.51 ms
(0.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.37%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс доктор"
]
1.39 ms
(0.36%)
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.