Query Metrics
7
Database Queries
7
Different statements
169.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.40 ms (87.10%) |
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 152234 231760 384132 389733 390278 391925 392025 392930 394031 396817 409844 414601 416125 418522 419435 421289 425692 435528 435576 438957 439808 439821 440217 440222 443353 452198 452225 453382 464036 464210 475640 476814 478621 482441 483472 496632 501055 509488 513652 513667 517806 519362 525438 533590 533754 536068 547811 548811 548813 551687 553851 560222 565889 566497 570907 575043 602758 618195 628514 629416 635120 660603 680431 692116 710424 713458 715006 720901 724123 726370 730951 734077 735548 739200 743420 758896 761021 761546 761761 762283 763247 763910 766781 787419 787781 788374 790342 792195 792220 795207 795925 795963 796010 796131 796172 797206 797348 797355 799706 809412 810114 811443 813628 813719 817306 823886 823901 823957 823966 824910 824966 825823 826096 826304 826534 826543 826959 827418 828628 ] |
||||||||||||||||||||||||||||||
|
13.16 ms (7.77%) |
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 811443 787419 788374 810114 766781 724123 726370 761021 761546 761761 720901 396817 792195 392025 452225 566497 743420 618195 813719 826096 478621 823966 817306 824966 762283 763247 439808 439821 440222 464210 509488 496632 680431 629416 389733 452198 565889 570907 555656 560222 409844 513652 525438 710424 823901 416125 758896 734077 795963 384132 231760 394031 435528 453382 464036 513667 482441 483472 551687 547811 152234 391925 419435 443353 475640 440217 425692 435576 438957 414601 476814 519362 517806 533754 533590 575043 692116 628514 635120 763910 713458 797206 421289 602758 418522 390278 813628 826534 823957 826304 501055 715006 796131 809412 792220 797348 739200 787781 795207 796010 796172 735548 797355 825823 824910 828628 790342 795925 826543 826959 827418 823886 536068 553851 548813 660603 548811 799706 730951 392930 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.39%) |
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 152234 231760 384132 389733 390278 391925 392025 392930 394031 396817 409844 414601 416125 418522 419435 421289 425692 435528 435576 438957 439808 439821 440217 440222 443353 452198 452225 453382 464036 464210 475640 476814 478621 482441 483472 496632 501055 509488 513652 513667 517806 519362 525438 533590 533754 536068 547811 548811 548813 551687 553851 560222 565889 566497 570907 575043 602758 618195 628514 629416 635120 660603 680431 692116 710424 713458 715006 720901 724123 726370 730951 734077 735548 739200 743420 758896 761021 761546 761761 762283 763247 763910 766781 787419 787781 788374 790342 792195 792220 795207 795925 795963 796010 796131 796172 797206 797348 797355 799706 809412 810114 811443 813628 813719 817306 823886 823901 823957 823966 824910 824966 825823 826096 826304 826534 826543 826959 827418 828628 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur milf brunette"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск milf черноволосая"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск milf черноволосая"
]
|
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.