Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.22 ms
(82.75%)
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
  89199
  426673
  449456
  497467
  505144
  527487
  529606
  536256
  536271
  539173
  543517
  544805
  545415
  545607
  546262
  549092
  552103
  552161
  552193
  552194
  552651
  553586
  553674
  553722
  556362
  558407
  561901
  563354
  565043
  565577
  568355
  568509
  573430
  573605
  573648
  574507
  574864
  575070
  575495
  576307
  576330
  579182
  579735
  580592
  581431
  586665
  586835
  592323
  593171
  595490
  596653
  597984
  598461
  598599
  598670
  598726
  598734
  598788
  598812
  600063
  600473
  613471
  614408
  615059
  623932
  624915
  626580
  628933
  634163
  642401
  654105
  654583
  654610
  655674
  657594
  667513
  670991
  674216
  675028
  675041
  676521
  677340
  677343
  679051
  681843
  683272
  688660
  693291
  696297
  701012
  707264
  712713
  713364
  720450
  720883
  721366
  721419
  721426
  722494
  722542
  730070
  730464
  741997
  742212
  753457
  753814
  753895
  754260
  755178
  759639
  766797
  767941
  778875
  789971
  790081
  799953
  801284
  805327
  807541
  810491
]
15.02 ms
(9.62%)
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
  529606
  527487
  539173
  552651
  558407
  544805
  546262
  579735
  552103
  573605
  675041
  696297
  707264
  654583
  675028
  654105
  655674
  657594
  642401
  628933
  615059
  801284
  790081
  799953
  810491
  742212
  805327
  741997
  766797
  778875
  789971
  505144
  561901
  553674
  693291
  600473
  586835
  574507
  579182
  614408
  759639
  89199
  497467
  536256
  536271
  575495
  688660
  712713
  721419
  598788
  598734
  595490
  598599
  767941
  753895
  701012
  426673
  449456
  545607
  681843
  565577
  574864
  586665
  634163
  624915
  720883
  553586
  573430
  549092
  552161
  553722
  563354
  581431
  543517
  552193
  568509
  575070
  576330
  677340
  679051
  720450
  721366
  722494
  722542
  654610
  667513
  670991
  676521
  677343
  683272
  713364
  721426
  674216
  545415
  552194
  556362
  565043
  568355
  573648
  576307
  580592
  598461
  598812
  613471
  626580
  596653
  598670
  598726
  597984
  600063
  592323
  593171
  623932
  807541
  753457
  730070
  753814
  754260
  755178
  730464
]
3.36 ms
(2.15%)
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
  89199
  426673
  449456
  497467
  505144
  527487
  529606
  536256
  536271
  539173
  543517
  544805
  545415
  545607
  546262
  549092
  552103
  552161
  552193
  552194
  552651
  553586
  553674
  553722
  556362
  558407
  561901
  563354
  565043
  565577
  568355
  568509
  573430
  573605
  573648
  574507
  574864
  575070
  575495
  576307
  576330
  579182
  579735
  580592
  581431
  586665
  586835
  592323
  593171
  595490
  596653
  597984
  598461
  598599
  598670
  598726
  598734
  598788
  598812
  600063
  600473
  613471
  614408
  615059
  623932
  624915
  626580
  628933
  634163
  642401
  654105
  654583
  654610
  655674
  657594
  667513
  670991
  674216
  675028
  675041
  676521
  677340
  677343
  679051
  681843
  683272
  688660
  693291
  696297
  701012
  707264
  712713
  713364
  720450
  720883
  721366
  721419
  721426
  722494
  722542
  730070
  730464
  741997
  742212
  753457
  753814
  753895
  754260
  755178
  759639
  766797
  767941
  778875
  789971
  790081
  799953
  801284
  805327
  807541
  810491
]
2.55 ms
(1.63%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "маленькая худые teen"
]
2.28 ms
(1.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "small skinny teen"
]
2.10 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "маленькая худые teen"
]
1.63 ms
(1.05%)
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.