Query Metrics
7
Database Queries
7
Different statements
151.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.89 ms (82.62%) |
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 97570 382408 397184 401427 418019 418155 418477 419969 422447 423533 431839 432408 438276 439511 440902 442155 446154 449248 450128 453661 454077 454763 456083 458190 461636 464745 466852 467819 469705 469813 469912 470700 473119 476405 476494 476889 479504 480012 480986 482648 485497 487609 490392 492348 492668 494597 496705 498123 498945 499719 499993 500963 501678 504331 505101 505680 506290 506893 508680 510302 511890 512062 512144 513252 517346 520386 524179 525990 527342 527749 534467 536977 537293 543530 547200 548039 553600 556603 557970 561367 563679 563762 568765 577179 578913 578929 579356 581405 588677 591945 592128 597742 599111 600197 601776 602448 603414 604952 605704 613217 614844 615980 619924 629249 632432 633917 640727 648630 658146 666401 669247 672052 672287 674284 676687 679618 685892 693962 707833 777496 ] |
||||||||||||||||||||||||||||||
|
16.88 ms (11.17%) |
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 777496 438276 458190 467819 469813 476405 476494 401427 418477 449248 473119 480012 397184 422447 423533 432408 446154 464745 469912 450128 454763 517346 496705 511890 513252 485497 418019 431839 499993 440902 419969 456083 466852 382408 454077 461636 439511 442155 557970 561367 666401 685892 707833 613217 418155 480986 490392 492348 476889 482648 506290 508680 512144 527342 498945 499719 504331 536977 501678 505101 534467 479504 553600 543530 568765 577179 581405 547200 548039 578929 579356 658146 679618 648630 669247 672052 672287 674284 693962 676687 556603 563679 563762 578913 591945 592128 602448 615980 633917 588677 597742 601776 604952 619924 632432 599111 600197 605704 629249 603414 614844 640727 453661 470700 500963 505680 512062 487609 494597 498123 492668 520386 527749 537293 97570 525990 510302 469705 506893 524179 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.62%) |
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 97570 382408 397184 401427 418019 418155 418477 419969 422447 423533 431839 432408 438276 439511 440902 442155 446154 449248 450128 453661 454077 454763 456083 458190 461636 464745 466852 467819 469705 469813 469912 470700 473119 476405 476494 476889 479504 480012 480986 482648 485497 487609 490392 492348 492668 494597 496705 498123 498945 499719 499993 500963 501678 504331 505101 505680 506290 506893 508680 510302 511890 512062 512144 513252 517346 520386 524179 525990 527342 527749 534467 536977 537293 543530 547200 548039 553600 556603 557970 561367 563679 563762 568765 577179 578913 578929 579356 581405 588677 591945 592128 597742 599111 600197 601776 602448 603414 604952 605704 613217 614844 615980 619924 629249 632432 633917 640727 648630 658146 666401 669247 672052 672287 674284 676687 679618 685892 693962 707833 777496 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"снимаем домашнее порн…"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"снима домашн любительск порн"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.97%) |
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.