Query Metrics
7
Database Queries
7
Different statements
161.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.99 ms (85.30%) |
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 398074 398429 413769 414099 419943 419949 427379 428587 435879 446253 453228 463953 465915 470830 487623 510521 514627 515048 516019 529131 530298 530404 530498 530996 531724 533239 535196 538725 561189 565575 565879 573928 576139 591207 593932 595326 596743 601807 604105 604358 604367 607499 608322 608605 614533 614549 617686 624941 627790 640608 642526 644498 645038 646136 650235 650730 651769 658540 669319 686849 690952 697853 705139 717443 718146 724121 733903 735269 736387 739278 739777 741186 745467 745469 745940 746344 747316 749362 749649 751083 751470 754574 757496 757521 758092 764798 766657 768784 769075 773668 773730 776007 778962 785544 786271 788080 788238 788511 791074 792733 795303 796196 796295 796621 797926 798331 798557 799848 800653 801565 802369 806715 808056 808086 811797 812947 813222 819111 ] |
||||||||||||||||||||||||||||||
|
14.15 ms (8.75%) |
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 739278 746344 799848 733903 745469 747316 754574 751083 776007 465915 487623 573928 751470 617686 419949 470830 530996 601807 624941 614549 413769 565575 785544 604105 758092 435879 515048 414099 529131 828578 453228 398429 463953 535196 514627 658540 697853 650730 669319 705139 646136 651769 686849 718146 608322 595326 596743 627790 604358 786271 796196 778962 788511 795303 796295 796621 798557 812947 741186 749649 773668 773730 791074 792733 797926 801565 735269 757496 724121 757521 769075 745940 766657 710923 788080 538725 531724 576139 565879 591207 607499 608605 806715 811797 739777 614533 640608 644498 813222 427379 510521 533239 819111 516019 642526 800653 798331 736387 749362 768784 717443 650235 604367 745467 419943 530498 530298 690952 645038 802369 808056 764798 398074 428587 788238 593932 561189 446253 808086 530404 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (1.94%) |
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 398074 398429 413769 414099 419943 419949 427379 428587 435879 446253 453228 463953 465915 470830 487623 510521 514627 515048 516019 529131 530298 530404 530498 530996 531724 533239 535196 538725 561189 565575 565879 573928 576139 591207 593932 595326 596743 601807 604105 604358 604367 607499 608322 608605 614533 614549 617686 624941 627790 640608 642526 644498 645038 646136 650235 650730 651769 658540 669319 686849 690952 697853 705139 717443 718146 724121 733903 735269 736387 739278 739777 741186 745467 745469 745940 746344 747316 749362 749649 751083 751470 754574 757496 757521 758092 764798 766657 768784 769075 773668 773730 776007 778962 785544 786271 788080 788238 788511 791074 792733 795303 796196 796295 796621 797926 798331 798557 799848 800653 801565 802369 806715 808056 808086 811797 812947 813222 819111 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass girls"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп девушк"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.