Query Metrics
7
Database Queries
7
Different statements
163.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.55 ms (84.79%) |
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 38637 67698 233333 371547 382910 384908 386893 388453 389897 390230 395662 397714 398660 399563 399739 401440 401632 402164 402601 402931 403628 408657 412207 413294 417772 418358 420047 425288 425757 426463 428552 430969 431463 432189 433950 433996 440617 443443 445020 445237 451275 451605 453320 454939 456901 457509 460542 461625 462967 463379 465081 465841 465846 466661 466705 467392 469202 472349 472727 474315 474615 478554 483322 485912 487824 489308 491294 500698 504743 505186 510655 512702 513788 520706 521964 523303 527369 533467 538189 539442 539610 546572 548026 568136 586803 589365 589402 593227 608533 610421 616099 617096 620566 628720 668485 670748 672406 676342 676388 679396 693944 695851 709306 731526 736972 743096 748997 754799 756026 756671 757040 757667 763746 777799 784679 787880 789469 804184 804193 810048 ] |
||||||||||||||||||||||||||||||
|
14.52 ms (8.89%) |
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 589402 608533 777799 757040 787880 38637 398660 465841 466705 233333 474315 425288 510655 539442 763746 617096 709306 384908 401632 67698 538189 491294 693944 754799 451275 676388 784679 433950 430969 443443 454939 401440 474615 478554 425757 520706 500698 453320 757667 417772 402601 467392 462967 485912 731526 418358 463379 451605 431463 445237 521964 527369 487824 512702 756026 465846 568136 589365 616099 804193 789469 743096 390230 399563 428552 483322 408657 460542 382910 386893 402164 539610 523303 548026 668485 610421 804184 736972 388453 445020 472727 533467 676342 679396 546572 620566 586803 402931 403628 395662 469202 397714 426463 456901 461625 371547 413294 440617 489308 505186 513788 504743 672406 399739 465081 420047 412207 628720 389897 432189 433996 670748 695851 593227 810048 748997 756671 457509 466661 472349 ] |
||||||||||||||||||||||||||||||
|
3.29 ms (2.01%) |
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 38637 67698 233333 371547 382910 384908 386893 388453 389897 390230 395662 397714 398660 399563 399739 401440 401632 402164 402601 402931 403628 408657 412207 413294 417772 418358 420047 425288 425757 426463 428552 430969 431463 432189 433950 433996 440617 443443 445020 445237 451275 451605 453320 454939 456901 457509 460542 461625 462967 463379 465081 465841 465846 466661 466705 467392 469202 472349 472727 474315 474615 478554 483322 485912 487824 489308 491294 500698 504743 505186 510655 512702 513788 520706 521964 523303 527369 533467 538189 539442 539610 546572 548026 568136 586803 589365 589402 593227 608533 610421 616099 617096 620566 628720 668485 670748 672406 676342 676388 679396 693944 695851 709306 731526 736972 743096 748997 754799 756026 756671 757040 757667 763746 777799 784679 787880 789469 804184 804193 810048 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие красивая"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big this beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.99%) |
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.