Query Metrics
7
Database Queries
7
Different statements
371.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
347.40 ms (93.55%) |
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 17058 414078 424147 424160 427850 437618 441197 446154 449472 459024 460782 474831 477515 479394 488135 508207 511172 516166 517607 528920 531918 536959 537260 540655 545094 546089 556993 557051 558838 560763 574978 577155 578521 578585 579332 579403 583467 584196 584246 584944 591170 592987 593967 600518 606896 618040 619271 625467 625558 631329 631851 635578 635854 648672 649093 650258 654224 654290 656674 675345 692421 695686 697199 700902 703496 712668 718438 719792 722358 728686 729903 730723 732916 733231 733332 741076 741382 742022 742662 742682 742684 744368 746846 756722 761197 761513 761668 762513 766333 771069 772795 773945 774282 779423 785142 786781 787406 790498 790578 793081 793223 795779 795848 796453 798161 800784 800810 801675 802488 803575 804993 807488 810955 811038 813106 816710 819832 824194 824420 827033 ] |
||||||||||||||||||||||||||||||
|
14.12 ms (3.80%) |
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 414078 816710 824194 449472 531918 557051 546089 648672 697199 722358 695686 584944 592987 600518 631851 593967 793223 796453 803575 793081 800784 811038 730723 798161 807488 810955 761197 742022 766333 459024 446154 516166 537260 675345 785142 800810 741076 517607 824420 584196 17058 819832 508207 578521 583467 795848 801675 729903 741382 728686 427850 536959 813106 802488 650258 771069 560763 579403 649093 606896 437618 474831 545094 635854 579332 773945 795779 656674 761668 654290 718438 584246 618040 756722 540655 558838 703496 591170 742682 762513 733231 827033 460782 477515 719792 635578 790578 790498 746846 761513 772795 804993 511172 528920 556993 578585 786781 733332 787406 441197 424160 574978 577155 625467 742662 424147 700902 732916 712668 654224 744368 774282 488135 692421 619271 625558 631329 779423 742684 479394 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (0.78%) |
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 17058 414078 424147 424160 427850 437618 441197 446154 449472 459024 460782 474831 477515 479394 488135 508207 511172 516166 517607 528920 531918 536959 537260 540655 545094 546089 556993 557051 558838 560763 574978 577155 578521 578585 579332 579403 583467 584196 584246 584944 591170 592987 593967 600518 606896 618040 619271 625467 625558 631329 631851 635578 635854 648672 649093 650258 654224 654290 656674 675345 692421 695686 697199 700902 703496 712668 718438 719792 722358 728686 729903 730723 732916 733231 733332 741076 741382 742022 742662 742682 742684 744368 746846 756722 761197 761513 761668 762513 766333 771069 772795 773945 774282 779423 785142 786781 787406 790498 790578 793081 793223 795779 795848 796453 798161 800784 800810 801675 802488 803575 804993 807488 810955 811038 813106 816710 819832 824194 824420 827033 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck friend wife"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.51%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс friend жен"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс friend жен"
]
|
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.