Query Metrics
7
Database Queries
7
Different statements
151.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.38 ms (83.32%) |
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 223010 385208 393016 398355 408334 416887 419246 428675 447930 458608 459627 462066 462160 466928 475070 483776 483960 487206 488164 490451 495014 504533 505666 507124 509571 512693 514435 518586 528360 528452 529189 533268 546052 546194 552927 558837 567341 570177 572208 572243 572705 581148 583894 583966 583990 599449 602692 606881 606991 608353 610806 612237 612287 614194 616382 618048 619099 619318 626097 629201 650967 678780 678789 680825 683794 693367 695438 700949 704114 704422 705485 705491 705856 706601 708584 715163 719922 726943 732943 743936 746262 756871 757992 758392 760979 762145 762567 762979 767692 768185 772069 776230 783229 785918 787057 790913 792672 795230 799752 802218 804060 805249 807710 807715 810717 812080 816809 817895 817985 819427 819771 823637 823753 824953 824961 825388 825818 825986 826532 827887 ] |
||||||||||||||||||||||||||||||
|
14.79 ms (9.75%) |
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 514435 487206 570177 583990 612237 602692 614194 488164 616382 495014 567341 490451 700949 608353 583894 583966 528360 612287 419246 581148 705856 805249 512693 790913 705491 762567 447930 816809 678789 385208 458608 507124 546052 807715 819427 825986 610806 812080 799752 743936 757992 546194 528452 428675 776230 618048 223010 732943 466928 817895 792672 772069 819771 704422 705485 619318 599449 619099 683794 826532 726943 823637 504533 650967 785918 746262 760979 783229 787057 509571 518586 817985 680825 823753 824961 462066 762979 824953 768185 393016 572705 558837 704114 678780 795230 802218 762145 758392 629201 719922 810717 459627 706601 572243 398355 825818 572208 695438 693367 708584 606881 767692 756871 715163 505666 825388 804060 626097 807710 475070 483776 827887 483960 533268 529189 552927 606991 408334 462160 416887 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (2.12%) |
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 223010 385208 393016 398355 408334 416887 419246 428675 447930 458608 459627 462066 462160 466928 475070 483776 483960 487206 488164 490451 495014 504533 505666 507124 509571 512693 514435 518586 528360 528452 529189 533268 546052 546194 552927 558837 567341 570177 572208 572243 572705 581148 583894 583966 583990 599449 602692 606881 606991 608353 610806 612237 612287 614194 616382 618048 619099 619318 626097 629201 650967 678780 678789 680825 683794 693367 695438 700949 704114 704422 705485 705491 705856 706601 708584 715163 719922 726943 732943 743936 746262 756871 757992 758392 760979 762145 762567 762979 767692 768185 772069 776230 783229 785918 787057 790913 792672 795230 799752 802218 804060 805249 807710 807715 810717 812080 816809 817895 817985 819427 819771 823637 823753 824953 824961 825388 825818 825986 826532 827887 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pregnant fuck"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беремен секс"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"беремен секс"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.08%) |
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.