Query Metrics
7
Database Queries
7
Different statements
188.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.18 ms (85.35%) |
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 2189 38909 73289 82080 107060 147369 260576 312730 338993 359011 382024 382543 383431 383658 383971 384850 385125 386384 393129 395326 395450 397210 397761 398432 401641 404479 405234 411118 412000 412095 420126 424609 427131 430450 431916 444243 452390 452408 453259 459598 459738 460485 467817 475339 482606 507808 510841 526678 532460 535100 539265 541169 545099 546575 546683 547606 547910 550678 553700 554352 555234 557726 557910 558750 559685 560732 561027 564242 566025 567413 571817 579332 583941 596252 597927 599623 601508 601747 603428 616222 627946 629541 630686 634737 636557 638963 643991 649318 653245 664222 678872 688999 694930 696096 701451 714955 720758 729863 744675 749138 756343 758983 759812 765036 768023 768380 774880 775518 777521 779048 779468 781575 786098 791942 794993 798055 801796 806329 809964 813308 ] |
||||||||||||||||||||||||||||||
|
16.54 ms (8.76%) |
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 765036 634737 638963 701451 714955 775518 777521 779048 779468 791942 801796 806329 809964 383431 385125 2189 397761 312730 73289 412000 768023 395326 260576 82080 398432 571817 664222 601508 627946 555234 630686 678872 147369 395450 338993 359011 382024 401641 430450 431916 452408 453259 482606 653245 696096 720758 596252 813308 781575 729863 759812 749138 774880 107060 38909 412095 383658 444243 384850 405234 475339 460485 467817 597927 535100 557910 545099 382543 547910 459598 553700 558750 546683 526678 507808 567413 546575 649318 694930 688999 550678 599623 420126 383971 510841 532460 539265 554352 557726 541169 561027 566025 583941 616222 601747 643991 786098 794993 798055 629541 427131 404479 424609 452390 756343 744675 768380 758983 603428 636557 386384 393129 397210 411118 564242 459738 547606 559685 560732 579332 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (1.80%) |
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 2189 38909 73289 82080 107060 147369 260576 312730 338993 359011 382024 382543 383431 383658 383971 384850 385125 386384 393129 395326 395450 397210 397761 398432 401641 404479 405234 411118 412000 412095 420126 424609 427131 430450 431916 444243 452390 452408 453259 459598 459738 460485 467817 475339 482606 507808 510841 526678 532460 535100 539265 541169 545099 546575 546683 547606 547910 550678 553700 554352 555234 557726 557910 558750 559685 560732 561027 564242 566025 567413 571817 579332 583941 596252 597927 599623 601508 601747 603428 616222 627946 629541 630686 634737 636557 638963 643991 649318 653245 664222 678872 688999 694930 696096 701451 714955 720758 729863 744675 749138 756343 758983 759812 765036 768023 768380 774880 775518 777521 779048 779468 781575 786098 791942 794993 798055 801796 806329 809964 813308 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"на лиц"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на лиц"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.90%) |
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.