Query Metrics
7
Database Queries
7
Different statements
160.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.05 ms (87.36%) |
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 480495 527764 529639 529785 531736 534368 537078 542438 563536 566005 568311 592523 594547 595326 599304 606670 610644 614485 615256 615487 619393 625092 628035 628254 630120 631522 631793 636444 637485 639278 642276 642951 646639 650269 651870 653363 660622 668111 669343 682841 688500 693040 695242 696108 699431 699698 707076 708908 713875 713894 724872 725313 726297 731065 731543 731913 736193 736343 738300 738376 739263 740303 745205 745905 746055 748800 750572 752275 752890 757444 757521 759899 762836 763844 763917 764245 765061 765561 766344 767344 768742 773421 776982 777748 778890 781008 782352 786380 790909 791827 794069 794752 795748 797150 799445 800600 801538 802483 803425 803683 803857 804540 805661 812178 812267 812284 814219 816586 817264 820206 820511 822730 823385 825448 826405 826723 828110 ] |
||||||||||||||||||||||||||||||
|
11.16 ms (6.96%) |
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 628254 637485 642276 781008 782352 790909 804540 786380 725313 762836 768742 812284 731065 740303 765061 731913 763844 736193 745905 746055 752890 610644 628035 794069 668111 764245 767344 599304 615487 799445 736343 763917 802483 568311 653363 778890 563536 529639 606670 765561 801538 805661 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 594547 625092 777748 803425 812178 731543 739263 803683 803857 738376 738300 748800 750572 745205 752275 773421 724872 757444 766344 615256 776982 791827 797150 812267 445273 529785 696108 631522 614485 595326 630120 636444 642951 795748 800600 759899 726297 757521 480495 817264 822730 527764 566005 631793 592523 794752 ] |
||||||||||||||||||||||||||||||
|
2.24 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 399156 417077 445273 480495 527764 529639 529785 531736 534368 537078 542438 563536 566005 568311 592523 594547 595326 599304 606670 610644 614485 615256 615487 619393 625092 628035 628254 630120 631522 631793 636444 637485 639278 642276 642951 646639 650269 651870 653363 660622 668111 669343 682841 688500 693040 695242 696108 699431 699698 707076 708908 713875 713894 724872 725313 726297 731065 731543 731913 736193 736343 738300 738376 739263 740303 745205 745905 746055 748800 750572 752275 752890 757444 757521 759899 762836 763844 763917 764245 765061 765561 766344 767344 768742 773421 776982 777748 778890 781008 782352 786380 790909 791827 794069 794752 795748 797150 799445 800600 801538 802483 803425 803683 803857 804540 805661 812178 812267 812284 814219 816586 817264 820206 820511 822730 823385 825448 826405 826723 828110 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"video жоп"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"video ass"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"video жоп"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.95%) |
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.