Query Metrics
7
Database Queries
7
Different statements
177.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.59 ms (87.01%) |
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 213316 339474 386057 387258 389258 401369 420441 425719 435720 443333 448692 456955 461744 465475 471162 475477 479857 484804 485010 490577 496314 505797 510988 513184 519755 524859 533575 533795 533975 533979 535877 537799 538538 542582 542618 542623 550405 575411 576975 585439 586429 587259 589260 589976 593466 596690 598402 611547 613452 621632 629641 630382 630985 647406 648284 651011 677510 693946 693950 700845 700892 703942 710321 716157 716346 716405 720018 723357 726193 727155 737330 737573 737653 737657 737719 737726 738147 738390 738396 738430 738573 738585 738671 738718 739055 739611 741045 741617 745014 747605 747916 748004 748393 748413 757324 757534 758604 766572 776843 780939 784460 784492 784508 788254 788488 789106 792627 811049 814941 815351 815502 815960 816243 816510 820500 826119 826502 826710 ] |
||||||||||||||||||||||||||||||
|
14.35 ms (8.08%) |
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 726193 727155 788488 741045 213316 435720 815351 471162 448692 484804 465475 490577 542582 575411 598402 766572 479857 737653 386057 820500 475477 533795 533975 519755 535877 533979 537799 542618 647406 720018 700845 700892 648284 710321 629641 621632 585439 587259 596690 630382 589976 780939 784460 784508 737330 738147 741617 748004 784492 739055 738390 745014 747916 748413 758604 737657 738396 738430 738718 703942 387258 815960 505797 737726 792627 716157 420441 496314 826119 814941 816243 593466 737573 739611 811049 747605 748393 738671 757324 542623 757534 456955 524859 401369 461744 576975 630985 443333 716405 550405 737719 613452 425719 510988 586429 339474 826502 826710 538538 651011 667269 693946 666827 716346 723357 788254 738573 738585 485010 776843 389258 815502 816510 533575 513184 677510 693950 589260 611547 789106 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.45%) |
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 213316 339474 386057 387258 389258 401369 420441 425719 435720 443333 448692 456955 461744 465475 471162 475477 479857 484804 485010 490577 496314 505797 510988 513184 519755 524859 533575 533795 533975 533979 535877 537799 538538 542582 542618 542623 550405 575411 576975 585439 586429 587259 589260 589976 593466 596690 598402 611547 613452 621632 629641 630382 630985 647406 648284 651011 677510 693946 693950 700845 700892 703942 710321 716157 716346 716405 720018 723357 726193 727155 737330 737573 737653 737657 737719 737726 738147 738390 738396 738430 738573 738585 738671 738718 739055 739611 741045 741617 745014 747605 747916 748004 748393 748413 757324 757534 758604 766572 776843 780939 784460 784492 784508 788254 788488 789106 792627 811049 814941 815351 815502 815960 816243 816510 820500 826119 826502 826710 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ebony big cock"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чернокожая большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.29 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"чернокожая большие cock"
]
|
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.