Query Metrics
7
Database Queries
7
Different statements
177.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.19 ms (86.14%) |
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 384106 387473 391264 398331 403131 420362 453325 454865 455386 457841 459661 467721 470031 474251 483934 490132 495057 498248 498817 504333 507394 509938 521054 525325 525575 526586 527211 548510 551437 551952 553188 557701 560213 561414 566923 578848 580561 582334 583652 584895 585914 587968 593181 595696 595700 598666 609675 619264 621228 625327 636135 637232 645194 663834 665952 669277 676793 677088 679687 691998 693281 693702 697519 697623 699118 709581 712525 716093 717709 724586 731867 733534 734427 734728 740481 743535 747565 749137 751785 752377 756296 758942 759521 765237 765621 766640 768626 771755 773452 774559 776454 779507 780589 782361 792197 792223 793397 795192 799739 800189 800943 800987 801043 802228 802957 803904 804526 809305 810326 812254 814521 817712 818550 818926 824326 824640 824662 824814 825973 827579 ] |
||||||||||||||||||||||||||||||
|
13.85 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 619264 699118 747565 587968 459661 716093 731867 384106 827579 824662 759521 756296 765621 743535 551952 824326 752377 609675 663834 387473 812254 495057 709581 525575 824814 825973 724586 768626 800943 561414 782361 557701 474251 507394 509938 779507 551437 525325 765237 766640 740481 679687 598666 457841 802957 693281 582334 818926 810326 712525 818550 717709 802228 824640 773452 771755 420362 504333 483934 526586 593181 809305 734427 454865 693702 697623 637232 453325 817712 566923 800987 795192 751785 521054 803904 676793 391264 595696 774559 776454 578848 455386 814521 585914 398331 625327 697519 792223 595700 490132 691998 804526 665952 527211 560213 584895 799739 792197 470031 580561 669277 553188 758942 749137 498248 780589 793397 677088 467721 645194 636135 498817 583652 734728 403131 548510 801043 733534 800189 621228 ] |
||||||||||||||||||||||||||||||
|
4.35 ms (2.45%) |
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 384106 387473 391264 398331 403131 420362 453325 454865 455386 457841 459661 467721 470031 474251 483934 490132 495057 498248 498817 504333 507394 509938 521054 525325 525575 526586 527211 548510 551437 551952 553188 557701 560213 561414 566923 578848 580561 582334 583652 584895 585914 587968 593181 595696 595700 598666 609675 619264 621228 625327 636135 637232 645194 663834 665952 669277 676793 677088 679687 691998 693281 693702 697519 697623 699118 709581 712525 716093 717709 724586 731867 733534 734427 734728 740481 743535 747565 749137 751785 752377 756296 758942 759521 765237 765621 766640 768626 771755 773452 774559 776454 779507 780589 782361 792197 792223 793397 795192 799739 800189 800943 800987 801043 802228 802957 803904 804526 809305 810326 812254 814521 817712 818550 818926 824326 824640 824662 824814 825973 827579 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur 69 blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск поз 69 минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.24 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск поз 69 минет оральн секс"
]
|
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.