Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
292.11 ms
(90.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
  148101
  357943
  394417
  397014
  401873
  403600
  413163
  431022
  431376
  443724
  457490
  463630
  469072
  469338
  494797
  512793
  514042
  528084
  530290
  530329
  531072
  542979
  548848
  549965
  561589
  563014
  566014
  568034
  568051
  569394
  570800
  579227
  580512
  581878
  591048
  591944
  596128
  606826
  608049
  608432
  612052
  613096
  616709
  625435
  640863
  643092
  665940
  673654
  676581
  677319
  685680
  688594
  694508
  695618
  698235
  721748
  722700
  725571
  725574
  726289
  734677
  738521
  740330
  751486
  753461
  759463
  760658
  762062
  769377
  771243
  774203
  774256
  775254
  775943
  779224
  780340
  781486
  782677
  786371
  787101
  787155
  787165
  789201
  789295
  790534
  793294
  795180
  796206
  796440
  796920
  796986
  797700
  797768
  798942
  800874
  801223
  801378
  801424
  801592
  801871
  802188
  802414
  802692
  805110
  805690
  806181
  806229
  807491
  810343
  812518
  815698
  815944
  817918
  818242
  818488
  818608
  821726
  823163
  825924
]
19.39 ms
(5.99%)
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
  677319
  580512
  606826
  608432
  616709
  789201
  801378
  801424
  775943
  782677
  786371
  797768
  801871
  802692
  725574
  751486
  797700
  762062
  738521
  760658
  787165
  802414
  806229
  443724
  357943
  397014
  805110
  818488
  561589
  581878
  665940
  579227
  775254
  725571
  771243
  698235
  790534
  591944
  542979
  569394
  673654
  625435
  787155
  793294
  801223
  802188
  796206
  608049
  779224
  780340
  818608
  818242
  570800
  694508
  759463
  780126
  548848
  514042
  494797
  403600
  463630
  817918
  825924
  815698
  815944
  821726
  823163
  530329
  530290
  549965
  568034
  568051
  722700
  676581
  685680
  695618
  688594
  643092
  596128
  640863
  612052
  798942
  801592
  781486
  810343
  726289
  769377
  774256
  787101
  789295
  795180
  734677
  774203
  753461
  613096
  796440
  796920
  800874
  148101
  401873
  796986
  812518
  563014
  457490
  431022
  566014
  591048
  807491
  806181
  721748
  469072
  469338
  413163
  512793
  740330
  528084
  394417
  431376
  531072
  805690
]
4.32 ms
(1.33%)
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
  148101
  357943
  394417
  397014
  401873
  403600
  413163
  431022
  431376
  443724
  457490
  463630
  469072
  469338
  494797
  512793
  514042
  528084
  530290
  530329
  531072
  542979
  548848
  549965
  561589
  563014
  566014
  568034
  568051
  569394
  570800
  579227
  580512
  581878
  591048
  591944
  596128
  606826
  608049
  608432
  612052
  613096
  616709
  625435
  640863
  643092
  665940
  673654
  676581
  677319
  685680
  688594
  694508
  695618
  698235
  721748
  722700
  725571
  725574
  726289
  734677
  738521
  740330
  751486
  753461
  759463
  760658
  762062
  769377
  771243
  774203
  774256
  775254
  775943
  779224
  780340
  781486
  782677
  786371
  787101
  787155
  787165
  789201
  789295
  790534
  793294
  795180
  796206
  796440
  796920
  796986
  797700
  797768
  798942
  800874
  801223
  801378
  801424
  801592
  801871
  802188
  802414
  802692
  805110
  805690
  806181
  806229
  807491
  810343
  812518
  815698
  815944
  817918
  818242
  818488
  818608
  821726
  823163
  825924
]
2.10 ms
(0.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex mom beauty"
]
1.97 ms
(0.61%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.88 ms
(0.58%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс mom beauty"
]
1.77 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс mom beauty"
]

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.