Query Metrics
7
Database Queries
7
Different statements
225.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
199.37 ms (88.53%) |
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 396522 400689 412618 412733 420594 425554 426560 428364 435866 437385 438023 443048 444672 448345 451420 453537 457658 457678 458163 459060 463142 467646 468855 470809 481773 483353 483430 485414 490698 494590 496495 496497 497493 499346 499717 503099 503447 503448 503449 503474 504053 504054 513171 514489 516110 516168 517378 518760 519121 519394 519431 520523 522236 522449 524352 525438 525882 526930 528331 528779 542090 542407 542925 543351 546894 546926 547880 549174 549499 549593 553261 553332 557230 557377 557420 557465 563718 565961 570142 571074 571835 572194 572931 572972 577680 581748 582003 585163 585708 586728 587867 592662 593247 595035 598361 600488 603010 612828 615622 619127 619878 648874 650134 658217 658225 709854 715344 730307 735867 736457 746736 758847 762232 765907 772144 788373 801272 802188 802815 811906 ] |
||||||||||||||||||||||||||||||
|
12.91 ms (5.73%) |
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 746736 451420 458163 481773 503099 494590 581748 572931 587867 612828 762232 490698 516110 525438 526930 426560 457658 470809 524352 499346 522449 528331 503449 528779 546894 549499 553261 658217 650134 658225 563718 619127 619878 802815 772144 735867 758847 765907 788373 428364 504054 516168 518760 519431 517378 438023 412733 459060 503447 513171 496497 463142 549174 557230 715344 595035 802188 811906 736457 730307 444672 457678 468855 467646 396522 420594 497493 522236 483353 499717 503474 519394 801272 577680 585708 503448 437385 519121 483430 496495 485414 572972 582003 553332 542925 571835 648874 546926 571074 615622 592662 593247 525882 572194 600488 443048 448345 542090 542407 543351 547880 557420 570142 549593 557377 565961 557465 585163 586728 598361 603010 709854 400689 412618 425554 435866 453537 514489 520523 504053 ] |
||||||||||||||||||||||||||||||
|
5.05 ms (2.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stepdaughter amateur"
]
|
||||||||||||||||||||||||||||||
|
2.75 ms (1.22%) |
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 396522 400689 412618 412733 420594 425554 426560 428364 435866 437385 438023 443048 444672 448345 451420 453537 457658 457678 458163 459060 463142 467646 468855 470809 481773 483353 483430 485414 490698 494590 496495 496497 497493 499346 499717 503099 503447 503448 503449 503474 504053 504054 513171 514489 516110 516168 517378 518760 519121 519394 519431 520523 522236 522449 524352 525438 525882 526930 528331 528779 542090 542407 542925 543351 546894 546926 547880 549174 549499 549593 553261 553332 557230 557377 557420 557465 563718 565961 570142 571074 571835 572194 572931 572972 577680 581748 582003 585163 585708 586728 587867 592662 593247 595035 598361 600488 603010 612828 615622 619127 619878 648874 650134 658217 658225 709854 715344 730307 735867 736457 746736 758847 762232 765907 772144 788373 801272 802188 802815 811906 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"stepdaughter любительск"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"stepdaughter любительск"
]
|
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.