Query Metrics
7
Database Queries
7
Different statements
141.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.66 ms (83.70%) |
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 394218 399923 401873 407384 413097 442415 442452 464144 471780 472299 519938 524291 527449 532051 532054 533097 541102 541175 546102 550519 568133 584395 587693 589646 594925 594973 596096 596128 596253 599813 603113 604877 605560 606121 609977 612688 617539 619613 620129 624111 629256 633456 639953 641372 642326 666659 667287 668156 671920 675253 681997 687572 693991 695390 699708 702347 714377 714387 714408 715413 715443 715662 717076 718518 718950 718969 719175 720036 721692 726289 726631 727697 733394 734663 738092 745301 746262 750900 751516 752915 755354 759451 772106 776632 776639 780902 781960 790407 790830 790855 793486 793506 795774 797703 798039 798215 798317 803774 804218 804383 805625 805679 805719 807509 807524 808111 808476 812489 814815 815844 815938 816732 817333 818893 819222 820178 821210 824618 826555 ] |
||||||||||||||||||||||||||||||
|
13.58 ms (9.58%) |
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 828044 666659 464144 519938 527449 596096 399923 442415 745301 442452 815844 815938 820178 826555 816732 818893 821210 814815 817333 824618 532054 533097 532051 541102 541175 550519 568133 668156 681997 695390 714377 714387 714408 715443 720036 721692 667287 671920 693991 715413 717076 718950 675253 687572 702347 718969 619613 629256 587693 596128 617539 620129 639953 642326 589646 596253 612688 594973 599813 603113 641372 790407 793486 807509 807524 808476 812489 776639 798215 798317 805625 805719 726289 734663 738092 752915 759451 772106 793506 795774 798039 803774 808111 755354 726631 727697 750900 733394 751516 699708 718518 719175 776632 780902 781960 790855 804218 805679 401873 394218 407384 819222 546102 606121 604877 609977 790830 804383 797703 746262 605560 633456 471780 472299 624111 413097 524291 584395 715662 594925 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.87%) |
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 394218 399923 401873 407384 413097 442415 442452 464144 471780 472299 519938 524291 527449 532051 532054 533097 541102 541175 546102 550519 568133 584395 587693 589646 594925 594973 596096 596128 596253 599813 603113 604877 605560 606121 609977 612688 617539 619613 620129 624111 629256 633456 639953 641372 642326 666659 667287 668156 671920 675253 681997 687572 693991 695390 699708 702347 714377 714387 714408 715413 715443 715662 717076 718518 718950 718969 719175 720036 721692 726289 726631 727697 733394 734663 738092 745301 746262 750900 751516 752915 755354 759451 772106 776632 776639 780902 781960 790407 790830 790855 793486 793506 795774 797703 798039 798215 798317 803774 804218 804383 805625 805679 805719 807509 807524 808111 808476 812489 814815 815844 815938 816732 817333 818893 819222 820178 821210 824618 826555 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"natural tits mom"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"натуральная натуральные сиськ без силикон mom"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"натуральная натуральные сиськ без силикон mom"
]
|
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.