Query Metrics
7
Database Queries
7
Different statements
469.69 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.97 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.84 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"фитнес мама"
]
|
||||||||||||||||||||||||||||||
| 3 | 11.76 ms |
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 473415 465306 582503 542925 483185 488625 506225 499525 676241 669747 642295 586985 506406 815798 825830 723643 814910 815388 815773 816576 817537 818283 816345 460017 515441 534281 522857 499885 531325 533198 560079 580916 569217 564765 674380 551070 552593 562881 600179 607464 604832 588350 597165 621315 785525 799802 801361 803073 803327 786763 737522 751627 766537 617825 632358 805925 806356 500439 618747 819238 571194 556818 591048 807522 793770 402661 407664 487368 563444 817504 817715 817930 821663 824761 817134 818329 819108 466753 514795 531945 531666 531842 540517 543904 543933 687127 692405 699654 723152 574210 597209 596853 598390 626563 630281 797298 798733 801826 781488 785432 803025 804302 785072 788141 735434 735504 799010 412639 452696 464601 591356 413049 425962 499964 511154 469351 576622 562938 519047 520711 ] |
||||||||||||||||||||||||||||||
| 4 | 4.21 ms |
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 402661 407664 412639 413049 425962 452696 460017 464601 465306 466753 469351 473415 483185 487368 488625 499525 499885 499964 500439 506225 506406 511154 514795 515441 519047 520711 522857 531325 531666 531842 531945 533198 534281 540517 542925 543904 543933 551070 552593 556818 560079 562881 562938 563444 564765 569217 571194 574210 576622 580916 582503 586985 588350 591048 591356 596853 597165 597209 598390 600179 604832 607464 617825 618747 621315 626563 630281 632358 642295 669747 674380 676241 687127 692405 699654 723152 723643 735434 735504 737522 751627 766537 781488 785072 785432 785525 786763 788141 793770 797298 798733 799010 799802 801361 801826 803025 803073 803327 804302 805925 806356 807522 814910 815388 815773 815798 816345 816576 817134 817504 817537 817715 817930 818283 818329 819108 819238 821663 824761 825830 ] |
||||||||||||||||||||||||||||||
| 5 | 238.68 ms |
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 402661 407664 412639 413049 425962 452696 460017 464601 465306 466753 469351 473415 483185 487368 488625 499525 499885 499964 500439 506225 506406 511154 514795 515441 519047 520711 522857 531325 531666 531842 531945 533198 534281 540517 542925 543904 543933 551070 552593 556818 560079 562881 562938 563444 564765 569217 571194 574210 576622 580916 582503 586985 588350 591048 591356 596853 597165 597209 598390 600179 604832 607464 617825 618747 621315 626563 630281 632358 642295 669747 674380 676241 687127 692405 699654 723152 723643 735434 735504 737522 751627 766537 781488 785072 785432 785525 786763 788141 793770 797298 798733 799010 799802 801361 801826 803025 803073 803327 804302 805925 806356 807522 814910 815388 815773 815798 816345 816576 817134 817504 817537 817715 817930 818283 818329 819108 819238 821663 824761 825830 ] |
||||||||||||||||||||||||||||||
| 6 | 209.46 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"спортивная мам женщин"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.76 ms |
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.