Query Metrics
7
Database Queries
7
Different statements
205.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.26 ms (88.82%) |
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 6813 27847 147897 187956 282465 384518 398733 485644 518911 530297 535725 557328 564543 584391 590655 593595 597132 598479 599281 604169 606767 613523 623273 624279 629341 629735 630392 630408 636469 643461 643589 643605 643664 648199 649580 650066 651752 654409 655265 656295 656562 656599 656622 674848 680236 680268 682991 684630 690443 691190 692646 694437 694592 696232 698554 702941 703297 704958 707133 714888 717258 720130 721562 721890 723667 725556 726260 727503 731228 731274 733233 734970 739164 742534 748487 750283 750286 754584 760742 761587 764239 766608 766768 773268 773734 775377 776981 778084 778644 779665 782964 783372 783386 788557 788982 790900 791402 791415 791521 791860 792946 793872 794142 794385 794855 794889 795680 797130 798696 798811 800313 800439 801285 805641 805706 806858 810415 813944 821704 827835 ] |
||||||||||||||||||||||||||||||
|
12.10 ms (5.90%) |
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 750286 766768 783386 739164 748487 773268 764239 726260 734970 742534 750283 754584 766608 773734 606767 717258 779665 788557 788982 791860 810415 723667 727503 733233 794142 794855 704958 147897 6813 384518 187956 282465 27847 398733 821704 813944 827835 485644 535725 518911 530297 584391 656295 656599 680236 694437 698554 703297 707133 648199 650066 680268 684630 690443 692646 702941 714888 720130 649580 651752 654409 655265 656562 656622 674848 682991 691190 694592 696232 721562 721890 557328 564543 598479 599281 613523 629341 643605 643461 590655 597132 624279 629735 630408 643664 593595 604169 623273 630392 636469 643589 775377 778084 778644 791415 793872 798811 776981 782964 790900 794385 794889 795680 798696 800313 800439 801285 805641 725556 731228 731274 760742 761587 783372 791402 791521 792946 797130 805706 806858 ] |
||||||||||||||||||||||||||||||
|
4.15 ms (2.02%) |
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 6813 27847 147897 187956 282465 384518 398733 485644 518911 530297 535725 557328 564543 584391 590655 593595 597132 598479 599281 604169 606767 613523 623273 624279 629341 629735 630392 630408 636469 643461 643589 643605 643664 648199 649580 650066 651752 654409 655265 656295 656562 656599 656622 674848 680236 680268 682991 684630 690443 691190 692646 694437 694592 696232 698554 702941 703297 704958 707133 714888 717258 720130 721562 721890 723667 725556 726260 727503 731228 731274 733233 734970 739164 742534 748487 750283 750286 754584 760742 761587 764239 766608 766768 773268 773734 775377 776981 778084 778644 779665 782964 783372 783386 788557 788982 790900 791402 791415 791521 791860 792946 793872 794142 794385 794855 794889 795680 797130 798696 798811 800313 800439 801285 805641 805706 806858 810415 813944 821704 827835 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"анал с большими жопам%…"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.76%) |
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.