Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.66 ms
(85.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
  455989
  464545
  465839
  467905
  468855
  470480
  472131
  477120
  477208
  477870
  479970
  490181
  493214
  497652
  500056
  500886
  503071
  505201
  507222
  514095
  514885
  519459
  521079
  524243
  524267
  524409
  524488
  527456
  527508
  528851
  528889
  530365
  538361
  545926
  547450
  549570
  549743
  550776
  551924
  552794
  553489
  556472
  557463
  559558
  559848
  560827
  561253
  562036
  562649
  562974
  563612
  564369
  565007
  565350
  566360
  566537
  566905
  567572
  568166
  568341
  569577
  569902
  571391
  571579
  571708
  572303
  572851
  575017
  577563
  578031
  578065
  578088
  578100
  579568
  580393
  584259
  586580
  586647
  591552
  598222
  599640
  601241
  601503
  603773
  606655
  609870
  610995
  611854
  614215
  615707
  617647
  617848
  618995
  623841
  624002
  624045
  624359
  629681
  629947
  634276
  641743
  642934
  651192
  652892
  653287
  655656
  655730
  656463
  658353
  659658
  666436
  666475
  670747
  672677
  672975
  673074
  684223
  687163
  691224
  809603
]
14.66 ms
(7.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
  528889
  514095
  524409
  524488
  528851
  530365
  538361
  505201
  514885
  524243
  524267
  477208
  547450
  551924
  556472
  561253
  562649
  563612
  564369
  566360
  566537
  571708
  572851
  549570
  559848
  562974
  566905
  567572
  568341
  575017
  577563
  578065
  559558
  562036
  568166
  569902
  578088
  652892
  653287
  655730
  666436
  673074
  655656
  658353
  670747
  684223
  656463
  659658
  672677
  672975
  691224
  552794
  565350
  572303
  578100
  579568
  580393
  609870
  641743
  599640
  601503
  614215
  618995
  586647
  598222
  601241
  606655
  623841
  624002
  629947
  603773
  617647
  617848
  624045
  629681
  809603
  468855
  477870
  464545
  479970
  465839
  472131
  500886
  519459
  500056
  490181
  507222
  521079
  455989
  477120
  470480
  497652
  503071
  527508
  527456
  493214
  571391
  584259
  557463
  560827
  569577
  545926
  549743
  553489
  565007
  571579
  666475
  651192
  687163
  550776
  578031
  611854
  615707
  591552
  634276
  624359
  586580
  610995
  642934
  467905
]
3.94 ms
(2.14%)
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
  455989
  464545
  465839
  467905
  468855
  470480
  472131
  477120
  477208
  477870
  479970
  490181
  493214
  497652
  500056
  500886
  503071
  505201
  507222
  514095
  514885
  519459
  521079
  524243
  524267
  524409
  524488
  527456
  527508
  528851
  528889
  530365
  538361
  545926
  547450
  549570
  549743
  550776
  551924
  552794
  553489
  556472
  557463
  559558
  559848
  560827
  561253
  562036
  562649
  562974
  563612
  564369
  565007
  565350
  566360
  566537
  566905
  567572
  568166
  568341
  569577
  569902
  571391
  571579
  571708
  572303
  572851
  575017
  577563
  578031
  578065
  578088
  578100
  579568
  580393
  584259
  586580
  586647
  591552
  598222
  599640
  601241
  601503
  603773
  606655
  609870
  610995
  611854
  614215
  615707
  617647
  617848
  618995
  623841
  624002
  624045
  624359
  629681
  629947
  634276
  641743
  642934
  651192
  652892
  653287
  655656
  655730
  656463
  658353
  659658
  666436
  666475
  670747
  672677
  672975
  673074
  684223
  687163
  691224
  809603
]
2.17 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð│ÐÇÐÅðÀð¢ÐïðÁ ÐÇð░ðÀð│ð¥ð▓ð¥ÐÇÐï ð▓ ÐüðÔǪ"
]
2.04 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "разговор в"
]
1.93 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "разговор в"
]
1.89 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.