Query Metrics
7
Database Queries
7
Different statements
361.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.62 ms (57.69%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
129.51 ms (35.82%) |
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 212024 384595 388755 389132 390593 395710 398802 408207 447149 456156 466612 483559 487059 499457 514957 536127 553722 555387 561807 565159 590063 596653 598018 600283 604327 613494 627759 630289 635250 640526 644326 648669 648875 649105 654332 654340 654439 656621 660342 660431 672112 674216 678981 699788 704842 709873 710368 714695 715453 716971 717921 718560 720047 720386 720805 721426 722555 722847 725113 725606 727416 727653 727654 728240 729814 730764 736394 738320 739050 740373 740450 740773 740909 741524 742626 743029 743197 744740 745472 747389 748339 749121 756841 756973 757276 760841 761011 761482 762909 764205 765619 766588 771361 773613 779069 786768 786942 787319 788981 789532 789950 790371 790840 794198 794346 795977 796343 797505 799375 801213 801344 802051 802147 803673 805784 810710 811989 812351 813534 814952 ] |
||||||||||||||||||||||||||||||
|
15.22 ms (4.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 739050 743029 747389 749121 761011 787319 790840 794198 802051 802147 805784 811989 740450 741524 771361 729814 738320 745472 760841 765619 740773 762909 740909 742626 744740 764205 773613 788981 794346 395710 384595 389132 720047 483559 555387 613494 810710 212024 388755 390593 398802 408207 814952 456156 466612 487059 447149 514957 536127 499457 561807 553722 565159 648669 648875 649105 654340 660431 678981 699788 704842 709873 714695 716971 718560 720386 720805 721426 722847 654332 654439 656621 660342 672112 674216 710368 715453 717921 722555 598018 600283 635250 644326 596653 604327 590063 627759 630289 640526 790371 799375 801213 779069 786768 789532 812351 725113 725606 727416 727653 727654 730764 736394 740373 743197 748339 756841 756973 757276 761482 766588 786942 789950 795977 796343 797505 801344 803673 813534 728240 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (0.70%) |
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 212024 384595 388755 389132 390593 395710 398802 408207 447149 456156 466612 483559 487059 499457 514957 536127 553722 555387 561807 565159 590063 596653 598018 600283 604327 613494 627759 630289 635250 640526 644326 648669 648875 649105 654332 654340 654439 656621 660342 660431 672112 674216 678981 699788 704842 709873 710368 714695 715453 716971 717921 718560 720047 720386 720805 721426 722555 722847 725113 725606 727416 727653 727654 728240 729814 730764 736394 738320 739050 740373 740450 740773 740909 741524 742626 743029 743197 744740 745472 747389 748339 749121 756841 756973 757276 760841 761011 761482 762909 764205 765619 766588 771361 773613 779069 786768 786942 787319 788981 789532 789950 790371 790840 794198 794346 795977 796343 797505 799375 801213 801344 802051 802147 803673 805784 810710 811989 812351 813534 814952 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.58%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал pussy"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal and pussy"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал pussy"
]
|
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.