Query Metrics
7
Database Queries
7
Different statements
199.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.37 ms (86.98%) |
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 383507 385254 387868 408796 437560 440681 442027 446893 460933 464924 466297 468344 471552 485810 486830 488466 496555 496726 498896 502036 506486 506888 507158 513811 530554 530617 530620 533896 539204 542297 544936 552988 556460 557794 558865 571156 581257 583988 584003 595137 602432 603046 604859 619203 619363 620938 624143 624969 634697 640233 646052 646999 659956 668133 668765 668944 669626 670048 670915 671927 675495 675618 689943 690032 693236 693444 693789 693794 703687 706620 707591 710094 712653 714615 715973 716725 717412 719768 720304 722996 730803 733671 734609 734620 737231 738020 740173 740220 745315 748459 753099 753733 761634 768745 770606 779685 780802 790817 791490 791681 793819 795130 800975 801154 803651 810384 810720 811599 813833 813870 813884 813892 816654 819265 819334 819751 819842 819996 824132 827432 ] |
||||||||||||||||||||||||||||||
|
15.15 ms (7.60%) |
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 440681 813870 816654 819996 824132 819265 819842 446893 460933 533896 506888 513811 502036 542297 552988 544936 557794 558865 571156 646999 689943 693789 703687 706620 668765 668944 671927 712653 668133 675618 719768 720304 584003 634697 602432 624143 620938 793819 810384 810720 811599 737231 761634 791490 734620 740173 740220 745315 753733 730803 733671 734609 753099 738020 768745 748459 770606 624969 707591 722996 780802 795130 803651 408796 468344 471552 387868 466297 385254 496726 506486 383507 442027 437560 819751 813884 827432 813833 819334 813892 486830 464924 485810 507158 530617 539204 496555 498896 530554 530620 488466 581257 583988 646052 670048 675495 693794 716725 717412 693444 710094 714615 659956 669626 670915 690032 693236 715973 556460 595137 603046 619363 640233 604859 619203 779685 790817 800975 791681 801154 ] |
||||||||||||||||||||||||||||||
|
3.38 ms (1.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 383507 385254 387868 408796 437560 440681 442027 446893 460933 464924 466297 468344 471552 485810 486830 488466 496555 496726 498896 502036 506486 506888 507158 513811 530554 530617 530620 533896 539204 542297 544936 552988 556460 557794 558865 571156 581257 583988 584003 595137 602432 603046 604859 619203 619363 620938 624143 624969 634697 640233 646052 646999 659956 668133 668765 668944 669626 670048 670915 671927 675495 675618 689943 690032 693236 693444 693789 693794 703687 706620 707591 710094 712653 714615 715973 716725 717412 719768 720304 722996 730803 733671 734609 734620 737231 738020 740173 740220 745315 748459 753099 753733 761634 768745 770606 779685 780802 790817 791490 791681 793819 795130 800975 801154 803651 810384 810720 811599 813833 813870 813884 813892 816654 819265 819334 819751 819842 819996 824132 827432 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"couple webcam"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"couple вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"couple вебкамер"
]
|
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.