Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.65 ms
(82.79%)
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
  386285
  435064
  436446
  453075
  453186
  466997
  473989
  474425
  476230
  478640
  480652
  481557
  482747
  484124
  488669
  492708
  492749
  499212
  501263
  503844
  505378
  509784
  512844
  513413
  515068
  517312
  518102
  519715
  520825
  522776
  523568
  527235
  527788
  530019
  535043
  535046
  535429
  538802
  541241
  541293
  543420
  543938
  544420
  545153
  546447
  546665
  551922
  552280
  552405
  553477
  554234
  555873
  556005
  557486
  559332
  560080
  561506
  562008
  562735
  563759
  563915
  563930
  565341
  566634
  569010
  569665
  571193
  571511
  573327
  573603
  573778
  574414
  575762
  575800
  576199
  576721
  580152
  580818
  582807
  583832
  584809
  585756
  586499
  586700
  588093
  588196
  590597
  591330
  591468
  594505
  595081
  598918
  599761
  600073
  601754
  601901
  602631
  603684
  605266
  613599
  615587
  616234
  618394
  619772
  622063
  624281
  628256
  631683
  637172
  644066
  644849
  653508
  658998
  659390
  663769
  667693
  672769
  673330
  678015
  707920
]
20.35 ms
(11.81%)
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
  561506
  563759
  571511
  573778
  575762
  576199
  582807
  541293
  553477
  554234
  560080
  562008
  569010
  573603
  580152
  583832
  543420
  546447
  557486
  562735
  575800
  584809
  653508
  678015
  658998
  659390
  667693
  707920
  545153
  546665
  552280
  555873
  559332
  563930
  569665
  574414
  613599
  616234
  628256
  585756
  586700
  591330
  599761
  619772
  622063
  590597
  600073
  615587
  586499
  588093
  588196
  591468
  594505
  595081
  601754
  605266
  631683
  637172
  601901
  386285
  436446
  473989
  435064
  453075
  520825
  527788
  492708
  492749
  505378
  517312
  488669
  499212
  484124
  513413
  644849
  453186
  478640
  481557
  474425
  482747
  503844
  509784
  512844
  535046
  518102
  523568
  530019
  535043
  535429
  538802
  501263
  515068
  519715
  522776
  527235
  466997
  476230
  480652
  541241
  544420
  551922
  571193
  580818
  566634
  573327
  576721
  543938
  552405
  556005
  565341
  663769
  672769
  673330
  563915
  603684
  618394
  624281
  598918
  602631
  644066
]
2.13 ms
(1.23%)
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
  386285
  435064
  436446
  453075
  453186
  466997
  473989
  474425
  476230
  478640
  480652
  481557
  482747
  484124
  488669
  492708
  492749
  499212
  501263
  503844
  505378
  509784
  512844
  513413
  515068
  517312
  518102
  519715
  520825
  522776
  523568
  527235
  527788
  530019
  535043
  535046
  535429
  538802
  541241
  541293
  543420
  543938
  544420
  545153
  546447
  546665
  551922
  552280
  552405
  553477
  554234
  555873
  556005
  557486
  559332
  560080
  561506
  562008
  562735
  563759
  563915
  563930
  565341
  566634
  569010
  569665
  571193
  571511
  573327
  573603
  573778
  574414
  575762
  575800
  576199
  576721
  580152
  580818
  582807
  583832
  584809
  585756
  586499
  586700
  588093
  588196
  590597
  591330
  591468
  594505
  595081
  598918
  599761
  600073
  601754
  601901
  602631
  603684
  605266
  613599
  615587
  616234
  618394
  619772
  622063
  624281
  628256
  631683
  637172
  644066
  644849
  653508
  658998
  659390
  663769
  667693
  672769
  673330
  678015
  707920
]
2.00 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "час"
]
1.94 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "час"
]
1.49 ms
(0.86%)
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.