Query Metrics
7
Database Queries
7
Different statements
177.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.88 ms (83.91%) |
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 6937 36977 263759 350425 383408 390729 394116 395460 402882 403663 404281 404384 413569 414807 417226 417519 417767 419078 419835 420696 423941 424955 429555 433898 434115 438763 441714 445141 445524 445531 445955 451421 451967 453017 453798 454059 454642 454720 455819 455826 456931 457903 457936 458339 459958 459973 460247 462481 463536 463562 463590 463602 464833 467987 468118 468192 468992 478060 482014 484520 487859 494112 497118 499012 499525 499650 499821 502195 505878 510847 513917 514423 516501 520985 521888 523804 524956 525533 525552 527068 528595 529251 535672 537943 541878 546607 548618 553842 554763 555702 559978 560784 561638 565015 570757 571317 572919 581922 582503 586610 589251 593156 598836 605302 609597 611204 622472 634372 712888 724287 770764 777371 784589 788228 788533 789389 793404 802346 806530 810803 ] |
||||||||||||||||||||||||||||||
|
17.10 ms (9.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 777371 806530 788228 810803 36977 390729 433898 445141 451967 454059 454642 458339 467987 468118 451421 478060 454720 513917 499821 494112 468992 582503 541878 555702 561638 546607 598836 414807 463562 464833 453798 455819 423941 429555 453017 445955 455826 460247 516501 524956 525552 487859 535672 537943 497118 499525 514423 521888 505878 525533 529251 770764 404281 457903 445524 445531 459958 462481 502195 420696 417519 424955 510847 523804 528595 520985 383408 394116 395460 263759 350425 404384 403663 419078 434115 457936 459973 482014 456931 463590 484520 499012 499650 527068 463536 463602 548618 553842 560784 571317 572919 581922 554763 570757 559978 565015 712888 589251 593156 609597 634372 586610 605302 611204 784589 789389 802346 724287 622472 788533 793404 6937 413569 417226 438763 441714 402882 468192 417767 419835 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.54%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп спортивная"
]
|
||||||||||||||||||||||||||||||
|
2.67 ms (1.50%) |
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 6937 36977 263759 350425 383408 390729 394116 395460 402882 403663 404281 404384 413569 414807 417226 417519 417767 419078 419835 420696 423941 424955 429555 433898 434115 438763 441714 445141 445524 445531 445955 451421 451967 453017 453798 454059 454642 454720 455819 455826 456931 457903 457936 458339 459958 459973 460247 462481 463536 463562 463590 463602 464833 467987 468118 468192 468992 478060 482014 484520 487859 494112 497118 499012 499525 499650 499821 502195 505878 510847 513917 514423 516501 520985 521888 523804 524956 525533 525552 527068 528595 529251 535672 537943 541878 546607 548618 553842 554763 555702 559978 560784 561638 565015 570757 571317 572919 581922 582503 586610 589251 593156 598836 605302 609597 611204 622472 634372 712888 724287 770764 777371 784589 788228 788533 789389 793404 802346 806530 810803 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass sport"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп спортивная"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.07%) |
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.