Query Metrics
7
Database Queries
7
Different statements
358.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
216.15 ms (60.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая жен"
]
|
||||||||||||||||||||||||||||||
|
121.77 ms (34.01%) |
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 91603 365945 382520 398576 398660 402973 403660 403938 412222 421484 429471 434541 437676 458133 458782 463379 464046 466705 472990 474911 487824 490479 504538 508946 537045 537486 540730 541847 558268 558948 559421 565227 570121 586985 601398 621562 621959 629124 644734 648659 648754 653883 660461 668062 669256 669259 671484 673017 676767 679512 681756 689167 689458 693905 694388 705009 707551 709862 710333 718908 719954 720265 724096 725088 730699 730730 731043 734130 735186 735187 737252 739028 740664 744027 744751 746934 750134 752013 753529 754651 754879 755602 757040 757940 759029 760285 761336 761770 768522 770030 775677 778086 778647 779846 780225 781007 781120 786136 787648 787653 787657 787880 788467 789263 790236 790498 791622 792455 793647 795293 797290 797575 801096 802373 803734 804075 806537 806599 810362 811543 ] |
||||||||||||||||||||||||||||||
|
12.58 ms (3.51%) |
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 797575 810362 91603 382520 565227 779846 778086 753529 775677 778647 403938 421484 365945 490479 434541 761770 734130 754879 558268 689167 676767 802373 737252 739028 746934 720265 789263 797290 472990 761336 709862 648754 601398 757940 787648 787653 788467 724096 740664 437676 537045 570121 586985 757040 768522 787880 398660 466705 412222 463379 487824 671484 793647 801096 754651 559421 673017 660461 653883 669256 558948 780225 787657 750134 806537 811543 752013 770030 730730 731043 760285 735186 781007 403660 707551 795293 458133 398576 464046 541847 790498 803734 402973 474911 508946 429471 458782 504538 537486 540730 648659 679512 693905 694388 718908 668062 681756 689458 705009 710333 669259 719954 621562 621959 629124 644734 792455 804075 781120 786136 790236 791622 806599 725088 730699 735187 744027 744751 755602 759029 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (0.69%) |
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 91603 365945 382520 398576 398660 402973 403660 403938 412222 421484 429471 434541 437676 458133 458782 463379 464046 466705 472990 474911 487824 490479 504538 508946 537045 537486 540730 541847 558268 558948 559421 565227 570121 586985 601398 621562 621959 629124 644734 648659 648754 653883 660461 668062 669256 669259 671484 673017 676767 679512 681756 689167 689458 693905 694388 705009 707551 709862 710333 718908 719954 720265 724096 725088 730699 730730 731043 734130 735186 735187 737252 739028 740664 744027 744751 746934 750134 752013 753529 754651 754879 755602 757040 757940 759029 760285 761336 761770 768522 770030 775677 778086 778647 779846 780225 781007 781120 786136 787648 787653 787657 787880 788467 789263 790236 790498 791622 792455 793647 795293 797290 797575 801096 802373 803734 804075 806537 806599 810362 811543 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"красотка измена"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая жен"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.