Query Metrics
7
Database Queries
7
Different statements
240.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.94 ms (89.02%) |
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 390218 391565 398955 400861 415814 422264 433362 441821 443387 443948 444679 448714 451324 453184 454869 455318 456693 458072 460601 462489 462707 463159 464915 465331 465342 474780 474781 477984 478376 478937 483362 490741 493195 495617 506225 516478 516787 516829 518004 521121 523608 524944 542090 547741 547763 547791 547802 551821 557969 563102 564645 565859 566659 568367 578821 580363 588958 590223 591383 598862 604334 611521 623216 627064 630448 655295 660137 680037 690625 693396 704892 705317 711745 719977 722302 728243 741222 745461 751603 757918 759997 763079 763726 763729 763745 765849 765859 765863 765934 766165 768603 771370 777499 778784 779803 782553 785482 786238 786309 786368 787178 787357 789276 790553 794041 797361 799217 799419 801654 803137 803518 805137 805154 805736 808342 814147 816105 816124 817725 825673 ] |
||||||||||||||||||||||||||||||
|
16.82 ms (7.00%) |
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 704892 690625 551821 590223 604334 623216 591383 598862 680037 400861 542090 547791 557969 547802 564645 578821 580363 660137 565859 433362 453184 441821 462707 465342 422264 454869 474780 456693 415814 464915 465331 495617 506225 516829 521121 483362 518004 523608 563102 478376 391565 443948 547741 568367 611521 751603 789276 765859 763079 785482 444679 398955 448714 817725 816124 814147 566659 547763 693396 705317 719977 722302 588958 627064 777499 786238 790553 797361 778784 786368 787357 799419 801654 805137 766165 794041 805736 808342 741222 765849 765934 745461 757918 765863 768603 759997 763726 763729 763745 728243 771370 711745 779803 782553 786309 787178 799217 803137 805154 478937 451324 458072 390218 462489 463159 443387 455318 460601 474781 516478 524944 490741 493195 825673 655295 803518 477984 630448 516787 816105 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.16%) |
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 390218 391565 398955 400861 415814 422264 433362 441821 443387 443948 444679 448714 451324 453184 454869 455318 456693 458072 460601 462489 462707 463159 464915 465331 465342 474780 474781 477984 478376 478937 483362 490741 493195 495617 506225 516478 516787 516829 518004 521121 523608 524944 542090 547741 547763 547791 547802 551821 557969 563102 564645 565859 566659 568367 578821 580363 588958 590223 591383 598862 604334 611521 623216 627064 630448 655295 660137 680037 690625 693396 704892 705317 711745 719977 722302 728243 741222 745461 751603 757918 759997 763079 763726 763729 763745 765849 765859 765863 765934 766165 768603 771370 777499 778784 779803 782553 785482 786238 786309 786368 787178 787357 789276 790553 794041 797361 799217 799419 801654 803137 803518 805137 805154 805736 808342 814147 816105 816124 817725 825673 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian mom amateur"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск mom любительск"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск mom любительск"
]
|
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.