Query Metrics
7
Database Queries
7
Different statements
369.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.36 ms (56.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"старый молодые домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
137.66 ms (37.29%) |
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 235834 400609 400723 417461 424023 443370 453624 462500 463771 466187 467767 469844 470734 474842 477409 483258 504764 507772 509077 511889 514787 523680 530578 541250 545538 552534 568440 583210 584666 586789 595654 604425 606258 609712 615112 617603 618528 624508 626330 627171 633665 644708 675424 680682 684096 686082 693341 701508 702320 704722 707881 710001 716124 719124 722080 726703 731432 732775 735524 736866 736980 737910 738257 738623 738970 740084 740489 741114 741998 743009 744711 745386 747954 748392 753548 753677 753993 754967 758723 759634 761592 761862 762559 765763 765907 766687 770444 771874 774927 775284 775630 776138 784925 786715 787950 789870 789877 790101 793436 797165 798171 800275 800305 800377 801305 803144 803244 803261 804959 805727 807333 807663 809707 810533 811866 816764 817482 821870 825694 827328 ] |
||||||||||||||||||||||||||||||
|
16.16 ms (4.38%) |
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 604425 626330 615112 633665 644708 776138 793436 810533 774927 789877 726703 736980 737910 738257 740084 784925 731432 754967 759634 738623 738970 735524 745386 765763 771874 741114 753993 765907 618528 627171 716124 722080 798171 804959 805727 462500 400723 400609 469844 470734 541250 719124 701508 684096 686082 586789 811866 680682 758723 417461 704722 545538 741998 761592 807333 809707 797165 748392 530578 443370 817482 821870 825694 827328 816764 463771 474842 467767 507772 509077 514787 523680 568440 583210 584666 552534 693341 707881 675424 710001 617603 606258 609712 624508 595654 775630 789870 786715 790101 801305 803144 803261 770444 787950 800305 800377 736866 740489 732775 743009 753548 761862 762559 753677 744711 747954 702320 775284 800275 803244 807663 424023 466187 477409 235834 453624 483258 766687 504764 511889 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (0.67%) |
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 235834 400609 400723 417461 424023 443370 453624 462500 463771 466187 467767 469844 470734 474842 477409 483258 504764 507772 509077 511889 514787 523680 530578 541250 545538 552534 568440 583210 584666 586789 595654 604425 606258 609712 615112 617603 618528 624508 626330 627171 633665 644708 675424 680682 684096 686082 693341 701508 702320 704722 707881 710001 716124 719124 722080 726703 731432 732775 735524 736866 736980 737910 738257 738623 738970 740084 740489 741114 741998 743009 744711 745386 747954 748392 753548 753677 753993 754967 758723 759634 761592 761862 762559 765763 765907 766687 770444 771874 774927 775284 775630 776138 784925 786715 787950 789870 789877 790101 793436 797165 798171 800275 800305 800377 801305 803144 803244 803261 804959 805727 807333 807663 809707 810533 811866 816764 817482 821870 825694 827328 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"стариками молодые дом…"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"старый молодые домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.