Query Metrics
7
Database Queries
7
Different statements
175.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.52 ms (83.12%) |
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 382928 385202 388653 411477 417050 417929 423981 425694 428009 429523 438638 441209 441237 442979 443510 445050 446698 449592 451316 451875 454844 456109 457294 458916 459085 460561 463716 464194 466635 467568 468213 471425 471780 478488 478931 481673 481806 482610 482773 492126 495418 496527 496708 498830 499174 499177 499336 503241 504876 505090 505172 505667 505797 507946 508427 509543 511291 516655 516666 518405 519392 520213 521550 521788 524440 524859 524866 526073 528035 528815 529403 531907 534825 544640 554445 556330 556699 558581 560314 579171 580472 580941 582393 583593 584212 588249 592259 594868 597947 601035 601981 603684 603977 604505 605224 614715 617214 621689 622264 626082 626737 630915 633515 633972 635490 644917 653956 667826 675107 675144 675429 675431 675660 675675 675723 675725 712775 727744 733573 792817 ] |
||||||||||||||||||||||||||||||
|
18.39 ms (10.51%) |
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 428009 441209 464194 460561 505172 499177 505090 667826 417929 604505 601981 478488 466635 456109 504876 503241 385202 388653 481806 792817 454844 505667 521550 675107 675675 675660 675144 675723 560314 622264 459085 529403 521788 592259 458916 468213 603977 633515 528035 417050 531907 626737 467568 534825 528815 496708 516666 582393 653956 579171 583593 597947 633972 526073 492126 443510 482610 495418 588249 508427 441237 411477 644917 482773 451875 451316 449592 520213 518405 511291 584212 605224 614715 733573 626082 423981 438638 499174 509543 516655 445050 499336 507946 580941 675429 675431 675725 712775 603684 635490 498830 580472 554445 617214 463716 524859 558581 630915 471780 621689 727744 446698 478931 481673 471425 382928 425694 519392 505797 594868 442979 524866 601035 429523 457294 524440 496527 556330 544640 556699 ] |
||||||||||||||||||||||||||||||
|
3.84 ms (2.19%) |
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 382928 385202 388653 411477 417050 417929 423981 425694 428009 429523 438638 441209 441237 442979 443510 445050 446698 449592 451316 451875 454844 456109 457294 458916 459085 460561 463716 464194 466635 467568 468213 471425 471780 478488 478931 481673 481806 482610 482773 492126 495418 496527 496708 498830 499174 499177 499336 503241 504876 505090 505172 505667 505797 507946 508427 509543 511291 516655 516666 518405 519392 520213 521550 521788 524440 524859 524866 526073 528035 528815 529403 531907 534825 544640 554445 556330 556699 558581 560314 579171 580472 580941 582393 583593 584212 588249 592259 594868 597947 601035 601981 603684 603977 604505 605224 614715 617214 621689 622264 626082 626737 630915 633515 633972 635490 644917 653956 667826 675107 675144 675429 675431 675660 675675 675723 675725 712775 727744 733573 792817 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black cock amateur"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black cock любительск"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black cock любительск"
]
|
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.