Query Metrics
7
Database Queries
7
Different statements
158.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.81 ms (82.04%) |
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 414368 516686 517743 517842 519567 530010 530015 530275 530384 530489 530791 530941 531089 531202 531232 531235 531419 532172 532343 532653 532737 532790 532995 533382 533697 534647 535054 536291 536584 536586 537203 537771 537932 541846 550194 553272 582323 590411 596082 599847 599890 599914 599988 599994 600185 600268 600295 600321 600334 600342 600352 600354 600355 601046 601600 601625 617416 617428 621656 631178 632600 632646 632659 632690 633111 633741 633799 636299 636303 636304 636309 636991 637434 639717 639784 639790 640767 641678 642002 642018 642066 643376 644918 646025 646175 646448 646771 646786 646904 647939 648795 648815 648868 650175 651079 666586 666853 666892 668526 668534 676016 676092 676623 676632 677303 677674 677676 678053 678063 678493 678514 678529 679728 680130 683261 703833 708441 708447 716870 716887 ] |
||||||||||||||||||||||||||||||
|
16.99 ms (10.74%) |
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 646175 650175 676092 600354 643376 617416 414368 530010 531232 532790 537771 530489 532737 536586 530015 533697 679728 651079 646904 648815 632600 601625 600352 636303 600295 600342 640767 517842 519567 646448 532172 532653 596082 599994 600334 677303 633741 517743 666853 678493 678529 641678 632659 633799 537203 676632 648868 708441 708447 600185 642002 642018 633111 639717 536291 644918 530384 531202 532343 535054 530791 531089 531235 531419 582323 541846 646025 646771 648795 677674 678063 678514 683261 646786 666586 676623 599890 639784 600321 601600 642066 599914 600355 636304 636299 637434 639790 631178 632690 636309 703833 716887 680130 590411 534647 537932 716870 636991 533382 530941 550194 668526 668534 647939 621656 601046 600268 617428 632646 516686 599988 553272 676016 536584 530275 532995 599847 678053 666892 677676 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.94%) |
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 414368 516686 517743 517842 519567 530010 530015 530275 530384 530489 530791 530941 531089 531202 531232 531235 531419 532172 532343 532653 532737 532790 532995 533382 533697 534647 535054 536291 536584 536586 537203 537771 537932 541846 550194 553272 582323 590411 596082 599847 599890 599914 599988 599994 600185 600268 600295 600321 600334 600342 600352 600354 600355 601046 601600 601625 617416 617428 621656 631178 632600 632646 632659 632690 633111 633741 633799 636299 636303 636304 636309 636991 637434 639717 639784 639790 640767 641678 642002 642018 642066 643376 644918 646025 646175 646448 646771 646786 646904 647939 648795 648815 648868 650175 651079 666586 666853 666892 668526 668534 676016 676092 676623 676632 677303 677674 677676 678053 678063 678493 678514 678529 679728 680130 683261 703833 708441 708447 716870 716887 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"кастинг милф групповуха"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (1.33%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кастинг милф группов секс"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.20%) |
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.