Query Metrics
7
Database Queries
7
Different statements
160.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.96 ms (82.85%) |
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 21981 388440 388532 396672 407871 411883 413488 424795 429547 448863 460011 468537 487486 497924 504488 510898 515200 525350 531181 533481 540084 545325 592862 593358 600312 604891 605909 606831 620105 621225 626378 626547 631593 632650 636320 639274 641978 642032 642308 642323 653187 653560 672355 674430 681081 683660 692599 697220 703963 714892 716977 718784 719327 720308 720339 720717 720946 722545 725743 727151 732791 733887 742927 744323 744896 750699 751316 753774 756614 759015 760612 765156 765211 765479 768125 771510 775632 782978 784792 787043 788569 789637 789710 789892 789945 789958 790038 790667 790889 791205 791457 795390 796734 796919 797071 797771 798918 800667 801416 801938 802315 804498 805039 805201 805995 807589 808886 810132 815031 815317 815396 815801 815816 816292 818442 818475 820884 824434 826972 827404 ] |
||||||||||||||||||||||||||||||
|
15.99 ms (9.96%) |
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 760612 771510 804498 672355 720946 732791 413488 460011 681081 642308 765156 641978 789892 674430 639274 424795 818475 604891 720308 642323 775632 429547 396672 815396 692599 797771 798918 815317 824434 714892 653187 720339 789710 796734 801938 725743 789945 744896 765211 751316 703963 797071 21981 606831 626547 782978 810132 407871 448863 826972 697220 605909 805201 742927 756614 789958 791205 515200 525350 815031 815801 815816 818442 545325 718784 621225 533481 487486 683660 504488 816292 626378 796919 790667 791457 808886 759015 600312 531181 807589 765479 593358 411883 768125 592862 620105 805039 720717 800667 802315 632650 716977 653560 631593 642032 636320 388532 820884 540084 784792 733887 744323 727151 827404 788569 388440 468537 750699 719327 787043 790889 789637 801416 753774 790038 795390 805995 510898 497924 722545 ] |
||||||||||||||||||||||||||||||
|
3.42 ms (2.13%) |
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 21981 388440 388532 396672 407871 411883 413488 424795 429547 448863 460011 468537 487486 497924 504488 510898 515200 525350 531181 533481 540084 545325 592862 593358 600312 604891 605909 606831 620105 621225 626378 626547 631593 632650 636320 639274 641978 642032 642308 642323 653187 653560 672355 674430 681081 683660 692599 697220 703963 714892 716977 718784 719327 720308 720339 720717 720946 722545 725743 727151 732791 733887 742927 744323 744896 750699 751316 753774 756614 759015 760612 765156 765211 765479 768125 771510 775632 782978 784792 787043 788569 789637 789710 789892 789945 789958 790038 790667 790889 791205 791457 795390 796734 796919 797071 797771 798918 800667 801416 801938 802315 804498 805039 805201 805995 807589 808886 810132 815031 815317 815396 815801 815816 816292 818442 818475 820884 824434 826972 827404 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob squirt"
]
|
||||||||||||||||||||||||||||||
|
2.13 ms (1.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.08%) |
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.