Query Metrics
7
Database Queries
7
Different statements
156.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.27 ms (83.96%) |
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 53305 383320 384593 385984 386813 396687 415053 415220 418487 419600 424622 426044 426433 434709 441004 443657 446725 447659 449358 452618 453791 454139 455108 458612 458917 458918 460770 461742 461933 463179 463920 463945 464172 465817 468020 468462 470525 470531 472339 473914 474496 476084 476295 478200 478462 478464 479221 479678 480803 484434 487979 489355 489524 489561 490862 491944 492717 494374 512426 513466 519002 519083 519252 526766 535465 536278 542092 545701 548254 548994 551199 552064 552390 566033 569070 571900 571929 572307 579358 596648 596993 598571 603432 609277 622397 624220 634187 634510 636813 637077 638985 644021 652978 653216 653284 656175 665762 678557 679050 680172 680183 691567 705813 714629 720033 720792 722593 730692 737114 738528 740710 753259 754017 775978 786374 788800 788805 801927 811850 817451 ] |
||||||||||||||||||||||||||||||
|
15.82 ms (10.12%) |
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 461933 548994 786374 740710 385984 545701 634510 638985 551199 569070 622397 383320 384593 434709 461742 447659 474496 487979 479221 478464 479678 476084 463179 419600 455108 415053 489561 468020 691567 458917 817451 652978 720033 609277 788800 424622 443657 458612 470525 453791 454139 460770 465817 490862 478200 535465 470531 473914 463920 464172 415220 426433 452618 468462 446725 512426 526766 484434 489355 491944 513466 536278 492717 519002 441004 634187 548254 680183 571929 552064 571900 653216 653284 656175 678557 720792 665762 679050 680172 705813 722593 598571 596648 596993 636813 637077 788805 730692 737114 753259 754017 624220 644021 714629 775978 801927 811850 458918 542092 552390 572307 603432 738528 53305 396687 386813 476295 566033 478462 480803 418487 426044 449358 463945 472339 494374 519083 519252 489524 579358 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.63%) |
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 53305 383320 384593 385984 386813 396687 415053 415220 418487 419600 424622 426044 426433 434709 441004 443657 446725 447659 449358 452618 453791 454139 455108 458612 458917 458918 460770 461742 461933 463179 463920 463945 464172 465817 468020 468462 470525 470531 472339 473914 474496 476084 476295 478200 478462 478464 479221 479678 480803 484434 487979 489355 489524 489561 490862 491944 492717 494374 512426 513466 519002 519083 519252 526766 535465 536278 542092 545701 548254 548994 551199 552064 552390 566033 569070 571900 571929 572307 579358 596648 596993 598571 603432 609277 622397 624220 634187 634510 636813 637077 638985 644021 652978 653216 653284 656175 665762 678557 679050 680172 680183 691567 705813 714629 720033 720792 722593 730692 737114 738528 740710 753259 754017 775978 786374 788800 788805 801927 811850 817451 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая большие анал"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small big anal"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.87%) |
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.