Query Metrics
7
Database Queries
7
Different statements
192.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.17 ms (85.08%) |
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 14578 390212 440868 461371 463778 465071 467001 470420 474103 476264 476379 477156 477737 478003 478252 478451 478667 481840 483092 486807 490033 494732 498626 500214 501498 503830 504155 505108 506068 507916 509633 512965 516631 517568 519938 520157 520906 521529 522914 523034 524778 525017 526421 526891 529122 529140 529232 532059 533728 533997 535025 536483 536884 540733 544187 545943 546115 549217 549715 550831 555263 556654 557148 557150 557180 558077 558339 561096 562895 562955 563619 565713 568427 569415 570722 570963 573230 574145 575441 575890 576683 576713 577361 579761 582404 584643 585104 587511 590377 591123 591265 593047 593544 593877 594353 595054 596872 599550 600938 602011 602747 603247 603387 604164 606825 610042 612868 620202 622410 636475 644345 664954 666404 666443 667875 668730 699525 749907 775569 809189 ] |
||||||||||||||||||||||||||||||
|
17.54 ms (9.09%) |
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 699525 14578 749907 478451 522914 498626 501498 526891 478252 545943 576713 562895 575890 561096 550831 590377 593877 594353 596872 602011 602747 603247 612868 478003 524778 557148 477156 517568 575441 664954 591123 595054 600938 593544 593047 599550 557180 549217 591265 390212 476379 507916 535025 569415 668730 636475 486807 503830 644345 606825 555263 570722 576683 582404 610042 440868 476264 463778 461371 465071 474103 467001 477737 505108 512965 520157 520906 521529 529140 532059 536884 523034 525017 519938 526421 529122 544187 557150 558077 568427 579761 565713 577361 546115 556654 563619 570963 573230 574145 584643 667875 666404 666443 549715 558339 562955 603387 604164 622410 587511 620202 809189 775569 585104 478667 481840 483092 470420 490033 494732 506068 509633 529232 500214 516631 533728 533997 536483 540733 504155 ] |
||||||||||||||||||||||||||||||
|
3.83 ms (1.98%) |
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 14578 390212 440868 461371 463778 465071 467001 470420 474103 476264 476379 477156 477737 478003 478252 478451 478667 481840 483092 486807 490033 494732 498626 500214 501498 503830 504155 505108 506068 507916 509633 512965 516631 517568 519938 520157 520906 521529 522914 523034 524778 525017 526421 526891 529122 529140 529232 532059 533728 533997 535025 536483 536884 540733 544187 545943 546115 549217 549715 550831 555263 556654 557148 557150 557180 558077 558339 561096 562895 562955 563619 565713 568427 569415 570722 570963 573230 574145 575441 575890 576683 576713 577361 579761 582404 584643 585104 587511 590377 591123 591265 593047 593544 593877 594353 595054 596872 599550 600938 602011 602747 603247 603387 604164 606825 610042 612868 620202 622410 636475 644345 664954 666404 666443 667875 668730 699525 749907 775569 809189 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сосет зрелая"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сосет зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.75%) |
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.