Query Metrics
7
Database Queries
7
Different statements
142.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.18 ms (83.20%) |
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 77381 290304 341622 390571 393308 410239 411808 415946 417053 418876 423663 432622 432692 433204 433230 433343 434443 441207 441430 445802 446645 448340 452862 462777 465125 466731 467947 468373 482059 483791 493186 495008 497264 497708 500241 511867 512355 513505 514415 517624 524807 528475 538253 540684 543353 543970 544200 545763 547554 548642 548649 549026 549033 550929 551441 553020 554797 555101 555186 555219 555360 555377 555397 555453 555486 555768 556616 556659 557958 558126 558244 560564 561300 562462 563542 563776 564163 568951 571009 571113 574060 578796 580340 591782 594280 595421 597987 603074 614858 615214 615660 620585 626944 627349 637054 637111 651954 666892 666895 669258 684489 685063 690784 710535 712073 712318 728620 730813 740115 752147 757054 762241 775202 785921 794382 795313 796351 800990 802202 804386 ] |
||||||||||||||||||||||||||||||
|
13.66 ms (9.62%) |
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 637111 594280 595421 465125 441207 448340 483791 524807 417053 445802 497708 558126 390571 433343 462777 512355 514415 497264 545763 666895 553020 684489 467947 468373 540684 511867 517624 528475 555219 543970 544200 555397 571009 554797 556616 563542 563776 669258 690784 561300 615660 591782 620585 796351 740115 441430 452862 493186 555486 555186 555377 578796 555360 562462 411808 410239 466731 551441 543353 548649 290304 513505 558244 666892 614858 547554 557958 549026 482059 615214 626944 685063 804386 794382 651954 500241 580340 341622 432622 538253 495008 550929 555453 555768 564163 568951 571113 555101 574060 710535 712073 712318 549033 556659 597987 603074 775202 802202 785921 795313 800990 757054 728620 730813 752147 762241 627349 637054 560564 548642 434443 393308 77381 418876 423663 432692 433204 433230 415946 446645 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (2.05%) |
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 77381 290304 341622 390571 393308 410239 411808 415946 417053 418876 423663 432622 432692 433204 433230 433343 434443 441207 441430 445802 446645 448340 452862 462777 465125 466731 467947 468373 482059 483791 493186 495008 497264 497708 500241 511867 512355 513505 514415 517624 524807 528475 538253 540684 543353 543970 544200 545763 547554 548642 548649 549026 549033 550929 551441 553020 554797 555101 555186 555219 555360 555377 555397 555453 555486 555768 556616 556659 557958 558126 558244 560564 561300 562462 563542 563776 564163 568951 571009 571113 574060 578796 580340 591782 594280 595421 597987 603074 614858 615214 615660 620585 626944 627349 637054 637111 651954 666892 666895 669258 684489 685063 690784 710535 712073 712318 728620 730813 740115 752147 757054 762241 775202 785921 794382 795313 796351 800990 802202 804386 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сперма в дырку"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм в дырк"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм в дырк"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.16%) |
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.