Query Metrics
7
Database Queries
7
Different statements
392.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.97 ms (54.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"her жоп"
]
|
||||||||||||||||||||||||||||||
|
155.18 ms (39.52%) |
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 28625 62124 118472 170069 278472 394670 406044 408499 420328 486209 504687 511906 513163 514957 516014 516308 526849 531849 533090 534100 535993 537837 555632 566274 567126 571941 585853 589058 611040 623290 623959 624939 625688 626362 627412 627772 630096 638904 648481 662146 666820 668084 679190 685540 693490 698719 703328 703480 707819 707840 710223 710364 714011 717817 720328 724074 724131 725156 725194 725253 726671 731259 731301 732622 735084 735898 736925 740002 740876 740929 743170 744775 747625 750362 751181 752405 759939 761030 762941 763503 764151 764865 765632 766821 766959 766971 767268 773384 778717 780763 782446 782604 783197 783567 783819 784337 785811 786012 788099 790080 794131 796131 796157 799354 800473 800549 800631 803721 804086 805277 807285 807370 809806 810037 813295 813805 813915 816201 823922 826030 ] |
||||||||||||||||||||||||||||||
|
14.30 ms (3.64%) |
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 504687 526849 555632 566274 703480 648481 685540 626362 630096 585853 627772 785811 796131 800631 782446 782604 803721 725156 766959 788099 725194 731259 763503 735898 765632 783197 28625 394670 406044 420328 516308 813915 679190 717817 627412 743170 764151 714011 766821 752405 761030 767268 804086 810037 118472 535993 531849 486209 668084 707840 662146 698719 710364 703328 707819 720328 778717 783567 786012 813295 736925 747625 750362 751181 773384 783819 796157 800549 805277 807285 724131 735084 744775 762941 732622 807370 809806 516014 826030 513163 514957 589058 623290 638904 623959 740002 724074 764865 740929 611040 759939 537837 567126 624939 625688 780763 790080 726671 731301 766971 799354 62124 710223 816201 823922 666820 693490 725253 784337 794131 800473 740876 170069 278472 408499 813805 534100 533090 511906 571941 ] |
||||||||||||||||||||||||||||||
|
3.45 ms (0.88%) |
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 28625 62124 118472 170069 278472 394670 406044 408499 420328 486209 504687 511906 513163 514957 516014 516308 526849 531849 533090 534100 535993 537837 555632 566274 567126 571941 585853 589058 611040 623290 623959 624939 625688 626362 627412 627772 630096 638904 648481 662146 666820 668084 679190 685540 693490 698719 703328 703480 707819 707840 710223 710364 714011 717817 720328 724074 724131 725156 725194 725253 726671 731259 731301 732622 735084 735898 736925 740002 740876 740929 743170 744775 747625 750362 751181 752405 759939 761030 762941 763503 764151 764865 765632 766821 766959 766971 767268 773384 778717 780763 782446 782604 783197 783567 783819 784337 785811 786012 788099 790080 794131 796131 796157 799354 800473 800549 800631 803721 804086 805277 807285 807370 809806 810037 813295 813805 813915 816201 823922 826030 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"in her ass"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"her жоп"
]
|
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.