Query Metrics
7
Database Queries
7
Different statements
151.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.52 ms (84.62%) |
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 566 68945 73571 129246 209941 382606 383111 384796 386206 386514 386871 388208 404211 418545 435409 452399 491025 501144 514362 527023 533335 566833 573912 577677 578845 588665 591133 599595 603741 612162 617179 617377 624039 624207 626520 628295 634064 641439 644338 646915 651617 656796 679407 686044 688639 695638 700921 704409 713186 713983 718497 719047 719228 720558 721282 729884 732752 738047 742938 744065 744822 747133 753278 753299 753303 753381 753405 753861 753949 755289 757282 772603 774077 775608 775627 775647 776685 779509 780627 781971 782771 784258 785835 786880 791307 791841 792228 792241 792939 793546 793713 793808 794518 797028 799728 802349 804119 804130 807715 807954 810586 813475 817689 818197 818831 819002 819080 819143 819754 819957 820095 823166 823487 823539 823551 823842 824125 825065 826054 826561 ] |
||||||||||||||||||||||||||||||
|
12.86 ms (8.47%) |
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 452399 209941 382606 566833 782771 786880 792228 578845 753861 819002 819754 823539 826054 826561 818831 819957 817689 818197 820095 823551 514362 713186 721282 719228 720558 603741 612162 591133 626520 775627 791307 793713 799728 775608 797028 729884 744822 785835 804130 732752 753949 775647 792241 383111 384796 129246 807954 753278 774077 747133 776685 386871 386514 527023 624039 491025 68945 388208 418545 823487 695638 651617 700921 617377 599595 780627 807715 779509 784258 793808 804119 813475 742938 753381 793546 802349 810586 753299 753303 755289 744065 753405 719047 781971 791841 73571 404211 624207 738047 435409 501144 386206 566 823842 819143 824125 819080 823166 825065 533335 577677 573912 646915 688639 704409 713983 718497 656796 679407 686044 628295 644338 634064 617179 588665 641439 792939 794518 757282 772603 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (2.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 566 68945 73571 129246 209941 382606 383111 384796 386206 386514 386871 388208 404211 418545 435409 452399 491025 501144 514362 527023 533335 566833 573912 577677 578845 588665 591133 599595 603741 612162 617179 617377 624039 624207 626520 628295 634064 641439 644338 646915 651617 656796 679407 686044 688639 695638 700921 704409 713186 713983 718497 719047 719228 720558 721282 729884 732752 738047 742938 744065 744822 747133 753278 753299 753303 753381 753405 753861 753949 755289 757282 772603 774077 775608 775627 775647 776685 779509 780627 781971 782771 784258 785835 786880 791307 791841 792228 792241 792939 793546 793713 793808 794518 797028 799728 802349 804119 804130 807715 807954 810586 813475 817689 818197 818831 819002 819080 819143 819754 819957 820095 823166 823487 823539 823551 823842 824125 825065 826054 826561 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс pussy"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck pussy"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс pussy"
]
|
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.