Query Metrics
7
Database Queries
7
Different statements
190.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.29 ms (86.85%) |
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 32585 53305 81775 249470 381767 386756 387529 388379 396453 398151 400005 401859 409730 412038 426326 448359 451681 452082 489403 489516 497894 503262 511812 512870 514700 520166 523303 525897 528854 531267 534419 538513 540125 540896 542640 549941 552951 553349 554286 554509 560655 565062 568048 570349 570627 571465 575421 576039 578501 588843 589687 590431 592692 593780 597195 597268 603059 603922 622403 625489 629792 635598 638373 644757 646375 648232 650336 651579 651876 655681 655686 655717 655737 656067 656367 657437 658336 659662 663890 664010 669339 673776 675467 675758 678783 681508 685955 688997 692050 692494 694908 696114 707155 714433 721428 721576 726408 727328 729886 735732 739073 745006 745035 748471 749733 763960 766793 789187 790239 790369 803732 810211 810472 810591 811355 811402 816071 819951 ] |
||||||||||||||||||||||||||||||
|
13.99 ms (7.35%) |
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 568048 635598 810211 766793 745035 644757 388379 32585 650336 622403 53305 675758 657437 658336 386756 540125 651579 673776 681508 721576 685955 692494 694908 646375 638373 588843 707155 810591 448359 826500 655686 664010 655737 656367 675467 381767 400005 525897 497894 726408 763960 745006 789187 803732 811355 811402 512870 554286 511812 489516 426326 387529 401859 552951 727328 735732 81775 249470 398151 412038 396453 409730 489403 531267 520166 528854 523303 452082 503262 534419 451681 538513 542640 514700 576039 571465 692050 575421 578501 597268 592692 603059 603922 629792 597195 790239 816071 549941 565062 678783 688997 714433 721428 651876 669339 696114 560655 570627 593780 625489 589687 590431 729886 790369 810472 749733 739073 748471 540896 823697 655717 659662 663890 656067 819951 554509 553349 570349 648232 655681 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (1.66%) |
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 32585 53305 81775 249470 381767 386756 387529 388379 396453 398151 400005 401859 409730 412038 426326 448359 451681 452082 489403 489516 497894 503262 511812 512870 514700 520166 523303 525897 528854 531267 534419 538513 540125 540896 542640 549941 552951 553349 554286 554509 560655 565062 568048 570349 570627 571465 575421 576039 578501 588843 589687 590431 592692 593780 597195 597268 603059 603922 622403 625489 629792 635598 638373 644757 646375 648232 650336 651579 651876 655681 655686 655717 655737 656067 656367 657437 658336 659662 663890 664010 669339 673776 675467 675758 678783 681508 685955 688997 692050 692494 694908 696114 707155 714433 721428 721576 726408 727328 729886 735732 739073 745006 745035 748471 749733 763960 766793 789187 790239 790369 803732 810211 810472 810591 811355 811402 816071 819951 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые большой большие член"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny big dick"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.92%) |
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.