Query Metrics
7
Database Queries
7
Different statements
385.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
351.67 ms (91.24%) |
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 402722 403939 406324 419546 419627 421520 423375 424469 425168 425490 428103 443425 443831 445543 446505 446894 448445 451957 454984 459830 460733 462321 462751 465525 466090 466112 466928 469534 470074 472777 473739 475796 476709 477020 481147 481149 487339 488308 491776 493192 495022 506056 511009 513710 515131 515717 515896 518473 518744 520840 521001 522616 524628 527902 528397 530637 534003 536248 536665 537198 537210 537888 539203 540511 541643 541650 541769 541924 543607 544455 544840 545611 545755 549176 555948 558130 559120 562906 563441 563546 564407 565172 567338 567909 569682 574244 577356 581096 583507 583622 586628 586886 590256 591272 603167 603622 605122 605450 607527 609906 611616 612399 615718 623199 623380 628087 628117 630537 631902 632701 639258 647343 647837 664583 666875 678779 704235 713176 801907 814901 ] |
||||||||||||||||||||||||||||||
|
24.12 ms (6.26%) |
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 515717 421520 814901 487339 448445 528397 465525 475796 555948 544455 647343 704235 664583 549176 567338 612399 615718 603622 628117 445543 470074 515896 423375 446505 472777 473739 477020 481147 583622 581096 678779 565172 443831 466112 476709 493192 559120 666875 590256 631902 481149 443425 466090 506056 462321 647837 623380 611616 419627 527902 446894 459830 454984 513710 406324 545755 544840 564407 609906 425168 518744 577356 491776 536248 536665 558130 607527 424469 488308 534003 419546 583507 628087 586886 541643 403939 495022 567909 515131 801907 639258 541769 428103 425490 466928 539203 524628 462751 562906 402722 563546 451957 540511 603167 632701 460733 537888 520840 537210 518473 543607 713176 630537 574244 605450 545611 522616 591272 469534 623199 530637 541924 605122 563441 541650 511009 586628 521001 537198 569682 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (0.77%) |
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 402722 403939 406324 419546 419627 421520 423375 424469 425168 425490 428103 443425 443831 445543 446505 446894 448445 451957 454984 459830 460733 462321 462751 465525 466090 466112 466928 469534 470074 472777 473739 475796 476709 477020 481147 481149 487339 488308 491776 493192 495022 506056 511009 513710 515131 515717 515896 518473 518744 520840 521001 522616 524628 527902 528397 530637 534003 536248 536665 537198 537210 537888 539203 540511 541643 541650 541769 541924 543607 544455 544840 545611 545755 549176 555948 558130 559120 562906 563441 563546 564407 565172 567338 567909 569682 574244 577356 581096 583507 583622 586628 586886 590256 591272 603167 603622 605122 605450 607527 609906 611616 612399 615718 623199 623380 628087 628117 630537 631902 632701 639258 647343 647837 664583 666875 678779 704235 713176 801907 814901 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"молодые старые мжм секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð╝ð¥ð╗ð¥ð┤ÐïðÁ Ðü ÐüÐéð░ÐÇÐïð╝ð© ð╝ðÂð╝ÔÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"молодые старые мжм секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.37%) |
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.