Query Metrics
7
Database Queries
7
Different statements
365.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.20 ms (57.56%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс vintage"
]
|
||||||||||||||||||||||||||||||
|
130.72 ms (35.79%) |
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 540656 541371 542493 542554 543010 544274 544317 544321 546469 546473 548679 549220 550646 559118 561367 563180 563204 563390 563417 566158 566371 566475 566866 567381 567407 567423 569788 569855 570859 572533 573791 574263 575685 576626 576633 577295 581390 584008 587471 590396 592452 592518 598427 601337 615459 620172 621693 623836 624394 624789 624790 629009 638631 644303 644310 644314 644323 644345 644643 644968 648285 649147 649153 649154 650836 650853 652555 654183 668941 669566 670106 671721 671734 671736 672144 672151 674100 677699 677706 681782 684947 689998 690833 690853 690875 692440 693026 693034 693864 693980 694179 694201 697262 698457 699578 699606 703436 703537 705791 707265 708605 709052 712715 716659 719101 720819 722208 723527 723632 729886 730224 733071 733118 741434 744276 748551 789844 800625 818992 823358 ] |
||||||||||||||||||||||||||||||
|
15.56 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 644303 723632 566158 668941 674100 684947 699578 563390 563417 576626 587471 624394 730224 624790 707265 708605 719101 540656 584008 566371 698457 644345 615459 644314 638631 644310 650853 818992 543010 559118 566866 563204 671736 690833 692440 652555 690853 693026 693034 592518 620172 800625 744276 733118 644323 544317 649154 544274 548679 550646 542554 566475 567407 573791 567423 644968 649147 624789 542493 669566 563180 729886 697262 549220 576633 590396 544321 569788 601337 623836 644643 716659 677706 650836 823358 561367 575685 546473 677699 689998 648285 670106 546469 569855 570859 574263 621693 598427 741434 581390 672144 703537 671734 748551 649153 722208 672151 703436 541371 693864 694179 681782 567381 690875 705791 712715 733071 723527 694201 671721 699606 709052 720819 592452 789844 629009 572533 577295 654183 693980 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (0.79%) |
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 540656 541371 542493 542554 543010 544274 544317 544321 546469 546473 548679 549220 550646 559118 561367 563180 563204 563390 563417 566158 566371 566475 566866 567381 567407 567423 569788 569855 570859 572533 573791 574263 575685 576626 576633 577295 581390 584008 587471 590396 592452 592518 598427 601337 615459 620172 621693 623836 624394 624789 624790 629009 638631 644303 644310 644314 644323 644345 644643 644968 648285 649147 649153 649154 650836 650853 652555 654183 668941 669566 670106 671721 671734 671736 672144 672151 674100 677699 677706 681782 684947 689998 690833 690853 690875 692440 693026 693034 693864 693980 694179 694201 697262 698457 699578 699606 703436 703537 705791 707265 708605 709052 712715 716659 719101 720819 722208 723527 723632 729886 730224 733071 733118 741434 744276 748551 789844 800625 818992 823358 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob vintage"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс vintage"
]
|
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.