Query Metrics
7
Database Queries
7
Different statements
270.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
249.09 ms (92.01%) |
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 495893 548819 549117 551489 551732 553362 558268 561043 574255 574774 578345 596372 599830 607678 610883 612037 612846 613724 613913 615467 615687 616016 617225 619876 621634 623191 624106 624379 625405 626804 627694 634954 635705 637771 639243 641300 645722 646387 648096 649271 651327 660275 661631 663781 667092 669328 675347 680292 682272 683323 684441 685041 685768 688483 689100 691938 700817 702240 703727 703732 704412 704418 705491 705870 708085 711183 713310 713311 713354 714327 716549 718306 720266 721651 722157 723824 727317 728683 730840 730974 733213 733747 737259 738634 743862 746363 747825 750261 753919 754880 754884 758580 760455 762019 762282 762299 764827 766456 768300 770673 773473 773834 776953 780253 781074 782085 784914 786431 787084 792192 793331 793876 794551 795691 799676 799711 802614 813618 813736 ] |
||||||||||||||||||||||||||||||
|
11.54 ms (4.26%) |
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 574255 578345 548819 551489 553362 558268 561043 661631 663781 683323 685041 713311 718306 722157 646387 649271 688483 691938 700817 704418 711183 645722 667092 703727 551732 610883 615467 621634 613724 634954 613913 617225 635705 793876 799676 802614 776953 792192 733747 746363 754884 760455 799711 730840 762282 773473 738634 750261 758580 766456 728683 733213 768300 619876 637771 705491 705870 780253 781074 596372 639243 626804 813618 721651 794551 762019 764827 754880 813736 495893 549117 574774 648096 651327 669328 684441 702240 703732 708085 720266 680292 682272 704412 660275 675347 685768 689100 713354 714327 607678 627694 612846 616016 623191 624106 624379 625405 612037 599830 641300 793331 737259 743862 762299 770673 787084 795691 730974 747825 753919 773834 723824 727317 615687 713310 716549 778332 782085 784914 786431 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.11%) |
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 495893 548819 549117 551489 551732 553362 558268 561043 574255 574774 578345 596372 599830 607678 610883 612037 612846 613724 613913 615467 615687 616016 617225 619876 621634 623191 624106 624379 625405 626804 627694 634954 635705 637771 639243 641300 645722 646387 648096 649271 651327 660275 661631 663781 667092 669328 675347 680292 682272 683323 684441 685041 685768 688483 689100 691938 700817 702240 703727 703732 704412 704418 705491 705870 708085 711183 713310 713311 713354 714327 716549 718306 720266 721651 722157 723824 727317 728683 730840 730974 733213 733747 737259 738634 743862 746363 747825 750261 753919 754880 754884 758580 760455 762019 762282 762299 764827 766456 768300 770673 773473 773834 776953 780253 781074 782085 784914 786431 787084 792192 793331 793876 794551 795691 799676 799711 802614 813618 813736 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.70%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск teens секс"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur teens sex"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск teens секс"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.62%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.