Query Metrics
7
Database Queries
7
Different statements
200.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.24 ms (83.53%) |
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 370715 385562 414516 419420 419855 422543 422591 422661 422710 422853 422923 422978 422997 423023 423057 423212 423271 423283 423396 423401 426075 429208 430650 442290 452244 452245 452473 453150 454058 456249 457145 457553 462749 464097 464952 466930 470792 474025 475089 475222 476283 477216 477957 482096 485197 485561 485902 487450 491589 492601 493015 501547 501569 501866 506772 508076 509407 513070 513290 515450 515475 517782 518456 521371 525401 525653 526206 526936 527183 527234 531474 531485 533455 535581 535641 536688 536738 538774 539174 564407 594007 597487 600016 603436 605105 609886 618672 620768 622392 624282 624299 624864 625826 630266 632969 637689 640741 640785 641857 703089 708741 721109 725112 727082 729818 732243 732347 733844 734506 740596 741539 747004 748236 750499 750527 757156 758180 758226 812937 815033 ] |
||||||||||||||||||||||||||||||
|
22.74 ms (11.36%) |
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 618672 624299 624864 637689 594007 597487 600016 624282 640741 640785 641857 729818 750499 812937 725112 732347 733844 750527 734506 741539 758180 732243 740596 748236 727082 747004 757156 758226 603436 609886 620768 622392 625826 630266 632969 703089 708741 721109 423401 464952 475089 477957 482096 423271 385562 414516 423396 430650 422543 422710 422853 426075 453150 470792 477216 422923 508076 513290 517782 525653 485561 485902 513070 526936 492601 501547 509407 485197 491589 493015 501866 515450 527183 538774 564407 605105 370715 419420 422978 423023 423057 419855 422661 422997 423212 429208 442290 422591 423283 815033 452245 457553 466930 474025 475222 452244 452473 456249 476283 454058 457145 462749 464097 487450 526206 536688 539174 515475 518456 521371 531474 531485 536738 527234 533455 535581 535641 501569 506772 525401 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.39%) |
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 370715 385562 414516 419420 419855 422543 422591 422661 422710 422853 422923 422978 422997 423023 423057 423212 423271 423283 423396 423401 426075 429208 430650 442290 452244 452245 452473 453150 454058 456249 457145 457553 462749 464097 464952 466930 470792 474025 475089 475222 476283 477216 477957 482096 485197 485561 485902 487450 491589 492601 493015 501547 501569 501866 506772 508076 509407 513070 513290 515450 515475 517782 518456 521371 525401 525653 526206 526936 527183 527234 531474 531485 533455 535581 535641 536688 536738 538774 539174 564407 594007 597487 600016 603436 605105 609886 618672 620768 622392 624282 624299 624864 625826 630266 632969 637689 640741 640785 641857 703089 708741 721109 725112 727082 729818 732243 732347 733844 734506 740596 741539 747004 748236 750499 750527 757156 758180 758226 812937 815033 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"casting old"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кастинг old"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"кастинг old"
]
|
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.