Query Metrics
7
Database Queries
7
Different statements
215.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
190.42 ms (88.38%) |
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 393157 396384 397101 398784 402063 402235 403257 411188 413099 418397 418799 425195 427931 437419 446378 447518 473290 483978 487666 488703 492340 510415 514625 515734 526557 550403 551603 552229 555878 557658 558576 568355 570361 570595 572116 574718 580466 582289 583589 585720 587091 593101 593725 594608 595553 595613 602505 606431 608818 610078 610974 617968 622308 622446 623465 625948 626068 626973 653552 659311 659349 663834 670991 674285 674478 676169 684518 693032 695004 703263 705715 722705 723818 723820 725253 727147 730070 731364 735528 738260 742011 743340 745374 746030 746555 748687 748748 749721 750830 760252 767354 767473 769664 770980 771045 771740 775112 776413 778915 779010 780090 780221 780374 782302 782761 788954 789229 789743 790529 791359 792420 800019 805536 807669 807674 807681 808411 810735 811182 812288 ] |
||||||||||||||||||||||||||||||
|
14.38 ms (6.67%) |
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 551603 552229 558576 570595 580466 582289 583589 659349 676169 684518 703263 705715 653552 663834 670991 674478 693032 722705 659311 674285 695004 550403 555878 557658 568355 570361 572116 585720 594608 595553 606431 617968 622446 626068 587091 602505 610078 593725 595613 610974 593101 622308 625948 626973 779010 780090 782302 782761 792420 810735 776413 780221 780374 788954 723818 725253 735528 742011 743340 745374 748687 767354 789743 791359 807669 807674 807681 808411 812288 731364 748748 750830 723820 727147 730070 746030 769664 770980 771740 738260 746555 749721 760252 767473 771045 608818 623465 775112 778915 789229 790529 800019 805536 811182 411188 427931 402063 473290 398784 402235 413099 418397 437419 446378 447518 403257 418799 425195 488703 515734 483978 510415 514625 526557 492340 487666 574718 393157 396384 397101 ] |
||||||||||||||||||||||||||||||
|
3.50 ms (1.62%) |
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 393157 396384 397101 398784 402063 402235 403257 411188 413099 418397 418799 425195 427931 437419 446378 447518 473290 483978 487666 488703 492340 510415 514625 515734 526557 550403 551603 552229 555878 557658 558576 568355 570361 570595 572116 574718 580466 582289 583589 585720 587091 593101 593725 594608 595553 595613 602505 606431 608818 610078 610974 617968 622308 622446 623465 625948 626068 626973 653552 659311 659349 663834 670991 674285 674478 676169 684518 693032 695004 703263 705715 722705 723818 723820 725253 727147 730070 731364 735528 738260 742011 743340 745374 746030 746555 748687 748748 749721 750830 760252 767354 767473 769664 770980 771045 771740 775112 776413 778915 779010 780090 780221 780374 782302 782761 788954 789229 789743 790529 791359 792420 800019 805536 807669 807674 807681 808411 810735 811182 812288 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny cum"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые cum"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые 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.