Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.64 ms
(87.90%)
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
  2595
  76906
  117425
  155291
  160270
  168297
  181926
  382931
  383096
  390805
  394582
  412158
  441541
  531618
  531801
  536208
  537294
  544774
  550936
  566700
  572089
  574758
  577045
  584387
  584664
  595599
  598789
  601304
  624093
  638014
  644101
  648199
  651801
  655841
  665482
  667084
  667138
  670255
  670395
  670987
  673437
  673813
  676518
  684799
  691422
  700911
  703111
  707093
  718863
  719814
  719892
  720205
  720378
  721091
  721806
  722772
  722960
  726641
  729416
  729786
  731380
  731490
  731878
  744740
  754061
  754220
  755017
  756090
  758882
  759213
  759544
  762136
  763776
  764696
  764861
  767313
  767555
  767847
  768699
  774640
  778547
  778667
  779623
  781212
  782578
  782590
  782739
  783178
  783275
  784214
  786590
  786746
  786997
  788957
  791586
  792248
  792838
  793714
  795086
  795119
  795607
  795899
  796323
  798890
  799303
  799521
  802863
  804360
  807932
  811049
  812213
  817818
  820154
  821072
  822278
  823193
  824093
  825468
  825779
]
12.66 ms
(6.64%)
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
  799521
  812213
  2595
  759544
  382931
  719814
  729786
  767847
  784214
  574758
  577045
  729416
  767313
  791586
  412158
  821072
  824093
  825779
  537294
  665482
  703111
  700911
  667138
  673813
  676518
  624093
  601304
  781212
  793714
  774640
  786590
  792838
  798890
  802863
  786997
  731380
  767555
  762136
  755017
  759213
  726641
  731490
  744740
  720378
  778667
  779623
  782578
  795607
  390805
  383096
  76906
  394582
  441541
  822278
  823193
  670987
  673437
  722772
  670255
  598789
  795899
  807932
  778547
  782739
  786746
  758882
  788957
  799303
  811049
  764861
  754220
  756090
  763776
  764696
  783275
  804360
  168297
  160270
  817818
  820154
  531801
  572089
  584387
  651801
  648199
  720205
  722960
  595599
  644101
  638014
  778252
  782590
  792248
  795086
  796323
  754061
  731878
  768699
  707093
  721806
  783178
  795119
  117425
  155291
  181926
  825468
  536208
  531618
  566700
  550936
  544774
  584664
  655841
  670395
  684799
  691422
  718863
  719892
  721091
  667084
]
4.04 ms
(2.12%)
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
  2595
  76906
  117425
  155291
  160270
  168297
  181926
  382931
  383096
  390805
  394582
  412158
  441541
  531618
  531801
  536208
  537294
  544774
  550936
  566700
  572089
  574758
  577045
  584387
  584664
  595599
  598789
  601304
  624093
  638014
  644101
  648199
  651801
  655841
  665482
  667084
  667138
  670255
  670395
  670987
  673437
  673813
  676518
  684799
  691422
  700911
  703111
  707093
  718863
  719814
  719892
  720205
  720378
  721091
  721806
  722772
  722960
  726641
  729416
  729786
  731380
  731490
  731878
  744740
  754061
  754220
  755017
  756090
  758882
  759213
  759544
  762136
  763776
  764696
  764861
  767313
  767555
  767847
  768699
  774640
  778547
  778667
  779623
  781212
  782578
  782590
  782739
  783178
  783275
  784214
  786590
  786746
  786997
  788957
  791586
  792248
  792838
  793714
  795086
  795119
  795607
  795899
  796323
  798890
  799303
  799521
  802863
  804360
  807932
  811049
  812213
  817818
  820154
  821072
  822278
  823193
  824093
  825468
  825779
]
1.70 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sweet sex"
]
1.69 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "милая секс"
]
1.41 ms
(0.74%)
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.