Query Metrics
7
Database Queries
7
Different statements
172.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.14 ms (86.99%) |
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 98711 188293 384053 384578 391266 397771 401970 422704 460440 483349 484749 488631 511432 522144 525103 526681 533022 533723 536508 538535 542441 543446 543997 547520 550626 566265 567813 569187 575692 576579 588481 589705 595975 596513 610493 614354 616705 617208 628755 630205 631547 642689 646858 658468 659425 663098 663468 664175 664252 664295 666416 673126 674357 675513 677450 682841 683715 693694 693991 694692 698135 698386 699235 702062 706784 707174 715692 716240 719677 720962 721755 722540 725483 729737 730855 740726 750859 755548 765308 768370 774909 777789 778572 786091 786422 788560 791332 792556 793371 801019 801279 801424 802437 803318 803613 803820 804375 804615 805608 805791 808214 808524 810544 813068 813697 816020 816712 816941 817473 817497 818158 819152 819181 820729 823713 824626 824764 827725 827735 ] |
||||||||||||||||||||||||||||||
|
12.89 ms (7.47%) |
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 664252 707174 391266 646858 617208 801424 755548 765308 698386 803820 813068 384578 823713 522144 525103 536508 542441 543997 567813 706784 663468 693991 694692 721755 664175 664295 699235 588481 778572 801019 810544 792556 808524 750859 768370 698135 803613 804375 808214 188293 397771 422704 484749 804615 384053 98711 401970 816941 819181 774419 816712 817473 824626 827725 816020 817497 818158 820729 813697 819152 824764 827735 483349 488631 511432 538535 533723 526681 533022 460440 550626 575692 543446 547520 569187 576579 659425 675513 702062 716240 663098 666416 677450 693694 658468 673126 674357 682841 683715 715692 719677 720962 722540 566265 589705 628755 630205 642689 610493 616705 595975 596513 614354 631547 786422 802437 805608 805791 774909 777789 786091 788560 791332 793371 801279 803318 725483 729737 730855 740726 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.40%) |
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 98711 188293 384053 384578 391266 397771 401970 422704 460440 483349 484749 488631 511432 522144 525103 526681 533022 533723 536508 538535 542441 543446 543997 547520 550626 566265 567813 569187 575692 576579 588481 589705 595975 596513 610493 614354 616705 617208 628755 630205 631547 642689 646858 658468 659425 663098 663468 664175 664252 664295 666416 673126 674357 675513 677450 682841 683715 693694 693991 694692 698135 698386 699235 702062 706784 707174 715692 716240 719677 720962 721755 722540 725483 729737 730855 740726 750859 755548 765308 768370 774909 777789 778572 786091 786422 788560 791332 792556 793371 801019 801279 801424 802437 803318 803613 803820 804375 804615 805608 805791 808214 808524 810544 813068 813697 816020 816712 816941 817473 817497 818158 819152 819181 820729 823713 824626 824764 827725 827735 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big hot"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие hot"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие hot"
]
|
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.