Query Metrics
7
Database Queries
7
Different statements
396.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.99 ms (52.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob threesome"
]
|
||||||||||||||||||||||||||||||
|
165.55 ms (41.77%) |
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 13066 67200 81651 81709 97288 338565 384015 386071 391175 401969 403243 403268 403938 418346 470600 490160 506843 521534 535304 539627 543095 543110 543177 543213 543688 544746 545589 552928 576512 587723 587819 593885 600005 601217 601547 603625 603629 603690 606471 619459 624819 630222 633160 649542 650842 652865 671004 671501 672015 672099 686021 690842 692330 699430 702344 702877 702974 710631 714080 715534 717246 718600 721769 729113 729839 731431 732730 732850 733045 733150 733830 737132 741118 741418 742786 744640 745208 745740 748182 748436 749548 752076 764373 766524 767177 767330 768369 770837 770841 770874 770885 770889 771538 775961 778812 784172 786031 788314 788669 792487 792511 792512 793342 797936 798778 800007 800342 800410 802103 805304 805819 805991 806110 807650 808359 815339 816475 819510 819658 822003 ] |
||||||||||||||||||||||||||||||
|
13.53 ms (3.41%) |
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 690842 593885 587723 619459 606471 633160 600005 800410 805991 729113 741118 770837 770841 784172 732730 733045 741418 744640 749548 766524 771538 732850 737132 742786 767177 768369 748182 630222 702974 775961 778812 788314 792512 806110 403938 81709 338565 544746 686021 672099 521534 603629 97288 403243 13066 418346 506843 386071 384015 822003 543177 624819 391175 67200 819510 543110 671501 699430 721769 798778 729839 702344 800342 81651 718600 733150 764373 802103 816475 819658 815339 539627 535304 543095 543213 543688 576512 649542 692330 710631 652865 545589 587819 603625 603690 793342 807650 808359 800007 805304 745740 752076 745208 733830 748436 767330 702877 715534 788669 792487 770889 786031 805819 552928 650842 671004 797936 770874 770885 601547 792511 717246 490160 731431 403268 401969 601217 714080 672015 470600 ] |
||||||||||||||||||||||||||||||
|
3.43 ms (0.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 13066 67200 81651 81709 97288 338565 384015 386071 391175 401969 403243 403268 403938 418346 470600 490160 506843 521534 535304 539627 543095 543110 543177 543213 543688 544746 545589 552928 576512 587723 587819 593885 600005 601217 601547 603625 603629 603690 606471 619459 624819 630222 633160 649542 650842 652865 671004 671501 672015 672099 686021 690842 692330 699430 702344 702877 702974 710631 714080 715534 717246 718600 721769 729113 729839 731431 732730 732850 733045 733150 733830 737132 741118 741418 742786 744640 745208 745740 748182 748436 749548 752076 764373 766524 767177 767330 768369 770837 770841 770874 770885 770889 771538 775961 778812 784172 786031 788314 788669 792487 792511 792512 793342 797936 798778 800007 800342 800410 802103 805304 805819 805991 806110 807650 808359 815339 816475 819510 819658 822003 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (0.53%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.38%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.27 ms (0.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.