Query Metrics
7
Database Queries
7
Different statements
146.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.88 ms (81.83%) |
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 88591 154972 187450 265692 382274 391926 391959 392015 392019 394630 429867 435512 435535 435551 449024 452940 454019 454517 455373 465143 466384 468142 469158 471701 473447 475769 476163 476186 479364 480662 480680 483523 490598 495040 500789 513633 513635 513639 513640 513672 516491 517332 517397 517539 517797 517799 517870 518214 519361 520904 520908 529988 530740 533694 533756 536323 538498 544108 547492 550456 554226 554997 555008 555009 555023 555040 555045 557490 557969 558315 559355 561034 561036 570936 573270 576545 580246 585498 586570 586914 591003 591013 592965 593042 593184 599236 601553 602782 605129 605709 606134 628698 642243 652881 660415 664559 669046 669057 670367 670372 671043 709746 752767 757860 766398 780653 781779 781920 796816 803396 804427 804435 804452 807723 809351 812229 816184 819238 824684 827394 ] |
||||||||||||||||||||||||||||||
|
17.00 ms (11.60%) |
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 601553 819238 454019 454517 544108 555009 669046 660415 602782 605129 599236 780653 796816 812229 804435 804452 391959 520908 520904 452940 529988 555008 555023 517797 469158 518214 382274 816184 824684 827394 533756 517539 533694 536323 530740 652881 592965 606134 642243 585498 593042 593184 781920 803396 807723 809351 757860 766398 709746 187450 265692 519361 468142 554226 555040 429867 154972 392019 88591 435512 435535 435551 449024 471701 473447 479364 538498 500789 466384 557969 573270 558315 580246 550456 557490 664559 555045 586570 605709 628698 752767 391926 392015 480680 455373 394630 475769 480662 465143 513633 495040 513639 513640 483523 517397 517799 476186 490598 476163 547492 559355 561034 561036 670367 671043 670372 669057 554997 570936 576545 586914 591003 591013 804427 781779 517332 517870 513635 513672 516491 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.81%) |
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 88591 154972 187450 265692 382274 391926 391959 392015 392019 394630 429867 435512 435535 435551 449024 452940 454019 454517 455373 465143 466384 468142 469158 471701 473447 475769 476163 476186 479364 480662 480680 483523 490598 495040 500789 513633 513635 513639 513640 513672 516491 517332 517397 517539 517797 517799 517870 518214 519361 520904 520908 529988 530740 533694 533756 536323 538498 544108 547492 550456 554226 554997 555008 555009 555023 555040 555045 557490 557969 558315 559355 561034 561036 570936 573270 576545 580246 585498 586570 586914 591003 591013 592965 593042 593184 599236 601553 602782 605129 605709 606134 628698 642243 652881 660415 664559 669046 669057 670367 670372 671043 709746 752767 757860 766398 780653 781779 781920 796816 803396 804427 804435 804452 807723 809351 812229 816184 819238 824684 827394 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature brunette solo"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature черноволосая соло"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature черноволосая соло"
]
|
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.