Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
213.53 ms
(89.28%)
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
  382548
  392588
  397406
  398106
  398987
  401621
  411187
  413335
  413958
  416032
  418761
  420178
  421840
  421874
  421913
  423929
  425499
  428602
  429790
  435376
  437374
  439643
  440851
  440932
  441583
  441770
  441844
  442057
  448656
  450684
  455496
  455882
  456701
  457433
  457459
  458385
  459200
  461318
  461612
  461619
  464198
  464247
  466164
  466236
  467945
  470147
  471407
  474582
  474794
  476676
  477081
  477135
  477536
  478005
  478611
  482947
  492346
  492372
  493178
  518763
  534079
  537267
  563615
  564549
  578913
  593985
  604089
  612977
  627358
  629354
  681755
  682348
  705459
  713652
  720788
  727460
  728262
  731341
  731349
  739985
  740593
  740844
  740888
  752121
  757650
  761029
  761036
  762272
  764245
  765327
  765476
  768394
  768851
  769311
  769491
  775764
  780778
  782027
  783302
  784209
  785051
  791482
  791594
  791800
  792539
  794887
  795686
  796153
  796319
  796884
  799883
  801214
  802025
  802132
  807352
  810318
  811417
  813828
  827383
  827526
]
15.82 ms
(6.61%)
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
  731349
  534079
  768394
  439643
  466164
  471407
  411187
  421840
  420178
  455496
  416032
  464247
  413335
  461318
  477135
  783302
  757650
  442057
  478611
  457433
  769491
  441770
  441583
  455882
  761036
  604089
  796153
  441844
  458385
  382548
  813828
  794887
  796319
  796884
  791482
  801214
  448656
  740844
  811417
  564549
  791800
  810318
  802025
  713652
  563615
  428602
  476676
  482947
  769311
  739985
  392588
  466236
  418761
  459200
  474582
  492346
  827526
  765476
  740593
  827383
  791594
  802132
  784209
  728262
  762272
  765327
  397406
  464198
  493178
  398106
  456701
  474794
  478005
  807352
  440851
  461612
  425499
  578913
  612977
  705459
  470147
  761029
  401621
  629354
  780778
  799883
  413958
  477536
  727460
  740888
  752121
  768851
  450684
  440932
  398987
  437374
  792539
  457459
  492372
  720788
  682348
  518763
  423929
  421913
  785051
  681755
  627358
  782027
  461619
  731341
  477081
  537267
  467945
  593985
  795686
  435376
  775764
  429790
  764245
  421874
]
2.99 ms
(1.25%)
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
  382548
  392588
  397406
  398106
  398987
  401621
  411187
  413335
  413958
  416032
  418761
  420178
  421840
  421874
  421913
  423929
  425499
  428602
  429790
  435376
  437374
  439643
  440851
  440932
  441583
  441770
  441844
  442057
  448656
  450684
  455496
  455882
  456701
  457433
  457459
  458385
  459200
  461318
  461612
  461619
  464198
  464247
  466164
  466236
  467945
  470147
  471407
  474582
  474794
  476676
  477081
  477135
  477536
  478005
  478611
  482947
  492346
  492372
  493178
  518763
  534079
  537267
  563615
  564549
  578913
  593985
  604089
  612977
  627358
  629354
  681755
  682348
  705459
  713652
  720788
  727460
  728262
  731341
  731349
  739985
  740593
  740844
  740888
  752121
  757650
  761029
  761036
  762272
  764245
  765327
  765476
  768394
  768851
  769311
  769491
  775764
  780778
  782027
  783302
  784209
  785051
  791482
  791594
  791800
  792539
  794887
  795686
  796153
  796319
  796884
  799883
  801214
  802025
  802132
  807352
  810318
  811417
  813828
  827383
  827526
]
2.08 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "трахает мамку домашне…"
]
1.76 ms
(0.73%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.66%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс мам женщин домашн любительск"
]
1.43 ms
(0.60%)
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.