Query Metrics
7
Database Queries
7
Different statements
173.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.13 ms (84.83%) |
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 223442 384484 397519 397988 406935 417824 419587 419616 457586 457630 458591 458592 458604 460611 463236 467300 473868 474771 486005 491775 492208 495020 496727 498685 498821 507510 509525 511317 513977 514133 514662 520390 527037 534037 534834 545154 545747 550553 553749 556299 556868 564812 565493 573367 574667 576001 582742 584438 585229 591000 603374 610275 615416 624374 624419 624465 628441 628582 629622 630152 630411 635201 635719 643149 650916 651011 652423 656619 663808 667014 668680 671462 674116 689364 694134 695474 699970 702154 705446 705871 714373 714603 714795 715358 726322 727579 734635 736544 739910 740960 741580 742629 744053 744982 746848 753025 753581 754487 759755 762556 782554 783417 786452 788590 789030 789190 790960 792721 794691 795032 796347 798759 800987 801208 803211 804514 808292 808296 808305 809337 ] |
||||||||||||||||||||||||||||||
|
15.32 ms (8.83%) |
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 457586 496727 762556 458592 702154 486005 495020 491775 790960 671462 635719 534834 584438 628582 511317 689364 789190 545154 674116 624419 705446 603374 564812 556868 624465 705871 573367 663808 740960 419587 651011 509525 630411 786452 585229 746848 726322 397988 753581 804514 694134 699970 630152 520390 789030 715358 734635 397519 635201 492208 808296 739910 513977 514133 629622 742629 384484 794691 534037 801208 803211 795032 668680 624374 652423 458604 808305 741580 574667 474771 460611 498821 759755 406935 650916 714373 615416 714603 800987 796347 457630 695474 527037 507510 458591 744053 550553 808292 783417 809337 514662 736544 223442 582742 714795 419616 576001 565493 556299 467300 545747 417824 667014 753025 553749 610275 788590 782554 754487 744982 473868 656619 643149 591000 727579 792721 463236 498685 798759 628441 ] |
||||||||||||||||||||||||||||||
|
3.23 ms (1.86%) |
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 223442 384484 397519 397988 406935 417824 419587 419616 457586 457630 458591 458592 458604 460611 463236 467300 473868 474771 486005 491775 492208 495020 496727 498685 498821 507510 509525 511317 513977 514133 514662 520390 527037 534037 534834 545154 545747 550553 553749 556299 556868 564812 565493 573367 574667 576001 582742 584438 585229 591000 603374 610275 615416 624374 624419 624465 628441 628582 629622 630152 630411 635201 635719 643149 650916 651011 652423 656619 663808 667014 668680 671462 674116 689364 694134 695474 699970 702154 705446 705871 714373 714603 714795 715358 726322 727579 734635 736544 739910 740960 741580 742629 744053 744982 746848 753025 753581 754487 759755 762556 782554 783417 786452 788590 789030 789190 790960 792721 794691 795032 796347 798759 800987 801208 803211 804514 808292 808296 808305 809337 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big pregnant fuck"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие беремен секс"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.92%) |
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.