Query Metrics
7
Database Queries
7
Different statements
175.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.94 ms (84.81%) |
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 45357 121824 153922 176394 359075 363976 383797 389936 400942 401946 402661 404185 411591 418073 423516 427202 427621 429603 440819 443174 446533 448169 455065 457358 460318 464135 465923 466354 472606 475097 475861 476781 483194 498243 515606 515626 540117 542460 543723 552075 557815 563135 565123 575692 583875 589521 593111 602862 605129 611261 611760 613614 621717 630332 645861 671896 681230 685114 687118 687616 704345 708678 712558 714474 718229 721984 725403 728472 733602 745389 746028 749271 759033 759882 760969 761116 769616 772039 773404 779119 788778 790180 795197 796061 799983 800796 800859 802459 802937 803862 806002 806996 810467 813118 813770 814362 816062 817371 817740 817847 818577 822547 822590 823078 823355 823875 824118 824658 825366 825985 826125 826251 827281 827309 827562 827576 828306 828315 828507 828834 ] |
||||||||||||||||||||||||||||||
|
15.17 ms (8.64%) |
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 772039 714474 779119 800859 404185 515626 645861 440819 427621 448169 457358 401946 400942 817371 816062 475097 515606 563135 593111 602862 621717 802459 813118 759882 749271 761116 475861 389936 383797 823875 827309 824118 818577 828306 828315 466354 540117 687118 583875 810467 795197 759033 760969 423516 460318 476781 712558 605129 402661 176394 813770 708678 800796 806002 725403 733602 803862 153922 359075 455065 472606 687616 671896 681230 557815 788778 790180 728472 746028 769616 611760 630332 799983 802937 45357 498243 483194 427202 446533 465923 611261 773404 429603 411591 418073 464135 443174 121824 363976 824658 825985 826251 827281 827576 827562 826125 828834 828507 542460 704345 685114 589521 613614 796061 806996 745389 718229 822590 822547 825366 814362 823355 817740 817847 823078 565123 575692 543723 721984 552075 ] |
||||||||||||||||||||||||||||||
|
3.56 ms (2.03%) |
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 45357 121824 153922 176394 359075 363976 383797 389936 400942 401946 402661 404185 411591 418073 423516 427202 427621 429603 440819 443174 446533 448169 455065 457358 460318 464135 465923 466354 472606 475097 475861 476781 483194 498243 515606 515626 540117 542460 543723 552075 557815 563135 565123 575692 583875 589521 593111 602862 605129 611261 611760 613614 621717 630332 645861 671896 681230 685114 687118 687616 704345 708678 712558 714474 718229 721984 725403 728472 733602 745389 746028 749271 759033 759882 760969 761116 769616 772039 773404 779119 788778 790180 795197 796061 799983 800796 800859 802459 802937 803862 806002 806996 810467 813118 813770 814362 816062 817371 817740 817847 818577 822547 822590 823078 823355 823875 824118 824658 825366 825985 826125 826251 827281 827309 827562 827576 828306 828315 828507 828834 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sexy mother"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sexy мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sexy мам женщин"
]
|
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.