Query Metrics
7
Database Queries
7
Different statements
155.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.42 ms (82.62%) |
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 401628 439268 447934 448609 452375 452890 456161 477090 493834 504075 514845 521139 523355 523393 528951 530755 531016 531588 531638 536100 536718 540891 540917 541377 545473 553586 554215 558912 562578 573493 575315 576583 585842 587210 590073 592330 594152 594363 601295 602179 603391 604181 606402 606426 608467 615983 618808 624811 628518 634106 641794 642097 644498 648503 648669 651059 656803 656804 656842 657478 658802 662856 667033 670811 671782 679643 694660 695906 700821 709562 710709 713240 714235 717542 717548 722273 722377 722428 729370 738822 739281 740922 740926 742005 742316 745086 745128 749221 752450 752634 752755 752784 757514 758780 758794 766939 770216 770413 774112 776927 777001 777818 782351 782441 782512 782515 782517 782539 782844 785868 786879 787515 788486 791014 796930 803105 805257 807190 811700 825442 ] |
||||||||||||||||||||||||||||||
|
16.44 ms (10.57%) |
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 634106 601295 615983 587210 594363 594152 624811 782512 786879 796930 740922 752450 758780 782515 785868 787515 742316 770216 752634 758794 770413 644498 777001 805257 401628 448609 452375 439268 452890 447934 456161 514845 523393 523355 825442 540891 477090 504075 521139 528951 530755 531016 536718 536100 531588 531638 493834 540917 545473 553586 554215 573493 576583 562578 575315 541377 558912 648503 648669 651059 656842 667033 679643 700821 713240 717542 717548 656803 656804 658802 662856 722273 722428 657478 670811 671782 694660 695906 709562 710709 714235 722377 590073 604181 628518 641794 618808 585842 606426 608467 592330 602179 603391 606402 642097 776927 782844 788486 811700 777818 782351 782441 803105 782517 782539 791014 807190 749221 757514 766939 774112 738822 739281 745086 752755 752784 729370 742005 745128 740926 ] |
||||||||||||||||||||||||||||||
|
3.57 ms (2.29%) |
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 401628 439268 447934 448609 452375 452890 456161 477090 493834 504075 514845 521139 523355 523393 528951 530755 531016 531588 531638 536100 536718 540891 540917 541377 545473 553586 554215 558912 562578 573493 575315 576583 585842 587210 590073 592330 594152 594363 601295 602179 603391 604181 606402 606426 608467 615983 618808 624811 628518 634106 641794 642097 644498 648503 648669 651059 656803 656804 656842 657478 658802 662856 667033 670811 671782 679643 694660 695906 700821 709562 710709 713240 714235 717542 717548 722273 722377 722428 729370 738822 739281 740922 740926 742005 742316 745086 745128 749221 752450 752634 752755 752784 757514 758780 758794 766939 770216 770413 774112 776927 777001 777818 782351 782441 782512 782515 782517 782539 782844 785868 786879 787515 788486 791014 796930 803105 805257 807190 811700 825442 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo ass teen"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло жоп teen"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло жоп teen"
]
|
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.