Query Metrics
7
Database Queries
7
Different statements
156.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.31 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 13166 382017 385633 386717 391508 395379 396408 396748 402018 408586 418851 429278 429566 432753 436485 441427 441485 444109 447146 452664 464573 471172 476728 493308 499777 502164 505285 506216 506850 512651 518520 521245 525658 528340 528901 532661 540313 540429 541268 550341 551211 551973 560952 564080 570409 573276 577593 585254 587587 590409 594283 597522 597983 599448 600123 600172 605825 612438 616025 617185 620990 623200 623204 624759 634155 640732 644674 651926 652519 659448 669296 671085 672472 673448 679687 680374 680625 695872 701114 701131 703713 704971 705832 718739 720096 722019 724143 727052 727811 733847 733861 733873 733902 735103 736345 740653 741284 742439 744266 746884 747237 748530 751110 751309 754175 760471 762296 766337 769743 771177 777173 777921 785777 786052 786301 786354 787632 797006 813268 817317 ] |
||||||||||||||||||||||||||||||
|
14.85 ms (9.48%) |
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 762296 740653 744266 754175 760471 742439 746884 766337 701114 701131 722019 786354 797006 385633 436485 396408 532661 382017 441427 441485 471172 505285 506216 528340 493308 550341 570409 671085 672472 695872 652519 659448 680374 704971 718739 720096 651926 669296 673448 679687 680625 703713 587587 597522 605825 624759 585254 590409 599448 612438 594283 597983 600172 786301 785777 724143 733902 736345 747237 786052 733847 735103 751309 727811 733873 727052 733861 769743 771177 741284 751110 617185 777173 777921 787632 813268 408586 386717 402018 432753 512651 499777 577593 705832 600123 616025 640732 623200 634155 623204 748530 620990 644674 447146 395379 391508 13166 396748 444109 418851 429278 429566 817317 452664 476728 521245 525658 540429 506850 518520 528901 502164 540313 464573 551211 551973 564080 560952 541268 573276 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.85%) |
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 13166 382017 385633 386717 391508 395379 396408 396748 402018 408586 418851 429278 429566 432753 436485 441427 441485 444109 447146 452664 464573 471172 476728 493308 499777 502164 505285 506216 506850 512651 518520 521245 525658 528340 528901 532661 540313 540429 541268 550341 551211 551973 560952 564080 570409 573276 577593 585254 587587 590409 594283 597522 597983 599448 600123 600172 605825 612438 616025 617185 620990 623200 623204 624759 634155 640732 644674 651926 652519 659448 669296 671085 672472 673448 679687 680374 680625 695872 701114 701131 703713 704971 705832 718739 720096 722019 724143 727052 727811 733847 733861 733873 733902 735103 736345 740653 741284 742439 744266 746884 747237 748530 751110 751309 754175 760471 762296 766337 769743 771177 777173 777921 785777 786052 786301 786354 787632 797006 813268 817317 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sweet teen"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"милая teen"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"милая teen"
]
|
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.