Query Metrics
7
Database Queries
7
Different statements
408.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.39 ms (50.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife husband sex"
]
|
||||||||||||||||||||||||||||||
|
174.44 ms (42.72%) |
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 383735 390289 391018 410873 411339 456357 480591 492038 493881 494920 495585 506563 507084 519271 527727 530125 531810 537155 546025 559237 562595 571107 575637 579853 581581 583662 584184 586216 586346 590653 592708 593837 594999 603449 605005 608177 611443 632928 635636 636066 642288 643927 644102 650978 650998 653069 653823 654236 666563 677553 679405 684314 686029 688567 689061 689155 693782 694177 701178 712651 712959 713708 714429 715410 716082 716408 716442 716586 719157 720612 725096 727343 727708 727767 730158 731040 733171 734388 736863 738888 742687 747230 748436 749658 755462 756724 759474 759580 762766 765911 768190 773550 780283 781747 785679 789272 790352 791498 792653 794531 795752 796288 796622 796811 798045 798908 799738 801095 801362 803562 803873 804028 804679 805350 811598 819146 819335 824206 824804 825255 ] |
||||||||||||||||||||||||||||||
|
15.03 ms (3.68%) |
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 456357 712651 507084 506563 531810 493881 654236 693782 694177 713708 632928 594999 801095 798045 731040 701178 714429 796622 492038 579853 684314 773550 790352 819335 530125 559237 581581 562595 653069 720612 571107 593837 586346 642288 590653 608177 730158 794531 796811 804679 805350 765911 747230 756724 759474 762766 716082 791498 796288 824804 748436 643927 495585 644102 734388 736863 742687 635636 819146 755462 768190 798908 494920 537155 677553 650978 653823 586216 611443 738888 716442 795752 804028 583662 592708 725096 686029 759580 383735 781747 792653 801362 799738 727708 716586 480591 715410 689155 712959 733171 410873 785679 780283 575637 689061 679405 636066 605005 719157 811598 584184 824206 716408 411339 825255 688567 603449 390289 727767 391018 666563 749658 527727 546025 650998 789272 803562 803873 727343 519271 ] |
||||||||||||||||||||||||||||||
|
6.76 ms (1.65%) |
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 383735 390289 391018 410873 411339 456357 480591 492038 493881 494920 495585 506563 507084 519271 527727 530125 531810 537155 546025 559237 562595 571107 575637 579853 581581 583662 584184 586216 586346 590653 592708 593837 594999 603449 605005 608177 611443 632928 635636 636066 642288 643927 644102 650978 650998 653069 653823 654236 666563 677553 679405 684314 686029 688567 689061 689155 693782 694177 701178 712651 712959 713708 714429 715410 716082 716408 716442 716586 719157 720612 725096 727343 727708 727767 730158 731040 733171 734388 736863 738888 742687 747230 748436 749658 755462 756724 759474 759580 762766 765911 768190 773550 780283 781747 785679 789272 790352 791498 792653 794531 795752 796288 796622 796811 798045 798908 799738 801095 801362 803562 803873 804028 804679 805350 811598 819146 819335 824206 824804 825255 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен husband секс"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен husband секс"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.35%) |
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.