Query Metrics
7
Database Queries
7
Different statements
213.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
189.01 ms (88.55%) |
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 181851 417246 419822 443496 452815 459778 466427 483705 490952 493618 505613 541322 543208 543500 543904 544173 544909 545971 548895 550218 555224 555772 557455 558981 559422 560395 563730 564299 566820 571132 575672 576528 576566 578741 578750 583674 583919 585172 586732 606071 607468 610237 630074 633060 639795 640156 641456 643087 644172 645358 650080 660728 666623 669265 675512 681746 693254 694550 699938 709855 713429 719830 722260 725234 725379 726814 727290 727545 728337 728368 728376 731808 732178 734575 735452 736339 738927 740674 743225 744187 745746 745867 748175 750347 752618 754704 757483 760566 760725 761523 771865 772881 775563 776317 776956 777268 781305 784180 786316 788109 789409 790808 792654 794300 795867 796445 799750 799752 801041 801150 801287 801315 801544 802446 804342 806990 807157 812349 814232 814525 ] |
||||||||||||||||||||||||||||||
|
14.23 ms (6.67%) |
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 555224 575672 583919 543208 543500 543904 544173 557455 563730 564299 583674 548895 555772 558981 576566 578741 694550 713429 650080 660728 719830 722260 645358 669265 675512 699938 544909 559422 566820 576528 578750 610237 607468 633060 644172 585172 586732 606071 630074 639795 643087 775563 794300 796445 799750 806990 776956 781305 789409 801150 801315 801544 804342 725234 752618 761523 772881 784180 786316 788109 790808 799752 812349 726814 734575 745867 748175 725379 727290 728337 735452 738927 745746 731808 732178 743225 750347 754704 740674 760566 760725 771865 641456 709855 777268 792654 801041 802446 181851 814525 466427 693254 681746 640156 776317 807157 727545 744187 757483 417246 443496 493618 459778 666623 419822 452815 571132 728376 736339 483705 801287 550218 505613 490952 795867 728368 814232 541322 545971 560395 ] |
||||||||||||||||||||||||||||||
|
3.33 ms (1.56%) |
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 181851 417246 419822 443496 452815 459778 466427 483705 490952 493618 505613 541322 543208 543500 543904 544173 544909 545971 548895 550218 555224 555772 557455 558981 559422 560395 563730 564299 566820 571132 575672 576528 576566 578741 578750 583674 583919 585172 586732 606071 607468 610237 630074 633060 639795 640156 641456 643087 644172 645358 650080 660728 666623 669265 675512 681746 693254 694550 699938 709855 713429 719830 722260 725234 725379 726814 727290 727545 728337 728368 728376 731808 732178 734575 735452 736339 738927 740674 743225 744187 745746 745867 748175 750347 752618 754704 757483 760566 760725 761523 771865 772881 775563 776317 776956 777268 781305 784180 786316 788109 789409 790808 792654 794300 795867 796445 799750 799752 801041 801150 801287 801315 801544 802446 804342 806990 807157 812349 814232 814525 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп большая большие дырк"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие жоп большая большие дырк"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass gape"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.