Query Metrics
7
Database Queries
7
Different statements
154.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.42 ms (84.46%) |
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 33001 390663 396929 417284 422139 423322 423468 423529 425916 426147 427041 434581 443848 450148 450155 461241 469944 477126 481639 483296 485672 501482 503825 504559 511672 518800 527252 527697 540664 552562 559452 561247 574000 578226 591015 602547 603847 608753 616691 616826 622796 623422 624081 626182 630296 630347 631876 634617 636186 639984 641026 643573 650274 653004 659698 671245 693327 697135 699237 700868 722323 731396 755737 756829 761777 762989 763561 764266 764703 765827 766139 767419 769265 775799 777463 777499 777794 779803 780381 780742 780783 780830 780965 781578 781814 783003 783271 783922 784564 784682 786694 786774 787455 788387 788606 790529 790578 791219 791635 792175 792990 794060 794836 795498 796488 797765 798327 799045 799514 800523 800921 802335 804191 805117 807314 808768 809972 810171 812841 819141 ] |
||||||||||||||||||||||||||||||
|
12.95 ms (8.38%) |
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 477126 426147 33001 396929 425916 434581 819141 461241 469944 450155 450148 485672 503825 511672 527252 540664 481639 483296 559452 561247 552562 659698 653004 699237 722323 650274 671245 693327 697135 574000 578226 616826 634617 636186 626182 639984 643573 591015 608753 630296 630347 616691 622796 624081 631876 641026 777499 780381 783003 783271 788387 790578 792175 792990 795498 796488 797765 802335 805117 777794 780742 781814 784682 786694 791219 800523 808768 731396 755737 761777 762989 781578 784564 786774 788606 794836 800921 807314 810171 812841 764703 765827 769265 763561 764266 766139 767419 603847 775799 777463 779803 780783 780830 780965 783922 787455 790529 791635 794060 798327 799045 804191 809972 427041 423322 417284 443848 504559 527697 501482 623422 602547 518800 700868 756829 799514 390663 422139 423468 423529 ] |
||||||||||||||||||||||||||||||
|
3.84 ms (2.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mouth пов"
]
|
||||||||||||||||||||||||||||||
|
2.67 ms (1.73%) |
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 33001 390663 396929 417284 422139 423322 423468 423529 425916 426147 427041 434581 443848 450148 450155 461241 469944 477126 481639 483296 485672 501482 503825 504559 511672 518800 527252 527697 540664 552562 559452 561247 574000 578226 591015 602547 603847 608753 616691 616826 622796 623422 624081 626182 630296 630347 631876 634617 636186 639984 641026 643573 650274 653004 659698 671245 693327 697135 699237 700868 722323 731396 755737 756829 761777 762989 763561 764266 764703 765827 766139 767419 769265 775799 777463 777499 777794 779803 780381 780742 780783 780830 780965 781578 781814 783003 783271 783922 784564 784682 786694 786774 787455 788387 788606 790529 790578 791219 791635 792175 792990 794060 794836 795498 796488 797765 798327 799045 799514 800523 800921 802335 804191 805117 807314 808768 809972 810171 812841 819141 ] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mouth pov"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mouth пов"
]
|
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.