Query Metrics
7
Database Queries
7
Different statements
382.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
228.14 ms (59.70%) |
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 725638 735821 759553 772532 744698 754141 715083 776396 789182 402238 504184 575094 575115 575795 576416 557983 570064 558072 566081 589015 419674 475613 465805 473955 464320 478361 508835 484038 503951 491212 491488 494367 511878 484851 488735 821976 396554 598465 581965 598683 595520 463766 600069 575802 567429 545517 439844 525873 439652 597215 444121 500415 817482 821860 825500 821870 825694 825781 816764 817317 825661 825693 821829 821834 821864 517552 499458 543725 548401 564416 566886 584666 554068 565044 572197 652892 654775 662436 677015 679124 693341 714455 714477 714491 720985 666020 673092 676473 679380 701501 718708 720786 721400 721408 677383 679385 712907 714442 714469 714498 714948 718705 720803 720821 721447 545959 596166 603003 617603 595470 595869 598679 600894 614110 626330 595451 597072 599011 604350 616000 ] |
||||||||||||||||||||||||||||||
|
143.33 ms (37.51%) |
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 396554 402238 419674 439652 439844 444121 463766 464320 465805 473955 475613 478361 484038 484851 488735 491212 491488 494367 499458 500415 503951 504184 508835 511878 517552 525873 543725 545517 545959 548401 554068 557983 558072 564416 565044 566081 566886 567429 570064 572197 575094 575115 575795 575802 576416 581965 584666 589015 595451 595470 595520 595869 596166 597072 597215 598465 598679 598683 599011 600069 600894 603003 604350 614110 616000 617603 626330 652892 654775 662436 666020 673092 676473 677015 677383 679124 679380 679385 693341 701501 712907 714442 714455 714469 714477 714491 714498 714948 715083 718705 718708 720786 720803 720821 720985 721400 721408 721447 725638 735821 744698 754141 759553 772532 776396 789182 816764 817317 817482 821829 821834 821860 821864 821870 821976 825500 825661 825693 825694 825781 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (0.74%) |
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 396554 402238 419674 439652 439844 444121 463766 464320 465805 473955 475613 478361 484038 484851 488735 491212 491488 494367 499458 500415 503951 504184 508835 511878 517552 525873 543725 545517 545959 548401 554068 557983 558072 564416 565044 566081 566886 567429 570064 572197 575094 575115 575795 575802 576416 581965 584666 589015 595451 595470 595520 595869 596166 597072 597215 598465 598679 598683 599011 600069 600894 603003 604350 614110 616000 617603 626330 652892 654775 662436 666020 673092 676473 677015 677383 679124 679380 679385 693341 701501 712907 714442 714455 714469 714477 714491 714498 714948 715083 718705 718708 720786 720803 720821 720985 721400 721408 721447 725638 735821 744698 754141 759553 772532 776396 789182 816764 817317 817482 821829 821834 821860 821864 821870 821976 825500 825661 825693 825694 825781 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"зрелый с молодой русской"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (0.52%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"зрелый мужчин молодой русск"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.51%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.42%) |
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.