Query Metrics
7
Database Queries
7
Different statements
191.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.00 ms (87.54%) |
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 381753 397963 419201 421325 425566 428793 434023 446007 452211 454382 457182 464481 466452 466466 470140 472573 472578 472586 478983 478990 508257 510951 528536 529616 529692 529880 530996 533642 538543 538630 541882 542885 547698 548860 549391 555529 557471 560093 566622 568136 574086 579687 579725 579785 580612 589365 592685 593553 596033 601138 602426 602591 604691 605184 610199 610286 614562 615428 619791 624263 626066 626332 627946 628527 632437 632750 645928 646336 649489 650453 660070 669535 674206 686792 692282 705129 710807 714324 714737 715286 726434 726606 736077 739759 742092 751795 753582 755001 759116 759130 759133 762210 765854 781884 784524 787599 789773 789832 790094 790810 795419 797182 797336 799294 801016 801082 803233 804422 804441 804614 806930 806987 808577 809517 810798 811215 811237 813802 823995 825373 ] |
||||||||||||||||||||||||||||||
|
14.61 ms (7.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 759116 762210 705129 710807 381753 529880 510951 538543 739759 478990 397963 419201 425566 813802 823995 825373 528536 538630 566622 557471 579785 547698 548860 555529 645928 649489 715286 650453 686792 714324 568136 579725 589365 596033 624263 632750 602426 626332 610286 614562 627946 602591 604691 795419 797182 803233 806987 811237 784524 804614 811215 753582 781884 789832 790094 790810 797336 801082 751795 726606 632437 808577 809517 452211 530996 529616 549391 646336 592685 421325 446007 457182 472573 508257 472578 472586 574086 580612 615428 626066 464481 434023 428793 454382 478983 466452 529692 533642 466466 470140 541882 542885 560093 579687 660070 692282 669535 674206 593553 601138 610199 619791 605184 628527 789773 810798 799294 801016 804441 806930 736077 759133 787599 765854 755001 759130 726434 742092 714737 804422 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.40%) |
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 381753 397963 419201 421325 425566 428793 434023 446007 452211 454382 457182 464481 466452 466466 470140 472573 472578 472586 478983 478990 508257 510951 528536 529616 529692 529880 530996 533642 538543 538630 541882 542885 547698 548860 549391 555529 557471 560093 566622 568136 574086 579687 579725 579785 580612 589365 592685 593553 596033 601138 602426 602591 604691 605184 610199 610286 614562 615428 619791 624263 626066 626332 627946 628527 632437 632750 645928 646336 649489 650453 660070 669535 674206 686792 692282 705129 710807 714324 714737 715286 726434 726606 736077 739759 742092 751795 753582 755001 759116 759130 759133 762210 765854 781884 784524 787599 789773 789832 790094 790810 795419 797182 797336 799294 801016 801082 803233 804422 804441 804614 806930 806987 808577 809517 810798 811215 811237 813802 823995 825373 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ван boobs эротик"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bathroom boobs erotic"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ван boobs эротик"
]
|
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.