Query Metrics
7
Database Queries
7
Different statements
153.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.30 ms (83.51%) |
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 383775 390592 409921 417454 419677 421206 428681 430392 433998 436440 442658 447447 454529 457979 458125 469575 474078 474379 475911 477254 482081 483952 487189 487724 497964 513779 540183 541919 542144 544471 547814 547823 548660 548694 549292 552650 553563 553722 554540 555788 556324 557742 558024 558421 558573 558619 558839 559501 560209 561825 562291 563801 564597 565481 569850 569878 570418 570643 572107 572134 572436 572519 573379 573558 573685 573698 573874 574843 575112 575132 575816 576025 576041 576098 576732 577365 578420 578472 581301 584540 584974 585133 585249 588204 592844 595441 598621 598680 598812 603103 605683 607289 613155 622188 627804 653287 655348 659116 672744 675790 679037 679702 718581 719146 721310 721381 722542 728902 735995 743116 745075 750560 759548 770489 777079 780673 811184 817662 821631 827974 ] |
||||||||||||||||||||||||||||||
|
15.04 ms (9.79%) |
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 562291 588204 750560 770489 421206 409921 513779 622188 442658 475911 433998 487189 569850 570643 743116 745075 817662 675790 547823 383775 564597 575112 576025 576041 578472 430392 548660 563801 575816 572107 573698 558573 653287 655348 553563 573874 574843 576732 584974 598621 558421 558619 569878 542144 553722 722542 554540 572436 573685 598812 613155 390592 577365 547814 584540 541919 560209 565481 598680 627804 555788 457979 419677 428681 469575 595441 482081 483952 474078 447447 417454 672744 573379 585249 605683 436440 477254 458125 497964 548694 474379 487724 679037 721310 607289 777079 728902 759548 718581 721381 454529 581301 603103 544471 821631 827974 540183 659116 719146 549292 780673 735995 811184 585133 558024 559501 575132 576098 572134 578420 558839 570418 572519 573558 679702 552650 556324 557742 561825 592844 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.92%) |
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 383775 390592 409921 417454 419677 421206 428681 430392 433998 436440 442658 447447 454529 457979 458125 469575 474078 474379 475911 477254 482081 483952 487189 487724 497964 513779 540183 541919 542144 544471 547814 547823 548660 548694 549292 552650 553563 553722 554540 555788 556324 557742 558024 558421 558573 558619 558839 559501 560209 561825 562291 563801 564597 565481 569850 569878 570418 570643 572107 572134 572436 572519 573379 573558 573685 573698 573874 574843 575112 575132 575816 576025 576041 576098 576732 577365 578420 578472 581301 584540 584974 585133 585249 588204 592844 595441 598621 598680 598812 603103 605683 607289 613155 622188 627804 653287 655348 659116 672744 675790 679037 679702 718581 719146 721310 721381 722542 728902 735995 743116 745075 750560 759548 770489 777079 780673 811184 817662 821631 827974 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"лижет маленькую киску…"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза маленькая вагин"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лиза маленькая вагин"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.08%) |
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.