Query Metrics
7
Database Queries
7
Different statements
224.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
197.17 ms (87.77%) |
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 120061 398744 409941 411459 412134 416397 421882 422192 423855 423948 434338 434443 439454 439731 439749 441659 441662 441708 443836 446450 447895 449468 456730 457096 457313 457898 458031 458080 458274 458882 460489 461828 461919 464719 469009 470860 472198 481982 483024 485439 485524 487820 488157 490250 493042 496236 496244 499054 501681 502885 504313 509867 510769 510884 511472 511596 512232 512480 513018 514264 514375 517575 519577 520549 521863 522645 523869 525328 525584 526494 527227 527983 528191 534820 538417 538971 540988 555857 555984 555989 560266 563880 564048 564054 571734 577450 580137 584453 588956 589450 590265 591022 592178 592979 593935 597207 601424 604660 609161 611517 615170 617214 618146 621160 621607 626595 675071 681539 694142 697457 708348 738175 741504 742636 758072 760739 761039 788810 789915 791916 ] |
||||||||||||||||||||||||||||||
|
17.50 ms (7.79%) |
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 560266 741504 456730 493042 580137 409941 411459 120061 457313 789915 499054 443836 446450 697457 564048 564054 584453 615170 488157 621607 458274 694142 423855 708348 611517 788810 458882 509867 434338 523869 522645 742636 525584 555857 761039 617214 738175 481982 441708 457898 412134 496236 525328 675071 458031 517575 504313 510884 398744 439454 441659 441662 457096 528191 461828 604660 791916 458080 423948 538971 510769 527983 519577 460489 538417 555984 681539 422192 540988 588956 439749 590265 490250 512480 592178 593935 502885 513018 470860 511596 621160 526494 577450 592979 472198 469009 501681 461919 483024 485439 487820 520549 514264 439731 496244 618146 601424 534820 589450 758072 760739 512232 609161 511472 485524 591022 597207 421882 514375 521863 563880 626595 449468 555989 571734 434443 416397 447895 527227 464719 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.31%) |
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 120061 398744 409941 411459 412134 416397 421882 422192 423855 423948 434338 434443 439454 439731 439749 441659 441662 441708 443836 446450 447895 449468 456730 457096 457313 457898 458031 458080 458274 458882 460489 461828 461919 464719 469009 470860 472198 481982 483024 485439 485524 487820 488157 490250 493042 496236 496244 499054 501681 502885 504313 509867 510769 510884 511472 511596 512232 512480 513018 514264 514375 517575 519577 520549 521863 522645 523869 525328 525584 526494 527227 527983 528191 534820 538417 538971 540988 555857 555984 555989 560266 563880 564048 564054 571734 577450 580137 584453 588956 589450 590265 591022 592178 592979 593935 597207 601424 604660 609161 611517 615170 617214 618146 621160 621607 626595 675071 681539 694142 697457 708348 738175 741504 742636 758072 760739 761039 788810 789915 791916 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"doggy style amateur"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рак style любительск"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рак style любительск"
]
|
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.