Query Metrics
7
Database Queries
7
Different statements
235.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.24 ms (89.65%) |
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 6690 251767 260068 398525 402736 407141 420405 421808 423788 433042 433282 437861 441288 443027 446418 447611 449800 459194 460462 462406 473390 473867 479446 479926 482865 483237 486610 486992 487466 488745 494626 499578 500142 502172 502764 505266 508222 509667 515643 517941 518506 519057 523424 525057 528476 541559 547402 547992 553417 555457 561201 571259 571260 573244 574964 581739 583343 583684 585566 588441 588550 588902 593821 597712 599304 606539 606628 618119 623293 639078 641920 642439 650588 650673 656285 660727 662914 666890 667413 670232 675396 682652 687806 691423 696113 696336 698196 700181 702128 703730 704138 704840 705058 707214 707404 707931 709512 710663 711268 712643 713398 714906 716709 717219 719452 721037 813908 817257 818049 819448 823274 823345 823599 823943 824706 825998 826043 826624 827947 827964 ] |
||||||||||||||||||||||||||||||
|
14.62 ms (6.20%) |
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 421808 423788 433042 433282 437861 443027 446418 460462 473867 479926 402736 447611 441288 482865 508222 509667 523424 483237 486610 500142 502172 502764 519057 486992 488745 505266 515643 517941 518506 528476 251767 260068 6690 398525 407141 420405 823274 823599 826043 823943 825998 818049 824706 813908 817257 819448 823345 827947 827964 826624 479446 459194 449800 494626 499578 525057 462406 473390 487466 547992 555457 571259 571260 547402 574964 583343 541559 573244 650588 650673 675396 696336 703730 705058 707214 709512 711268 712643 719452 656285 660727 667413 670232 682652 691423 696113 700181 704138 707404 707931 710663 714906 716709 662914 666890 687806 698196 702128 704840 713398 717219 721037 553417 561201 581739 583684 588550 593821 599304 618119 639078 588441 588902 597712 606628 623293 641920 642439 585566 606539 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.11%) |
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 6690 251767 260068 398525 402736 407141 420405 421808 423788 433042 433282 437861 441288 443027 446418 447611 449800 459194 460462 462406 473390 473867 479446 479926 482865 483237 486610 486992 487466 488745 494626 499578 500142 502172 502764 505266 508222 509667 515643 517941 518506 519057 523424 525057 528476 541559 547402 547992 553417 555457 561201 571259 571260 573244 574964 581739 583343 583684 585566 588441 588550 588902 593821 597712 599304 606539 606628 618119 623293 639078 641920 642439 650588 650673 656285 660727 662914 666890 667413 670232 675396 682652 687806 691423 696113 696336 698196 700181 702128 703730 704138 704840 705058 707214 707404 707931 709512 710663 711268 712643 713398 714906 716709 717219 719452 721037 813908 817257 818049 819448 823274 823345 823599 823943 824706 825998 826043 826624 827947 827964 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"doggy cum"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рак cum"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.66%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рак cum"
]
|
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.