Query Metrics
7
Database Queries
7
Different statements
190.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.86 ms (86.05%) |
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 192968 233376 282494 382907 385743 386194 386514 386705 387186 388066 388078 388122 389116 389178 390533 391175 391893 391897 401586 401591 404257 405479 406091 409727 417067 420562 421182 426698 426727 429391 443685 445776 447540 453691 453852 461385 461478 470078 470548 470597 471545 473321 476838 484385 492676 497575 501178 501785 504168 505922 506786 523305 533679 534147 543654 543736 543943 546664 546667 547988 547991 557944 557973 566447 575515 588899 596577 596990 597557 598565 598571 613381 643986 651906 651945 654206 654471 654505 659287 659410 661244 661289 671000 672490 679067 683031 683291 691675 700941 721307 721318 721417 721568 736055 739052 740797 741950 743644 743893 744441 747145 758973 762217 770141 781414 782036 784324 784700 788101 790654 792511 795151 796545 797402 798693 799674 799929 800556 809779 810192 ] |
||||||||||||||||||||||||||||||
|
16.09 ms (8.45%) |
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 386705 792511 721568 386514 406091 597557 654206 721417 417067 651906 471545 233376 445776 781414 784324 533679 758973 388078 453852 429391 401591 523305 575515 391893 453691 505922 543736 387186 596990 679067 790654 784700 426727 401586 691675 613381 741950 671000 661289 744441 389178 461385 659410 390533 557944 501785 721318 739052 501178 443685 470548 747145 651945 659287 798693 809779 506786 404257 484385 547991 566447 782036 740797 596577 504168 762217 788101 643986 389116 391175 800556 473321 420562 391897 386194 476838 654471 654505 743644 797402 534147 588899 683031 543654 810192 282494 388066 721307 546664 683291 382907 736055 770141 426698 470078 546667 672490 700941 598565 743893 421182 470597 557973 796545 795151 492676 192968 661244 405479 409727 547988 598571 385743 497575 388122 543943 799929 799674 461478 447540 ] |
||||||||||||||||||||||||||||||
|
3.41 ms (1.79%) |
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 192968 233376 282494 382907 385743 386194 386514 386705 387186 388066 388078 388122 389116 389178 390533 391175 391893 391897 401586 401591 404257 405479 406091 409727 417067 420562 421182 426698 426727 429391 443685 445776 447540 453691 453852 461385 461478 470078 470548 470597 471545 473321 476838 484385 492676 497575 501178 501785 504168 505922 506786 523305 533679 534147 543654 543736 543943 546664 546667 547988 547991 557944 557973 566447 575515 588899 596577 596990 597557 598565 598571 613381 643986 651906 651945 654206 654471 654505 659287 659410 661244 661289 671000 672490 679067 683031 683291 691675 700941 721307 721318 721417 721568 736055 739052 740797 741950 743644 743893 744441 747145 758973 762217 770141 781414 782036 784324 784700 788101 790654 792511 795151 796545 797402 798693 799674 799929 800556 809779 810192 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"руское втроем"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.