Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.00 ms
(79.82%)
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
  432717
  533863
  541591
  541618
  541651
  541738
  541759
  541889
  542194
  542482
  544281
  546611
  547328
  549368
  549933
  549941
  549964
  550014
  550019
  552027
  552040
  552136
  557333
  560375
  561030
  563093
  563535
  563860
  566011
  566673
  570796
  572762
  573908
  574196
  576623
  576657
  577352
  577358
  577368
  578120
  579938
  580193
  581270
  581372
  581399
  583533
  583851
  588763
  593270
  601172
  604063
  604156
  608444
  621315
  622690
  622975
  628328
  644309
  644331
  648208
  649152
  651641
  669566
  669567
  670103
  670108
  670110
  670769
  670773
  671707
  671724
  671733
  671734
  671751
  672151
  672181
  674572
  676122
  681087
  681427
  681444
  687119
  687249
  688116
  690810
  693926
  699546
  699667
  703525
  703528
  703538
  703554
  705514
  705520
  705546
  705913
  706611
  707318
  708421
  708422
  708476
  708525
  711907
  711997
  712001
  712722
  713527
  719097
  719101
  719137
  720471
  722208
  722521
  722731
  724241
  727284
  744294
  750061
  789659
  808115
]
22.67 ms
(13.81%)
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
  549941
  577352
  541618
  552027
  566011
  566673
  576657
  580193
  542482
  550014
  552040
  561030
  669566
  705514
  707318
  711997
  722731
  670769
  681444
  705520
  711907
  719137
  651641
  671733
  674572
  699667
  703554
  708525
  720471
  550019
  570796
  579938
  581270
  601172
  644309
  622690
  621315
  789659
  727284
  808115
  744294
  750061
  724241
  644331
  712001
  719101
  542194
  572762
  577368
  541889
  563093
  541738
  541759
  544281
  563535
  576623
  583533
  622975
  541651
  432717
  533863
  541591
  549368
  557333
  560375
  577358
  578120
  583851
  547328
  563860
  574196
  546611
  552136
  581372
  581399
  648208
  649152
  670110
  670773
  687249
  708421
  712722
  713527
  719097
  722208
  722521
  670108
  671707
  672151
  672181
  676122
  681427
  688116
  690810
  703525
  703528
  706611
  669567
  670103
  671724
  671734
  671751
  681087
  687119
  693926
  699546
  703538
  705546
  705913
  708422
  708476
  549933
  549964
  573908
  593270
  608444
  628328
  604063
  604156
  588763
]
3.20 ms
(1.95%)
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
  432717
  533863
  541591
  541618
  541651
  541738
  541759
  541889
  542194
  542482
  544281
  546611
  547328
  549368
  549933
  549941
  549964
  550014
  550019
  552027
  552040
  552136
  557333
  560375
  561030
  563093
  563535
  563860
  566011
  566673
  570796
  572762
  573908
  574196
  576623
  576657
  577352
  577358
  577368
  578120
  579938
  580193
  581270
  581372
  581399
  583533
  583851
  588763
  593270
  601172
  604063
  604156
  608444
  621315
  622690
  622975
  628328
  644309
  644331
  648208
  649152
  651641
  669566
  669567
  670103
  670108
  670110
  670769
  670773
  671707
  671724
  671733
  671734
  671751
  672151
  672181
  674572
  676122
  681087
  681427
  681444
  687119
  687249
  688116
  690810
  693926
  699546
  699667
  703525
  703528
  703538
  703554
  705514
  705520
  705546
  705913
  706611
  707318
  708421
  708422
  708476
  708525
  711907
  711997
  712001
  712722
  713527
  719097
  719101
  719137
  720471
  722208
  722521
  722731
  724241
  727284
  744294
  750061
  789659
  808115
]
2.19 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "фильмы длинные волосы…"
]
1.80 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фильм длинноволосая"
]
1.49 ms
(0.91%)
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.