Query Metrics
7
Database Queries
7
Different statements
159.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.51 ms (80.69%) |
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 61322 191348 387579 390294 394586 395565 412122 419364 419527 424424 424425 424627 425625 428533 439564 443741 443795 445706 450995 451504 451931 452093 452135 453161 454053 454135 455872 459643 459661 465500 466134 466213 466233 467035 468031 470944 470995 471441 473501 474418 475008 477959 477993 479040 479803 481864 484147 484459 484575 484611 485969 489138 490430 490897 490942 491119 495149 496057 496561 504841 505100 512066 512955 513127 517002 518843 519569 519747 524969 525498 526250 533396 536347 539512 545676 546947 547930 551070 560380 560391 561047 563150 581314 589674 599497 604565 605520 605576 606618 687540 696514 696989 703467 716206 721070 722099 724283 725362 728172 728235 728452 733146 745033 760752 766624 769949 770181 784016 784287 788969 789656 789980 801896 815263 815318 815485 815489 818651 818848 826931 ] |
||||||||||||||||||||||||||||||
|
20.06 ms (12.60%) |
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 770181 724283 745033 760752 789980 453161 424424 445706 459661 466233 560391 504841 512066 519747 395565 61322 387579 412122 818651 826931 815263 815489 815485 455872 533396 721070 696989 687540 696514 716206 722099 551070 561047 581314 605520 606618 801896 788969 728172 725362 769949 604565 703467 784016 784287 789656 475008 484147 484611 468031 505100 526250 485969 766624 424425 454053 459643 479803 452135 512955 536347 539512 525498 513127 473501 563150 547930 560380 545676 599497 733146 728235 477993 419527 443795 454135 466134 474418 465500 517002 490897 490942 496057 495149 467035 428533 419364 439564 470944 425625 524969 491119 519569 451931 546947 605576 589674 728452 443741 451504 466213 452093 479040 484575 484459 489138 490430 424627 191348 394586 390294 815318 818848 470995 477959 481864 450995 471441 496561 518843 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (1.99%) |
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 61322 191348 387579 390294 394586 395565 412122 419364 419527 424424 424425 424627 425625 428533 439564 443741 443795 445706 450995 451504 451931 452093 452135 453161 454053 454135 455872 459643 459661 465500 466134 466213 466233 467035 468031 470944 470995 471441 473501 474418 475008 477959 477993 479040 479803 481864 484147 484459 484575 484611 485969 489138 490430 490897 490942 491119 495149 496057 496561 504841 505100 512066 512955 513127 517002 518843 519569 519747 524969 525498 526250 533396 536347 539512 545676 546947 547930 551070 560380 560391 561047 563150 581314 589674 599497 604565 605520 605576 606618 687540 696514 696989 703467 716206 721070 722099 724283 725362 728172 728235 728452 733146 745033 760752 766624 769949 770181 784016 784287 788969 789656 789980 801896 815263 815318 815485 815489 818651 818848 826931 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature 69 position"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature поз position 69"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature поз position 69"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.98%) |
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.