Query Metrics
7
Database Queries
7
Different statements
149.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.84 ms (80.26%) |
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 23696 101065 231230 232995 385271 386367 395770 399074 402999 404522 407589 407727 408214 416992 421879 422176 422209 424047 424663 426156 430549 430638 434239 440563 442231 442262 442281 443172 444723 447474 454991 456846 457282 457971 459856 460854 463655 465005 467207 467966 470573 473341 474213 474864 475234 476751 477886 480717 482671 483992 485724 487367 493472 495951 505652 509201 513103 513336 515604 516902 519588 519718 520464 524266 526865 528462 530121 532898 532922 532924 532945 532969 532994 533002 533015 533034 535918 535920 538232 549738 560875 561738 564717 566093 567365 572822 587167 590413 599951 601285 603371 611317 612381 624195 626811 646799 646981 672328 697535 700899 702039 722889 724712 727394 733539 748379 753397 753902 755045 763561 768502 777558 781360 781853 783875 784677 803221 811093 817701 819725 ] |
||||||||||||||||||||||||||||||
|
18.38 ms (12.31%) |
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 422209 697535 702039 603371 783875 753397 724712 733539 567365 590413 722889 447474 532945 535918 535920 513103 516902 515604 520464 404522 442231 442262 483992 532924 532969 532898 533002 532922 460854 444723 487367 457971 440563 422176 672328 416992 624195 231230 646981 777558 763561 538232 612381 434239 395770 817701 700899 727394 101065 232995 399074 532994 385271 467207 421879 408214 819725 443172 474864 561738 611317 781853 803221 811093 475234 407589 528462 495951 386367 23696 524266 482671 526865 424047 470573 646799 755045 456846 474213 430638 426156 457282 454991 533015 480717 519718 509201 748379 533034 781360 753902 599951 564717 626811 430549 473341 485724 505652 493472 513336 572822 784677 424663 587167 407727 463655 442281 601285 768502 402999 519588 459856 476751 560875 549738 477886 465005 467966 530121 566093 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (2.27%) |
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 23696 101065 231230 232995 385271 386367 395770 399074 402999 404522 407589 407727 408214 416992 421879 422176 422209 424047 424663 426156 430549 430638 434239 440563 442231 442262 442281 443172 444723 447474 454991 456846 457282 457971 459856 460854 463655 465005 467207 467966 470573 473341 474213 474864 475234 476751 477886 480717 482671 483992 485724 487367 493472 495951 505652 509201 513103 513336 515604 516902 519588 519718 520464 524266 526865 528462 530121 532898 532922 532924 532945 532969 532994 533002 533015 533034 535918 535920 538232 549738 560875 561738 564717 566093 567365 572822 587167 590413 599951 601285 603371 611317 612381 624195 626811 646799 646981 672328 697535 700899 702039 722889 724712 727394 733539 748379 753397 753902 755045 763561 768502 777558 781360 781853 783875 784677 803221 811093 817701 819725 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"redhead big tits"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рыжая большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рыжая большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.23%) |
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.