Query Metrics
7
Database Queries
7
Different statements
181.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.92 ms (83.79%) |
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 388308 388726 414184 414729 419854 423350 425316 427290 430476 443635 444143 453077 453085 453687 454294 458191 459857 460736 460756 462279 465360 465377 465378 465384 466112 466253 467555 467700 468019 470389 470539 470547 470561 470620 470640 470919 473952 474488 474706 475807 476732 477930 478562 482510 484407 484419 484465 484485 484622 484628 484708 484722 485597 485702 485927 486515 492687 492690 492691 493260 495193 504116 506056 508187 508698 509842 516635 516651 517125 517567 525133 525633 526182 531195 531229 533318 544112 544113 544247 547936 547958 550820 554414 561131 565353 567468 576547 584005 585282 587970 590437 598918 603615 603635 603662 605529 606518 606674 630915 634770 635432 635490 637048 637085 638552 641395 670056 670717 690081 720115 748447 750827 770926 775946 790793 804491 809414 809523 815115 818848 ] |
||||||||||||||||||||||||||||||
|
18.61 ms (10.26%) |
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 470640 443635 818848 809414 770926 587970 506056 690081 462279 460756 606674 635490 470561 474488 567468 508187 531229 544247 477930 423350 525133 453687 547958 809523 750827 465384 474706 531195 467700 414729 460736 598918 427290 453077 525633 493260 554414 547936 670717 670056 637085 637048 470919 466253 485927 454294 775946 388726 388308 476732 492691 544112 605529 638552 603615 470620 470547 508698 635432 468019 533318 470389 630915 634770 585282 544113 550820 590437 484419 561131 478562 584005 504116 516651 495193 516635 606518 748447 509842 603662 467555 484622 458191 484628 485702 804491 603635 465360 475807 484708 484407 484465 430476 484485 465378 444143 484722 465377 485597 466112 517567 492690 720115 482510 565353 790793 425316 459857 419854 453085 492687 414184 473952 526182 641395 486515 470539 517125 815115 576547 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.65%) |
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 388308 388726 414184 414729 419854 423350 425316 427290 430476 443635 444143 453077 453085 453687 454294 458191 459857 460736 460756 462279 465360 465377 465378 465384 466112 466253 467555 467700 468019 470389 470539 470547 470561 470620 470640 470919 473952 474488 474706 475807 476732 477930 478562 482510 484407 484419 484465 484485 484622 484628 484708 484722 485597 485702 485927 486515 492687 492690 492691 493260 495193 504116 506056 508187 508698 509842 516635 516651 517125 517567 525133 525633 526182 531195 531229 533318 544112 544113 544247 547936 547958 550820 554414 561131 565353 567468 576547 584005 585282 587970 590437 598918 603615 603635 603662 605529 606518 606674 630915 634770 635432 635490 637048 637085 638552 641395 670056 670717 690081 720115 748447 750827 770926 775946 790793 804491 809414 809523 815115 818848 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature жен мжм секс втро"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature wife mmf"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature жен мжм секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.96%) |
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.