Query Metrics
7
Database Queries
7
Different statements
369.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.32 ms (57.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pissing девушк"
]
|
||||||||||||||||||||||||||||||
|
135.10 ms (36.60%) |
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 451865 534529 540061 541707 544234 545319 546793 548879 549023 550559 550560 550650 551037 552382 552602 552822 554191 554723 555189 555421 555450 558624 559020 560342 561025 562036 571094 573386 576509 576580 577543 579826 580129 581033 583536 584283 587532 589362 591221 595605 601684 601830 604660 615053 615616 627233 627946 629458 629649 633206 633823 634216 634810 636463 653513 665328 666734 670266 670402 671791 673039 675499 680172 680204 680499 691381 692714 696776 697555 700919 705700 707495 710471 712712 720421 721949 722966 728768 736022 736265 740268 741441 741862 741893 743380 743512 744280 748138 750308 751640 754209 757569 762173 762222 766348 767208 771623 775860 790370 797224 798877 799934 800504 801825 802315 802949 803450 803691 803700 804235 809925 811876 812279 812326 816168 817317 818377 826295 826971 827080 ] |
||||||||||||||||||||||||||||||
|
13.12 ms (3.55%) |
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 554191 581033 544234 707495 680204 580129 636463 812279 801825 812326 741893 757569 771623 750308 710471 541707 665328 670266 629649 736022 743512 817317 675499 653513 558624 790370 762222 740268 705700 816168 827080 534529 552382 583536 546793 554723 561025 551037 576509 692714 696776 666734 691381 545319 573386 589362 803700 799934 800504 803691 744280 751640 754209 629458 633823 634810 721949 804235 818377 577543 720421 673039 548879 584283 601684 587532 601830 633206 766348 741862 748138 762173 826971 826295 540061 560342 579826 550650 555421 555450 571094 555189 700919 615616 634216 627946 802949 775860 797224 802315 722966 809925 451865 559020 576580 549023 552822 562036 671791 680499 712712 680172 697555 670402 550559 550560 552602 591221 627233 604660 595605 615053 811876 803450 736265 767208 798877 741441 743380 728768 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (0.74%) |
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 451865 534529 540061 541707 544234 545319 546793 548879 549023 550559 550560 550650 551037 552382 552602 552822 554191 554723 555189 555421 555450 558624 559020 560342 561025 562036 571094 573386 576509 576580 577543 579826 580129 581033 583536 584283 587532 589362 591221 595605 601684 601830 604660 615053 615616 627233 627946 629458 629649 633206 633823 634216 634810 636463 653513 665328 666734 670266 670402 671791 673039 675499 680172 680204 680499 691381 692714 696776 697555 700919 705700 707495 710471 712712 720421 721949 722966 728768 736022 736265 740268 741441 741862 741893 743380 743512 744280 748138 750308 751640 754209 757569 762173 762222 766348 767208 771623 775860 790370 797224 798877 799934 800504 801825 802315 802949 803450 803691 803700 804235 809925 811876 812279 812326 816168 817317 818377 826295 826971 827080 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pissing girls"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pissing девушк"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.41%) |
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.