Query Metrics
7
Database Queries
7
Different statements
183.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.25 ms (85.80%) |
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 399023 443206 461645 525558 543203 551250 551431 552627 556033 556389 558033 558849 559145 559195 559197 560184 560853 561833 563278 563874 564172 564604 565265 566962 567379 568579 568601 569784 569908 570059 570061 570062 571686 572166 573065 574504 574912 575473 575736 576058 577320 577396 578409 578459 579279 579365 581564 581660 581687 581704 584537 585942 589786 591441 596669 597599 598696 603154 604227 614430 617216 618870 620305 620791 621647 622397 633114 639864 645845 655366 656575 656728 657363 663854 664296 664539 666113 668377 671340 675373 683917 684541 685655 686054 690126 693023 693039 693077 696991 702892 702977 704571 708457 710957 714473 715719 716027 717892 720009 720800 720825 729743 730859 735594 735844 740821 742186 743196 755780 786036 798971 814069 817022 817816 819698 821178 821578 822167 822718 827610 ] |
||||||||||||||||||||||||||||||
|
16.23 ms (8.85%) |
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 575736 578459 584537 570061 577396 581660 621647 603154 597599 614430 622397 633114 817816 817022 819698 821178 821578 822167 822718 543203 556033 655366 664539 671340 685655 686054 693039 702977 704571 708457 645845 702892 710957 717892 656728 664296 683917 690126 720009 620305 618870 639864 620791 786036 798971 743196 735844 742186 755780 729743 730859 735594 740821 696991 399023 568579 443206 827610 814069 461645 525558 551250 551431 558849 559195 559197 560853 561833 567379 568601 574912 579365 581564 581704 552627 556389 559145 563278 569784 570059 572166 576058 578409 558033 565265 566962 569908 581687 675373 715719 656575 684541 693023 720800 657363 663854 666113 668377 693077 714473 716027 720825 560184 563874 564172 564604 570062 571686 573065 574504 575473 577320 579279 585942 589786 591441 596669 598696 604227 617216 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.52%) |
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 399023 443206 461645 525558 543203 551250 551431 552627 556033 556389 558033 558849 559145 559195 559197 560184 560853 561833 563278 563874 564172 564604 565265 566962 567379 568579 568601 569784 569908 570059 570061 570062 571686 572166 573065 574504 574912 575473 575736 576058 577320 577396 578409 578459 579279 579365 581564 581660 581687 581704 584537 585942 589786 591441 596669 597599 598696 603154 604227 614430 617216 618870 620305 620791 621647 622397 633114 639864 645845 655366 656575 656728 657363 663854 664296 664539 666113 668377 671340 675373 683917 684541 685655 686054 690126 693023 693039 693077 696991 702892 702977 704571 708457 710957 714473 715719 716027 717892 720009 720800 720825 729743 730859 735594 735844 740821 742186 743196 755780 786036 798971 814069 817022 817816 819698 821178 821578 822167 822718 827610 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young small cock"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young маленькая cock"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young маленькая cock"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.88%) |
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.