Query Metrics
7
Database Queries
7
Different statements
207.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.46 ms (89.37%) |
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 463420 500311 533913 534529 540107 540135 540139 540149 540159 542076 542182 542285 542439 544234 545319 545993 547414 550066 550559 550560 551037 551912 552382 552602 552604 553317 553674 554191 554714 554723 555216 555220 555281 555774 555776 558624 562048 571708 573386 574444 574452 576509 577543 580129 581033 583536 584283 588389 589337 589362 592576 593734 595605 598499 601684 605846 609998 610199 614675 615391 627233 629315 629649 630105 632887 633206 633823 637163 641778 650919 651903 652779 657777 664562 670266 670853 678662 696776 707495 710471 714374 721958 724317 724552 729287 732589 734364 736265 737438 743470 746021 747069 747137 750308 751640 752840 754209 757569 768157 771623 775212 784501 793671 794019 795979 797240 798273 799435 799934 801406 801825 803691 803700 803960 804235 808659 811366 812326 814318 816168 ] |
||||||||||||||||||||||||||||||
|
13.47 ms (6.49%) |
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 540139 534529 562048 583536 554191 554723 714374 664562 696776 721958 545319 547414 552604 555776 580129 632887 589362 592576 588389 747137 797240 771623 724552 746021 750308 747069 754209 633823 710471 804235 601684 794019 795979 798273 555281 571708 542439 542182 651903 652779 657777 670853 558624 598499 609998 629315 605846 615391 629649 816168 540159 540135 533913 551912 552382 574444 545993 581033 544234 550066 551037 553674 576509 707495 650919 678662 555220 573386 610199 775212 801825 803700 812326 799934 803691 803960 732589 743470 751640 757569 724317 752840 784501 801406 814318 463420 553317 670266 637163 633206 540107 540149 500311 554714 542076 542285 577543 555216 550559 550560 552602 555774 574452 584283 593734 641778 627233 589337 630105 595605 614675 811366 793671 799435 736265 737438 808659 729287 734364 768157 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.23%) |
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 463420 500311 533913 534529 540107 540135 540139 540149 540159 542076 542182 542285 542439 544234 545319 545993 547414 550066 550559 550560 551037 551912 552382 552602 552604 553317 553674 554191 554714 554723 555216 555220 555281 555774 555776 558624 562048 571708 573386 574444 574452 576509 577543 580129 581033 583536 584283 588389 589337 589362 592576 593734 595605 598499 601684 605846 609998 610199 614675 615391 627233 629315 629649 630105 632887 633206 633823 637163 641778 650919 651903 652779 657777 664562 670266 670853 678662 696776 707495 710471 714374 721958 724317 724552 729287 732589 734364 736265 737438 743470 746021 747069 747137 750308 751640 752840 754209 757569 768157 771623 775212 784501 793671 794019 795979 797240 798273 799435 799934 801406 801825 803691 803700 803960 804235 808659 811366 812326 814318 816168 ] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pissing любительск"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pissing amateur"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.66%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pissing любительск"
]
|
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.