Query Metrics
7
Database Queries
7
Different statements
364.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.45 ms (56.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
126.67 ms (34.80%) |
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 399156 417077 445273 529639 529785 531736 534368 537078 542438 553179 563536 568311 583930 590792 594547 595326 606670 610644 614485 615256 615487 619393 625092 628035 628254 630120 631522 636444 637485 639278 642276 642951 644144 646639 650269 651870 652566 653363 660622 669343 670751 671838 681729 682841 688500 693040 694452 695242 699431 699698 707076 708204 708908 713875 713894 713913 724872 725313 725779 726297 731065 731543 731913 736193 736343 738300 738376 739263 740303 745205 745905 746055 748800 750572 752275 752890 757444 757521 759899 762836 763844 764245 765061 765561 766344 766380 767344 768742 773421 776982 777748 778890 781008 782352 786380 790909 791827 794069 795748 797150 799445 800600 801538 802483 803425 803683 803857 804540 812178 812267 812284 814219 816586 820206 820511 823385 825448 826405 826723 828110 ] |
||||||||||||||||||||||||||||||
|
21.45 ms (5.89%) |
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 670751 681729 694452 713913 652566 671838 708204 553179 583930 644144 628254 637485 642276 781008 782352 790909 804540 786380 725313 762836 768742 812284 731065 740303 765061 731913 763844 736193 745905 746055 752890 610644 628035 794069 764245 767344 615487 799445 736343 802483 568311 653363 778890 563536 529639 606670 765561 725779 801538 399156 417077 814219 826723 826405 816586 820511 823385 820206 825448 828110 537078 531736 534368 542438 651870 669343 688500 695242 699431 699698 713894 646639 650269 708908 713875 660622 682841 693040 707076 619393 639278 590792 594547 625092 777748 803425 812178 731543 739263 803683 803857 738376 738300 748800 750572 745205 752275 766380 773421 724872 757444 766344 615256 776982 791827 797150 812267 445273 529785 631522 614485 595326 630120 636444 642951 795748 800600 759899 726297 757521 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (0.82%) |
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 399156 417077 445273 529639 529785 531736 534368 537078 542438 553179 563536 568311 583930 590792 594547 595326 606670 610644 614485 615256 615487 619393 625092 628035 628254 630120 631522 636444 637485 639278 642276 642951 644144 646639 650269 651870 652566 653363 660622 669343 670751 671838 681729 682841 688500 693040 694452 695242 699431 699698 707076 708204 708908 713875 713894 713913 724872 725313 725779 726297 731065 731543 731913 736193 736343 738300 738376 739263 740303 745205 745905 746055 748800 750572 752275 752890 757444 757521 759899 762836 763844 764245 765061 765561 766344 766380 767344 768742 773421 776982 777748 778890 781008 782352 786380 790909 791827 794069 795748 797150 799445 800600 801538 802483 803425 803683 803857 804540 812178 812267 812284 814219 816586 820206 820511 823385 825448 826405 826723 828110 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass video"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп video"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп video"
]
|
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.