Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.29 ms
(84.98%)
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
  404739
  409317
  435245
  460722
  466263
  475649
  499382
  499898
  500346
  506212
  512793
  515904
  518332
  519439
  523419
  525335
  529573
  546716
  547111
  555389
  556817
  556990
  558709
  558837
  562190
  563516
  565784
  567287
  578058
  581143
  585964
  586196
  586323
  589746
  590291
  592535
  598795
  599209
  601260
  601872
  602128
  603085
  609816
  611245
  616809
  626890
  627218
  636371
  664660
  667165
  669934
  674391
  675397
  681293
  683036
  690100
  694141
  697765
  699323
  700753
  708960
  710540
  714476
  714487
  716218
  716550
  716760
  717748
  725401
  732725
  732912
  736039
  738094
  744618
  756304
  762500
  765036
  771556
  771947
  772672
  774904
  775476
  775551
  778800
  782413
  783399
  786831
  787313
  787386
  788477
  788880
  789649
  790664
  790759
  791988
  793653
  794108
  794955
  795191
  796565
  796657
  799037
  799127
  799146
  799353
  799996
  800200
  800237
  800863
  801319
  801320
  802767
  803461
  804514
  804619
  808424
  809752
  809867
  810149
  814861
]
12.69 ms
(8.15%)
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
  771556
  796657
  800237
  804514
  809867
  515904
  555389
  714487
  681293
  626890
  787313
  744618
  716760
  788880
  435245
  562190
  404739
  519439
  499898
  563516
  674391
  725401
  799353
  799146
  799127
  523419
  565784
  603085
  460722
  500346
  694141
  710540
  590291
  592535
  599209
  602128
  589746
  586323
  793653
  790759
  736039
  782413
  783399
  800863
  547111
  567287
  558837
  669934
  697765
  708960
  683036
  586196
  616809
  627218
  601872
  791988
  794108
  795191
  800200
  796565
  772672
  787386
  789649
  799996
  808424
  810149
  732912
  732725
  762500
  756304
  765036
  699323
  778800
  499382
  556817
  558709
  716550
  664660
  585964
  598795
  506212
  803461
  804619
  529573
  809752
  409317
  801319
  512793
  581143
  717748
  690100
  700753
  601260
  774904
  775551
  786831
  788477
  801320
  738094
  790664
  794955
  799037
  771947
  802767
  475649
  814861
  518332
  556990
  546716
  714476
  609816
  636371
  775476
  611245
  466263
  525335
  667165
  675397
  716218
  578058
]
3.10 ms
(1.99%)
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
  404739
  409317
  435245
  460722
  466263
  475649
  499382
  499898
  500346
  506212
  512793
  515904
  518332
  519439
  523419
  525335
  529573
  546716
  547111
  555389
  556817
  556990
  558709
  558837
  562190
  563516
  565784
  567287
  578058
  581143
  585964
  586196
  586323
  589746
  590291
  592535
  598795
  599209
  601260
  601872
  602128
  603085
  609816
  611245
  616809
  626890
  627218
  636371
  664660
  667165
  669934
  674391
  675397
  681293
  683036
  690100
  694141
  697765
  699323
  700753
  708960
  710540
  714476
  714487
  716218
  716550
  716760
  717748
  725401
  732725
  732912
  736039
  738094
  744618
  756304
  762500
  765036
  771556
  771947
  772672
  774904
  775476
  775551
  778800
  782413
  783399
  786831
  787313
  787386
  788477
  788880
  789649
  790664
  790759
  791988
  793653
  794108
  794955
  795191
  796565
  796657
  799037
  799127
  799146
  799353
  799996
  800200
  800237
  800863
  801319
  801320
  802767
  803461
  804514
  804619
  808424
  809752
  809867
  810149
  814861
]
2.10 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мама хочет меня"
]
2.00 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин хочет"
]
1.72 ms
(1.10%)
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.