Query Metrics
7
Database Queries
7
Different statements
145.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.60 ms (82.89%) |
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 386781 456477 461910 480844 488385 489251 493967 497647 501039 504018 504023 505291 508396 508553 508711 509319 509933 515899 517133 517680 517682 518184 520241 521848 522634 524167 525828 526459 528124 528505 530193 531897 535516 539349 540310 540396 540812 541545 545713 546865 546890 556229 556372 558342 563587 563736 563792 568792 571149 574141 575583 578745 579576 579826 580624 580652 583877 584365 584504 585326 585574 591884 592907 595047 598349 607996 620371 625770 626120 629526 629821 630718 632144 633286 634952 635009 644785 645706 662486 684511 707169 710687 713927 715012 716013 716045 716270 723167 725772 727434 729376 733489 733802 738818 740196 740849 740869 746070 759673 760218 761596 764165 766263 771613 781052 788954 790869 791201 792316 793820 793871 794396 797392 797595 797660 802150 804602 804935 813534 ] |
||||||||||||||||||||||||||||||
|
13.91 ms (9.56%) |
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 716045 723167 793822 781052 788954 727434 766263 813534 746070 733802 738818 740849 629526 794396 525828 625770 579826 632144 797660 804602 729376 733489 793871 526459 528124 579576 575583 578745 634952 520241 528505 515899 558342 584365 541545 707169 684511 546865 546890 583877 584504 592907 595047 620371 633286 635009 585574 630718 598349 607996 790869 710687 540812 489251 517682 563736 713927 716013 715012 716270 644785 792316 793820 802150 791201 725772 740869 804935 771613 760218 764165 761596 629821 797392 568792 501039 563587 797595 759673 461910 508396 580624 662486 556229 645706 488385 509319 540310 540396 530193 580652 571149 556372 563792 591884 626120 585326 740196 386781 456477 480844 497647 505291 517133 522634 535516 508553 508711 517680 518184 521848 524167 539349 504023 531897 504018 509933 493967 545713 574141 ] |
||||||||||||||||||||||||||||||
|
3.36 ms (2.31%) |
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 386781 456477 461910 480844 488385 489251 493967 497647 501039 504018 504023 505291 508396 508553 508711 509319 509933 515899 517133 517680 517682 518184 520241 521848 522634 524167 525828 526459 528124 528505 530193 531897 535516 539349 540310 540396 540812 541545 545713 546865 546890 556229 556372 558342 563587 563736 563792 568792 571149 574141 575583 578745 579576 579826 580624 580652 583877 584365 584504 585326 585574 591884 592907 595047 598349 607996 620371 625770 626120 629526 629821 630718 632144 633286 634952 635009 644785 645706 662486 684511 707169 710687 713927 715012 716013 716045 716270 723167 725772 727434 729376 733489 733802 738818 740196 740849 740869 746070 759673 760218 761596 764165 766263 771613 781052 788954 790869 791201 792316 793820 793871 794396 797392 797595 797660 802150 804602 804935 813534 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"кончились внутри меня…"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кремпа сперм"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.22%) |
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.