Query Metrics
7
Database Queries
7
Different statements
366.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.46 ms (57.71%) |
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 396601 410873 476636 495531 502372 511865 530125 552875 556652 556685 556855 559237 562595 571107 572219 579500 581581 585769 586346 587799 590612 590653 591516 592708 593837 600871 606022 608177 610999 620673 622758 626083 628187 628588 636241 642288 653069 659334 659479 663562 671408 671492 684705 687832 689214 689445 691616 693188 696173 696198 697586 700902 702056 702382 703284 705467 710488 711613 712226 716082 718699 719827 719901 720351 720612 721807 721946 724583 725096 730670 731090 736861 737720 739901 745502 745754 747015 747230 748545 751845 753749 756724 758389 759474 760986 762766 765911 766702 770914 774597 777615 780283 780731 784917 785679 786403 787117 788892 791498 791966 794531 796255 796288 796506 796811 799705 801373 802658 804679 805350 805533 809545 814115 817887 818422 819335 819952 821809 827850 ] |
||||||||||||||||||||||||||||||
|
134.30 ms (36.65%) |
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 396601 410873 476636 495531 502372 511865 530125 552875 556652 556685 556855 559237 562595 571107 572219 579500 581581 585769 586346 587799 590612 590653 591516 592708 593837 600871 606022 608177 610999 620673 622758 626083 628187 628588 636241 642288 653069 659334 659479 663562 671408 671492 684705 687832 689214 689445 691616 693188 696173 696198 697586 700902 702056 702382 703284 705467 710488 711613 712226 716082 718699 719827 719901 720351 720612 721807 721946 724583 725096 730670 731090 736861 737720 739901 745502 745754 747015 747230 748545 751845 753749 756724 758389 759474 760986 762766 765911 766702 770914 774597 777615 780283 780731 784917 785679 786403 787117 788892 791498 791966 794531 796255 796288 796506 796811 799705 801373 802658 804679 805350 805533 809545 814115 817887 818422 819335 819952 821809 827850 ] |
||||||||||||||||||||||||||||||
|
13.02 ms (3.55%) |
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 819335 476636 530125 502372 559237 581581 562595 659479 689445 696173 696198 702382 711613 719901 653069 687832 697586 700902 705467 712226 671408 684705 689214 720351 720612 721807 552875 556855 571107 585769 593837 636241 591516 610999 586346 600871 642288 590653 608177 780731 786403 799705 809545 777615 787117 796506 805533 731090 737720 745502 760986 791966 794531 796811 804679 805350 724583 765911 770914 736861 745754 747015 747230 751845 758389 766702 730670 739901 753749 756724 757837 759474 762766 748545 716082 721946 784917 788892 791498 796288 511865 693188 719827 592708 620673 796255 725096 410873 818422 827850 495531 718699 785679 802658 801373 780283 396601 817887 821809 814115 819952 572219 579500 556652 659334 663562 710488 702056 703284 671492 691616 556685 587799 606022 622758 626083 628187 590612 628588 774597 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"husband fuck"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (0.55%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"husband секс"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.53%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"husband секс"
]
|
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.