Query Metrics
7
Database Queries
7
Different statements
145.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.62 ms (82.66%) |
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 389563 390530 416873 420641 427592 429685 444007 449300 450437 451632 453905 453968 455991 456385 456566 457765 459648 460055 461265 461306 463627 464121 473335 477732 479479 480823 482633 488238 488594 490964 490965 501027 501411 502532 504594 505545 509556 511944 515337 520096 521108 528901 530184 536206 548573 566025 576785 577486 577627 582000 583455 584917 589958 599193 601814 610066 610078 616936 619947 620475 620671 624857 626245 627093 628346 630660 631037 633241 641318 641886 647547 650104 652805 655159 662090 666370 671195 675188 678247 680616 682507 689145 690648 701266 701531 702320 707900 709914 713115 719192 719544 719600 722302 723622 723874 724604 727844 728468 733889 735461 735772 736548 741220 744958 745229 748443 755370 759005 759669 761891 768659 790475 790591 790858 802570 803549 813034 824362 824473 824745 ] |
||||||||||||||||||||||||||||||
|
14.27 ms (9.78%) |
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 824362 723622 583455 548573 577627 650104 671195 689145 701266 701531 719544 662090 680616 690648 722302 647547 655159 678247 709914 713115 566025 577486 589958 610078 616936 633241 619947 620671 624857 627093 630660 790591 803549 813034 727844 735461 736548 741220 755370 759005 759669 761891 735772 745229 641318 707900 790858 802570 824473 455991 459648 530184 511944 576785 628346 724604 768659 748443 416873 473335 460055 520096 390530 389563 505545 584917 719600 641886 631037 733889 464121 427592 599193 444007 420641 824745 453968 456385 456566 463627 449300 453905 457765 461306 479479 450437 451632 482633 488238 490964 501027 528901 502532 504594 509556 521108 536206 501411 515337 461265 488594 490965 582000 666370 719192 652805 675188 682507 626245 601814 790475 723874 728468 744958 610066 620475 702320 429685 477732 480823 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (2.20%) |
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 389563 390530 416873 420641 427592 429685 444007 449300 450437 451632 453905 453968 455991 456385 456566 457765 459648 460055 461265 461306 463627 464121 473335 477732 479479 480823 482633 488238 488594 490964 490965 501027 501411 502532 504594 505545 509556 511944 515337 520096 521108 528901 530184 536206 548573 566025 576785 577486 577627 582000 583455 584917 589958 599193 601814 610066 610078 616936 619947 620475 620671 624857 626245 627093 628346 630660 631037 633241 641318 641886 647547 650104 652805 655159 662090 666370 671195 675188 678247 680616 682507 689145 690648 701266 701531 702320 707900 709914 713115 719192 719544 719600 722302 723622 723874 724604 727844 728468 733889 735461 735772 736548 741220 744958 745229 748443 755370 759005 759669 761891 768659 790475 790591 790858 802570 803549 813034 824362 824473 824745 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие cock orgasm"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big cock orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие cock orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.16%) |
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.