Query Metrics
7
Database Queries
7
Different statements
220.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
192.46 ms (87.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 383606 386166 410227 412830 413687 417389 421732 427539 429890 436230 445401 445413 447985 451755 453137 454981 459778 461612 463855 469219 477055 477118 484183 489311 493679 497509 499211 500787 502462 504482 507542 512543 517816 518185 523273 523355 531821 535649 541325 542881 543208 546924 547496 547853 551428 554447 555033 557455 558981 565142 569572 583712 583919 585172 598310 607099 614026 616296 617164 624041 630074 632605 637115 637446 640777 666623 668449 668526 669062 674328 675512 692688 696111 700990 702630 704208 716384 717243 726749 727762 728388 728889 729185 731808 732698 735120 735452 738146 745121 745867 747404 752645 754770 772881 773701 776956 777847 785582 790409 793534 794300 796077 796445 797218 797303 797356 799752 799759 801544 807494 814766 817210 817291 822473 822996 824594 824700 824939 825243 827632 ] |
||||||||||||||||||||||||||||||
|
16.76 ms (7.61%) |
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 637115 632605 666623 598310 555033 410227 824939 817210 745867 531821 547853 822473 825243 674328 617164 504482 797303 728388 738146 436230 454981 747404 421732 453137 704208 477118 417389 461612 499211 546924 692688 484183 542881 451755 547496 429890 824700 797356 752645 668526 383606 637446 754770 807494 535649 607099 799759 785582 716384 668449 445401 469219 386166 814766 822996 824594 583919 543208 557455 558981 675512 585172 630074 794300 796445 776956 796077 801544 772881 799752 735452 731808 427539 459778 493679 497509 500787 477055 583712 669062 616296 614026 777847 793534 412830 507542 489311 502462 413687 512543 541325 569572 700990 790409 773701 445413 518185 523273 624041 517816 523355 827632 728889 729185 554447 717243 797218 726749 732698 727762 702630 640777 735120 817291 745121 463855 447985 551428 696111 565142 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.36%) |
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 383606 386166 410227 412830 413687 417389 421732 427539 429890 436230 445401 445413 447985 451755 453137 454981 459778 461612 463855 469219 477055 477118 484183 489311 493679 497509 499211 500787 502462 504482 507542 512543 517816 518185 523273 523355 531821 535649 541325 542881 543208 546924 547496 547853 551428 554447 555033 557455 558981 565142 569572 583712 583919 585172 598310 607099 614026 616296 617164 624041 630074 632605 637115 637446 640777 666623 668449 668526 669062 674328 675512 692688 696111 700990 702630 704208 716384 717243 726749 727762 728388 728889 729185 731808 732698 735120 735452 738146 745121 745867 747404 752645 754770 772881 773701 776956 777847 785582 790409 793534 794300 796077 796445 797218 797303 797356 799752 799759 801544 807494 814766 817210 817291 822473 822996 824594 824700 824939 825243 827632 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gape fuck"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие дырк секс"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.78%) |
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.