Query Metrics
7
Database Queries
7
Different statements
441.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
411.99 ms (93.37%) |
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 12128 16646 61168 105093 145353 151014 233112 382388 383932 387447 387496 389500 389860 397223 397772 398690 398957 399917 400348 403144 407165 407795 407797 413142 413309 414734 415430 415556 417298 418968 419330 420266 424562 424576 426423 426784 427623 429449 431117 439572 440581 443538 445724 445752 448672 449295 450108 451588 452061 452248 452626 452687 454151 456390 460917 462485 462612 465731 466989 467031 468941 469017 474400 479820 480742 482569 484384 485017 486835 491444 492108 497253 498355 505623 508582 519931 520407 547932 556847 556848 563452 582811 583655 590417 595704 598911 606791 616873 630596 643040 651937 660389 676915 717711 718501 720591 721275 728452 729587 734173 736274 745771 749003 751190 756318 772430 779178 780158 780631 781347 781496 786123 787106 788823 799206 804356 806239 810051 810062 814779 ] |
||||||||||||||||||||||||||||||
|
20.10 ms (4.55%) |
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 485017 497253 498355 508582 443538 452626 582811 452248 479820 520407 419330 427623 418968 450108 445724 660389 799206 804356 806239 413309 445752 462612 718501 397223 717711 407795 426423 407797 474400 505623 598911 606791 728452 467031 439572 440581 492108 398957 383932 397772 400348 398690 413142 781496 786123 788823 729587 749003 772430 734173 426784 456390 233112 399917 145353 781347 389860 814779 449295 454151 583655 556848 556847 590417 415430 424562 460917 465731 387447 420266 452687 417298 491444 466989 547932 616873 630596 105093 720591 61168 414734 651937 486835 151014 415556 643040 595704 452061 519931 389500 431117 448672 462485 451588 480742 429449 469017 468941 484384 382388 12128 16646 387496 403144 424576 407165 482569 676915 721275 563452 780158 780631 810051 779178 736274 745771 756318 751190 787106 810062 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (0.70%) |
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 12128 16646 61168 105093 145353 151014 233112 382388 383932 387447 387496 389500 389860 397223 397772 398690 398957 399917 400348 403144 407165 407795 407797 413142 413309 414734 415430 415556 417298 418968 419330 420266 424562 424576 426423 426784 427623 429449 431117 439572 440581 443538 445724 445752 448672 449295 450108 451588 452061 452248 452626 452687 454151 456390 460917 462485 462612 465731 466989 467031 468941 469017 474400 479820 480742 482569 484384 485017 486835 491444 492108 497253 498355 505623 508582 519931 520407 547932 556847 556848 563452 582811 583655 590417 595704 598911 606791 616873 630596 643040 651937 660389 676915 717711 718501 720591 721275 728452 729587 734173 736274 745771 749003 751190 756318 772430 779178 780158 780631 781347 781496 786123 787106 788823 799206 804356 806239 810051 810062 814779 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boy lick"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парен лиза"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.32 ms (0.30%) |
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.