Query Metrics
7
Database Queries
7
Different statements
177.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.43 ms (86.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 490025 519246 541764 542469 544260 546611 550333 556794 556842 558009 559122 560081 561615 563137 563156 563195 563200 563213 563426 563449 563530 565446 566170 566687 567396 567419 568306 570669 572748 572766 576636 576676 576693 576694 577355 577369 581350 581372 581390 583851 587813 588208 592395 592422 592451 592452 592515 592522 598058 599011 603161 603468 605325 609919 615167 615744 615748 615926 620147 620148 621683 622981 627746 628301 628310 629009 644285 644296 645233 648208 649153 650494 670097 670102 670103 670773 671730 671734 671740 672138 672144 672151 677706 683256 687116 690841 691496 691510 692198 692327 692428 694470 695246 697230 698423 698550 699567 699606 703436 703537 703553 706899 709052 715670 716409 716746 719873 720382 722208 727828 742971 748551 748695 750410 753257 789844 790394 790827 790986 801322 ] |
||||||||||||||||||||||||||||||
|
14.71 ms (8.30%) |
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 556842 563195 566170 567396 583851 542469 550333 559122 563156 563200 565446 566687 572766 544260 546611 556794 561615 570669 581372 581390 648208 649153 650494 670102 670773 672144 690841 691510 692198 692428 694470 703537 716409 720382 722208 645233 670097 672138 672151 677706 687116 691496 697230 699606 719873 670103 671730 671734 671740 683256 695246 698423 699567 703553 709052 563137 563213 563426 572748 588208 598058 609919 620147 628310 644285 592422 605325 587813 592395 592452 599011 603161 615167 615926 627746 592451 592515 592522 790986 790394 748551 750410 753257 789844 727828 742971 748695 603468 628301 629009 644296 698550 703436 706899 716746 790827 801322 490025 519246 581350 541764 560081 576693 577355 563449 567419 568306 558009 576676 576694 692327 715670 563530 577369 622981 621683 620148 615744 615748 576636 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.67%) |
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 490025 519246 541764 542469 544260 546611 550333 556794 556842 558009 559122 560081 561615 563137 563156 563195 563200 563213 563426 563449 563530 565446 566170 566687 567396 567419 568306 570669 572748 572766 576636 576676 576693 576694 577355 577369 581350 581372 581390 583851 587813 588208 592395 592422 592451 592452 592515 592522 598058 599011 603161 603468 605325 609919 615167 615744 615748 615926 620147 620148 621683 622981 627746 628301 628310 629009 644285 644296 645233 648208 649153 650494 670097 670102 670103 670773 671730 671734 671740 672138 672144 672151 677706 683256 687116 690841 691496 691510 692198 692327 692428 694470 695246 697230 698423 698550 699567 699606 703436 703537 703553 706899 709052 715670 716409 716746 719873 720382 722208 727828 742971 748551 748695 750410 753257 789844 790394 790827 790986 801322 ] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"retro pussy licking"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ретр pussy лиза"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ретр pussy лиза"
]
|
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.