Query Metrics
7
Database Queries
7
Different statements
210.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.91 ms (88.42%) |
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 391644 391693 396056 398670 398678 400029 402063 403834 409685 417318 418159 418774 422495 423484 423670 424247 424830 426499 432320 441258 442611 442879 444779 445444 446762 447073 447183 448737 451981 461090 476599 477794 478131 478207 479303 492708 492718 497459 499441 503825 505659 506544 513561 515499 521568 526158 527804 533649 538420 548908 550403 552726 554722 555693 555796 555878 557405 557658 558615 560783 565718 567708 567733 570361 570371 571254 571600 572116 574571 580144 582289 583426 585436 588252 588266 590480 592643 594608 598399 600709 601237 602618 602783 611299 615665 621387 622308 623465 625948 626209 634159 646246 648288 661462 676169 696225 705715 731884 738260 739038 742010 742011 743103 744683 749723 760252 775834 779010 780374 788101 788247 789229 790998 791359 791704 792765 792789 797592 803183 807681 ] |
||||||||||||||||||||||||||||||
|
15.09 ms (7.18%) |
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 461090 418159 515499 565718 423484 499441 398670 570371 550403 557658 570361 572116 594608 779010 742011 402063 391693 441258 583426 598399 626209 477794 422495 448737 476599 424247 555796 426499 391644 661462 775834 739038 615665 478207 497459 788247 797592 792765 743103 601237 571600 409685 451981 648288 696225 600709 621387 634159 588252 742010 400029 418774 398678 548908 585436 611299 592643 442611 423670 492708 506544 505659 424830 442879 445444 446762 479303 513561 571254 580144 567708 554722 557405 558615 567733 588266 602618 602783 791704 749723 731884 744683 417318 447073 432320 478131 521568 526158 403834 533649 503825 538420 552726 555693 582289 676169 705715 555878 622308 625948 780374 791359 807681 738260 760252 623465 789229 574571 790998 560783 492718 788101 646246 590480 792789 527804 803183 447183 444779 396056 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.09%) |
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 391644 391693 396056 398670 398678 400029 402063 403834 409685 417318 418159 418774 422495 423484 423670 424247 424830 426499 432320 441258 442611 442879 444779 445444 446762 447073 447183 448737 451981 461090 476599 477794 478131 478207 479303 492708 492718 497459 499441 503825 505659 506544 513561 515499 521568 526158 527804 533649 538420 548908 550403 552726 554722 555693 555796 555878 557405 557658 558615 560783 565718 567708 567733 570361 570371 571254 571600 572116 574571 580144 582289 583426 585436 588252 588266 590480 592643 594608 598399 600709 601237 602618 602783 611299 615665 621387 622308 623465 625948 626209 634159 646246 648288 661462 676169 696225 705715 731884 738260 739038 742010 742011 743103 744683 749723 760252 775834 779010 780374 788101 788247 789229 790998 791359 791704 792765 792789 797592 803183 807681 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые минет оральн секс cum"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые минет оральн секс cum"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny blowjob cum"
]
|
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.