Query Metrics
7
Database Queries
7
Different statements
173.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.05 ms (87.40%) |
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 414099 419949 427379 428587 435879 445577 446253 463953 470830 510521 514627 515048 516019 529131 530298 530404 530498 530996 531724 532866 533239 535196 538725 544099 549861 561189 565575 565879 573928 576139 596743 598229 601807 604105 604358 604367 608322 608605 608894 614533 614549 624941 627790 642526 643943 644498 645038 645511 646136 647134 648691 649789 650235 650676 650705 650730 653039 658463 658540 669319 686849 688474 690952 693363 697853 705139 716384 717443 718146 724121 736387 739487 739777 741186 745467 745940 748419 749362 749649 751470 757496 757521 758092 764798 766657 768784 769075 773668 773730 776390 778962 785544 788080 788238 788511 791074 792733 795303 796196 796295 796621 797926 798331 798557 800653 801565 802369 806715 808056 808086 808486 810737 811797 812947 813222 819111 ] |
||||||||||||||||||||||||||||||
|
11.60 ms (6.67%) |
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 573928 751470 419949 470830 530996 549861 601807 624941 614549 565575 785544 604105 758092 435879 515048 414099 529131 828578 398429 463953 535196 514627 658540 697853 650730 669319 705139 646136 686849 718146 608322 598229 596743 627790 604358 796196 778962 788511 795303 796295 796621 798557 812947 739487 741186 749649 773668 773730 791074 792733 797926 801565 757496 724121 757521 769075 745940 766657 710923 788080 538725 531724 576139 565879 608894 608605 806715 811797 739777 614533 644498 813222 427379 510521 533239 819111 516019 642526 800653 798331 736387 749362 768784 717443 650235 604367 745467 748419 530498 530298 690952 645038 802369 808056 764798 398074 428587 788238 561189 446253 445577 808086 530404 532866 544099 647134 648691 649789 650705 693363 645511 653039 658463 688474 650676 716384 643943 776390 808486 810737 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.44%) |
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 414099 419949 427379 428587 435879 445577 446253 463953 470830 510521 514627 515048 516019 529131 530298 530404 530498 530996 531724 532866 533239 535196 538725 544099 549861 561189 565575 565879 573928 576139 596743 598229 601807 604105 604358 604367 608322 608605 608894 614533 614549 624941 627790 642526 643943 644498 645038 645511 646136 647134 648691 649789 650235 650676 650705 650730 653039 658463 658540 669319 686849 688474 690952 693363 697853 705139 716384 717443 718146 724121 736387 739487 739777 741186 745467 745940 748419 749362 749649 751470 757496 757521 758092 764798 766657 768784 769075 773668 773730 776390 778962 785544 788080 788238 788511 791074 792733 795303 796196 796295 796621 797926 798331 798557 800653 801565 802369 806715 808056 808086 808486 810737 811797 812947 813222 819111 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girls big ass"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.