Query Metrics
7
Database Queries
7
Different statements
202.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.27 ms (86.70%) |
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 386791 390569 412790 418871 419526 428421 433240 434440 439475 439698 439752 439774 443112 443884 446728 448375 448955 453566 454092 461998 463847 468702 472299 472305 474756 476152 478450 480037 491916 494437 496859 497516 500796 505024 514392 516478 535535 536431 544311 552623 553653 554886 558490 558883 558903 565288 565847 566065 567731 570130 576085 576538 583572 584068 591952 591977 592322 595467 598805 604479 605699 605766 609689 612419 619096 619482 620731 623175 625553 625960 631612 641677 671599 673983 680313 695603 698969 700855 701396 704261 720645 721955 725135 726129 726610 726838 727499 731772 731846 736219 739210 742875 756321 758118 758232 761056 761134 765463 766717 777491 778069 779750 782349 785811 788546 789468 789552 792176 792664 795551 796112 796945 797478 808152 810358 811646 813220 826127 826705 ] |
||||||||||||||||||||||||||||||
|
16.50 ms (8.16%) |
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 700855 619482 789468 792176 813220 704261 439475 620731 826705 826127 785811 731772 701396 808152 472299 671599 576538 595467 779750 782349 789552 739210 795551 731846 726129 742875 726610 736219 766717 721955 777491 796112 419526 453566 446728 468702 505024 792664 796945 725135 765463 788546 810358 758118 761134 727499 758232 761056 720645 412790 476152 454092 497516 535535 544311 553653 558883 566065 554886 565847 567731 558490 680313 583572 591977 605766 609689 439774 439698 439752 448375 448955 433240 461998 474756 516478 500796 552623 443112 570130 428421 463847 386791 443884 584068 811646 418871 390569 472305 494437 558903 565288 576085 605699 631612 619096 617608 625553 778069 797478 726838 756321 478450 514392 536431 491916 434440 480037 496859 695603 698969 673983 592322 598805 604479 612419 623175 641677 591952 625960 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (1.58%) |
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 386791 390569 412790 418871 419526 428421 433240 434440 439475 439698 439752 439774 443112 443884 446728 448375 448955 453566 454092 461998 463847 468702 472299 472305 474756 476152 478450 480037 491916 494437 496859 497516 500796 505024 514392 516478 535535 536431 544311 552623 553653 554886 558490 558883 558903 565288 565847 566065 567731 570130 576085 576538 583572 584068 591952 591977 592322 595467 598805 604479 605699 605766 609689 612419 619096 619482 620731 623175 625553 625960 631612 641677 671599 673983 680313 695603 698969 700855 701396 704261 720645 721955 725135 726129 726610 726838 727499 731772 731846 736219 739210 742875 756321 758118 758232 761056 761134 765463 766717 777491 778069 779750 782349 785811 788546 789468 789552 792176 792664 795551 796112 796945 797478 808152 810358 811646 813220 826127 826705 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"титьки анал"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ анал"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.