Query Metrics
7
Database Queries
7
Different statements
202.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.56 ms (88.81%) |
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 68658 116720 373416 373741 382429 384595 386460 387655 388869 394818 396685 397298 397348 398010 398144 402732 403267 417742 418351 424839 426471 429318 432775 439825 443125 447650 454628 456985 463722 464604 466894 475483 506591 511822 512295 519472 530493 534040 536266 537347 542802 568118 572028 573277 574800 575157 596993 597815 598086 598502 598773 599929 603432 605324 623440 626310 627635 641950 648332 652192 652923 653534 654447 655058 663907 664536 668435 668545 670174 671607 672686 674980 678125 680172 684268 685666 685687 687525 689371 692451 693553 696226 698293 707071 714140 716600 718658 720754 722891 723131 723287 723434 724509 731384 737114 741090 745353 760004 763352 763522 779819 782935 783558 783657 789897 789901 794096 797386 803215 806437 810331 817191 817596 817723 818183 820792 823453 824184 826066 826672 ] |
||||||||||||||||||||||||||||||
|
12.48 ms (6.17%) |
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 603432 598502 724509 718658 397348 475483 760004 794096 826672 534040 572028 668545 680172 685687 714140 720754 652192 652923 672686 596993 597815 737114 745353 698293 810331 439825 626310 707071 817191 664536 670174 723131 723287 806437 443125 826066 429318 817596 820792 568118 685666 648332 723434 783558 463722 506591 116720 373416 797386 68658 817723 668435 693553 655058 663907 687525 689371 741090 779819 402732 716600 573277 782935 627635 447650 398010 456985 818183 789897 387655 530493 653534 641950 424839 575157 598773 384595 519472 511822 678125 537347 674980 464604 432775 824184 684268 466894 388869 397298 574800 426471 398144 373741 542802 696226 623440 536266 763522 418351 403267 654447 783657 512295 396685 386460 823453 454628 605324 598086 722891 671607 692451 599929 731384 803215 417742 763352 382429 789901 394818 ] |
||||||||||||||||||||||||||||||
|
3.49 ms (1.73%) |
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 68658 116720 373416 373741 382429 384595 386460 387655 388869 394818 396685 397298 397348 398010 398144 402732 403267 417742 418351 424839 426471 429318 432775 439825 443125 447650 454628 456985 463722 464604 466894 475483 506591 511822 512295 519472 530493 534040 536266 537347 542802 568118 572028 573277 574800 575157 596993 597815 598086 598502 598773 599929 603432 605324 623440 626310 627635 641950 648332 652192 652923 653534 654447 655058 663907 664536 668435 668545 670174 671607 672686 674980 678125 680172 684268 685666 685687 687525 689371 692451 693553 696226 698293 707071 714140 716600 718658 720754 722891 723131 723287 723434 724509 731384 737114 741090 745353 760004 763352 763522 779819 782935 783558 783657 789897 789901 794096 797386 803215 806437 810331 817191 817596 817723 818183 820792 823453 824184 826066 826672 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"deep throat teen"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"глубокийминет минет оральн секс teen"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.71%) |
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.