Query Metrics
7
Database Queries
7
Different statements
171.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.43 ms (88.05%) |
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 233166 382712 385039 396181 397899 401221 405409 407517 416876 420418 428781 440832 441197 442131 443638 451043 452585 452622 454398 463132 470399 476823 477565 478525 498540 501527 504022 522763 525215 529256 529284 532120 548295 550963 552580 556993 567396 567485 572718 575685 578581 579332 579403 584605 587609 590898 603661 616602 616924 618796 619275 626067 626837 631996 652617 656674 659061 674066 677055 685899 688034 699628 700882 705083 710274 721432 722323 726597 727004 728353 732266 732604 733241 736169 740149 741382 743741 748146 748920 751920 752742 756415 762223 765178 765815 771819 775445 778625 778701 778889 780016 781672 781685 787024 789274 789293 793620 793877 795848 797448 799350 801675 802488 802823 803441 803775 805339 805541 807477 811143 813072 817423 820577 820893 820913 ] |
||||||||||||||||||||||||||||||
|
11.05 ms (6.43%) |
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 789274 382712 385039 428781 820577 820913 532120 550963 575685 578581 548295 705083 722323 721432 631996 797448 802823 775445 778701 793620 795848 803775 807477 748146 752742 754183 762223 765178 781672 787024 801675 811143 741382 736169 741551 751920 764584 738586 748920 751981 765815 740149 743741 781685 803441 416876 397899 699628 820893 501527 567396 552580 656674 674066 688034 590898 793877 799350 817423 710274 778625 778889 401221 677055 584605 572718 652617 626837 780016 802488 805339 733241 619275 504022 233166 626067 756415 727004 525215 618796 579332 771819 440832 522763 529256 442131 443638 463132 477565 451043 685899 659061 556993 587609 789293 813072 726597 728353 732604 441197 405409 407517 470399 529284 579403 567485 616602 616924 732266 700882 454398 498540 452622 396181 420418 452585 476823 478525 603661 805541 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.51%) |
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 233166 382712 385039 396181 397899 401221 405409 407517 416876 420418 428781 440832 441197 442131 443638 451043 452585 452622 454398 463132 470399 476823 477565 478525 498540 501527 504022 522763 525215 529256 529284 532120 548295 550963 552580 556993 567396 567485 572718 575685 578581 579332 579403 584605 587609 590898 603661 616602 616924 618796 619275 626067 626837 631996 652617 656674 659061 674066 677055 685899 688034 699628 700882 705083 710274 721432 722323 726597 727004 728353 732266 732604 733241 736169 740149 741382 743741 748146 748920 751920 752742 756415 762223 765178 765815 771819 775445 778625 778701 778889 780016 781672 781685 787024 789274 789293 793620 793877 795848 797448 799350 801675 802488 802823 803441 803775 805339 805541 807477 811143 813072 817423 820577 820893 820913 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"friend blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"friend минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"friend минет оральн секс"
]
|
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.