Query Metrics
7
Database Queries
7
Different statements
146.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.32 ms (82.29%) |
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 61051 386156 414259 414675 415294 415855 415961 415981 415992 416508 416511 416515 416525 416536 416580 416600 416609 416616 416621 416624 416626 416639 416648 416653 416670 416683 416696 416712 416715 416722 419200 420615 423783 425398 426284 426301 428174 429523 429844 430261 430355 432274 432466 436230 437084 437859 437863 441032 441095 441354 443236 444888 444921 446797 452781 459198 467097 467588 468949 469615 475405 476059 477761 478993 482280 483705 483730 484286 487418 491860 493687 493696 493825 493839 494493 498319 498346 500256 500338 505139 505386 509429 511893 515490 518548 520786 531351 540032 540990 541409 545369 545379 545426 564237 577468 582802 583377 583593 602024 604338 614966 619659 624168 630081 636958 666355 676808 709128 709917 750121 751424 752706 770405 776059 779840 785614 798291 799937 800442 814443 ] |
||||||||||||||||||||||||||||||
|
15.14 ms (10.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 436230 416609 416624 416653 441095 432274 437863 443236 414675 415992 416515 416536 416580 416621 416639 416648 416670 416712 416715 416525 441032 416696 441354 814443 476059 478993 482280 475405 483705 484286 491860 468949 483730 493825 494493 500256 515490 540032 500338 505139 505386 511893 487418 540990 541409 545379 564237 582802 545369 583377 709917 666355 676808 545426 577468 583593 602024 614966 619659 624168 604338 636958 776059 779840 785614 799937 800442 770405 750121 752706 751424 630081 709128 798291 61051 414259 416508 430355 432466 437859 467097 415294 416511 416600 416616 420615 426301 467588 386156 430261 444888 477761 415961 415981 416683 416722 426284 459198 469615 518548 493696 493839 498346 509429 520786 493687 498319 452781 423783 531351 415855 425398 416626 419200 444921 429523 429844 428174 437084 446797 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (2.24%) |
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 61051 386156 414259 414675 415294 415855 415961 415981 415992 416508 416511 416515 416525 416536 416580 416600 416609 416616 416621 416624 416626 416639 416648 416653 416670 416683 416696 416712 416715 416722 419200 420615 423783 425398 426284 426301 428174 429523 429844 430261 430355 432274 432466 436230 437084 437859 437863 441032 441095 441354 443236 444888 444921 446797 452781 459198 467097 467588 468949 469615 475405 476059 477761 478993 482280 483705 483730 484286 487418 491860 493687 493696 493825 493839 494493 498319 498346 500256 500338 505139 505386 509429 511893 515490 518548 520786 531351 540032 540990 541409 545369 545379 545426 564237 577468 582802 583377 583593 602024 604338 614966 619659 624168 630081 636958 666355 676808 709128 709917 750121 751424 752706 770405 776059 779840 785614 798291 799937 800442 814443 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam teen huge"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер teen огромные"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер teen огромные"
]
|
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.