Query Metrics
7
Database Queries
7
Different statements
397.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.29 ms (53.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old pussy лиза"
]
|
||||||||||||||||||||||||||||||
|
156.42 ms (39.35%) |
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 66716 382696 382937 384880 386060 393462 394194 395925 396887 400425 400435 400443 400455 400471 402090 403190 403210 409050 469874 477455 491442 491646 522566 525495 528344 538660 538956 539460 547915 550649 559078 563857 567863 568573 569668 579668 605148 619526 620199 624854 633860 665247 675737 683524 683745 684224 684943 686794 689591 693059 698045 700544 702454 702958 703142 708955 711671 712723 712829 712906 713146 716391 720667 720816 721475 721822 722099 722596 724274 729832 730556 732067 732171 735564 735570 736957 744572 746638 755746 759639 759847 766597 770176 772388 772885 774766 774767 775811 780612 781670 781734 782279 788194 788448 788458 789294 789527 789535 790752 794629 800685 802422 802433 802824 804092 804763 807451 807778 808175 808649 810600 810673 813717 814074 818770 821585 822194 823493 823909 825038 ] |
||||||||||||||||||||||||||||||
|
17.50 ms (4.40%) |
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 821585 813717 823493 525495 559078 563857 547915 550649 683745 720667 693059 703142 721822 689591 712723 720816 722099 722596 579668 605148 633860 800685 744572 790752 804092 807451 735564 755746 770176 732067 766597 698045 711671 775811 780612 788194 802422 804763 807778 808649 810673 66716 469874 491442 538660 568573 567863 569668 624854 759639 477455 528344 522566 491646 619526 382696 396887 409050 822194 814074 818770 823909 825038 538956 539460 686794 702958 712829 716391 721475 665247 675737 683524 684224 684943 712906 620199 781670 781734 788448 789535 774767 789294 789527 794629 802824 729832 802433 808175 810600 759847 772388 724274 735570 730556 732171 772885 736957 746638 700544 702454 708955 713146 774766 782279 788458 382937 395925 393462 394194 386060 384880 400425 400435 400443 400455 400471 402090 403190 403210 ] |
||||||||||||||||||||||||||||||
|
3.46 ms (0.87%) |
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 66716 382696 382937 384880 386060 393462 394194 395925 396887 400425 400435 400443 400455 400471 402090 403190 403210 409050 469874 477455 491442 491646 522566 525495 528344 538660 538956 539460 547915 550649 559078 563857 567863 568573 569668 579668 605148 619526 620199 624854 633860 665247 675737 683524 683745 684224 684943 686794 689591 693059 698045 700544 702454 702958 703142 708955 711671 712723 712829 712906 713146 716391 720667 720816 721475 721822 722099 722596 724274 729832 730556 732067 732171 735564 735570 736957 744572 746638 755746 759639 759847 766597 770176 772388 772885 774766 774767 775811 780612 781670 781734 782279 788194 788448 788458 789294 789527 789535 790752 794629 800685 802422 802433 802824 804092 804763 807451 807778 808175 808649 810600 810673 813717 814074 818770 821585 822194 823493 823909 825038 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old pussy lick"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old pussy лиза"
]
|
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.