Query Metrics
7
Database Queries
7
Different statements
150.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.72 ms (81.78%) |
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 195513 359918 382813 396088 397184 411885 430508 447853 454195 462369 488017 491862 492246 492339 512340 513743 530060 530752 530792 531082 531448 531899 536423 536557 552989 554978 557266 563927 566164 567729 568033 587183 587445 588694 590512 596675 598768 600543 600614 609877 615964 618343 622123 622177 623516 624497 627533 633120 634831 634868 646022 649367 650226 652540 664548 664621 664820 664967 665315 665374 665471 665477 665853 667574 667845 669239 669452 669786 673719 683121 687206 689660 693214 694894 694917 695113 703651 706250 707356 709131 714169 714216 716318 720235 720434 720915 724284 742224 745984 750071 750078 751722 752876 759483 759776 769329 770949 772119 775892 775951 775982 776273 781301 781981 783514 785341 787792 788194 788255 788858 791961 792265 792625 797608 801419 804314 807894 808535 813774 814538 ] |
||||||||||||||||||||||||||||||
|
16.82 ms (11.21%) |
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 720915 716318 695113 814538 536423 687206 703651 714169 665374 618343 792625 750071 530060 530752 454195 652540 694894 615964 709131 513743 195513 488017 813774 650226 664621 801419 531899 664820 531448 788194 707356 775951 563927 665853 669452 769329 492339 609877 396088 622123 492246 557266 649367 714216 664548 669239 683121 693214 600614 797608 724284 770949 759776 411885 491862 667574 587183 673719 720434 807894 669786 667845 808535 530792 646022 689660 776273 750078 751722 430508 665471 783514 791961 706250 785341 804314 531082 567729 627533 633120 792265 788255 596675 781301 787792 745984 554978 720235 665477 623516 772119 759483 781981 634868 788858 590512 447853 742224 752876 462369 622177 775892 600543 624497 382813 397184 359918 775982 512340 552989 587445 566164 665315 694917 568033 536557 664967 588694 634831 598768 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.93%) |
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 195513 359918 382813 396088 397184 411885 430508 447853 454195 462369 488017 491862 492246 492339 512340 513743 530060 530752 530792 531082 531448 531899 536423 536557 552989 554978 557266 563927 566164 567729 568033 587183 587445 588694 590512 596675 598768 600543 600614 609877 615964 618343 622123 622177 623516 624497 627533 633120 634831 634868 646022 649367 650226 652540 664548 664621 664820 664967 665315 665374 665471 665477 665853 667574 667845 669239 669452 669786 673719 683121 687206 689660 693214 694894 694917 695113 703651 706250 707356 709131 714169 714216 716318 720235 720434 720915 724284 742224 745984 750071 750078 751722 752876 759483 759776 769329 770949 772119 775892 775951 775982 776273 781301 781981 783514 785341 787792 788194 788255 788858 791961 792265 792625 797608 801419 804314 807894 808535 813774 814538 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"трах огромными членаÐâ…"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс огромные член"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс огромные член"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.