Query Metrics
7
Database Queries
7
Different statements
395.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.29 ms (52.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature черноволосая глубокийминет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
159.95 ms (40.40%) |
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 16851 389023 392538 395846 400960 401742 402670 404279 404464 405074 405178 405538 406030 406289 406705 409641 411344 412886 413505 418478 419979 421848 421907 422725 426540 432799 433473 433494 434763 439657 443150 445748 448831 451926 451957 452039 452136 459457 460079 462915 462926 463768 467936 468011 469766 470662 471434 472831 472906 473434 477136 478414 478587 480504 483571 486809 495561 501488 504123 508295 517049 517873 518582 518949 520682 520688 521723 528682 530020 531134 531144 531212 531238 534647 535460 537932 539282 540511 543286 543849 549173 562770 565154 568378 571035 571155 573911 576719 579379 584498 584602 586326 594827 601316 604550 604580 605590 617424 630553 630870 638532 642742 647935 647950 660422 677703 687577 756406 788789 797831 801258 801292 801968 802379 808570 814392 814901 814939 815648 818156 ] |
||||||||||||||||||||||||||||||
|
18.79 ms (4.74%) |
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 594827 801968 451957 540511 405178 409641 467936 473434 468011 534647 531134 537932 647950 660422 677703 562770 605590 802379 788789 478414 406705 392538 406030 419979 434763 531238 508295 543286 584498 687577 586326 601316 642742 801258 756406 401742 445748 443150 531144 630553 501488 520682 389023 404464 412886 459457 472906 504123 531212 539282 517873 495561 579379 647935 801292 477136 404279 405538 478587 568378 433494 486809 573911 630870 797831 808570 16851 535460 406289 452136 469766 528682 405074 530020 584602 421907 451926 413505 518582 565154 480504 402670 520688 418478 617424 400960 432799 471434 571155 576719 421848 814901 543849 411344 549173 452039 472831 462915 422725 518949 463768 483571 571035 395846 460079 462926 433473 517049 521723 470662 448831 439657 638532 604580 814392 815648 818156 604550 426540 814939 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (0.71%) |
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 16851 389023 392538 395846 400960 401742 402670 404279 404464 405074 405178 405538 406030 406289 406705 409641 411344 412886 413505 418478 419979 421848 421907 422725 426540 432799 433473 433494 434763 439657 443150 445748 448831 451926 451957 452039 452136 459457 460079 462915 462926 463768 467936 468011 469766 470662 471434 472831 472906 473434 477136 478414 478587 480504 483571 486809 495561 501488 504123 508295 517049 517873 518582 518949 520682 520688 521723 528682 530020 531134 531144 531212 531238 534647 535460 537932 539282 540511 543286 543849 549173 562770 565154 568378 571035 571155 573911 576719 579379 584498 584602 586326 594827 601316 604550 604580 605590 617424 630553 630870 638532 642742 647935 647950 660422 677703 687577 756406 788789 797831 801258 801292 801968 802379 808570 814392 814901 814939 815648 818156 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature brunette deepthroat"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature черноволосая глубокийминет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.39%) |
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.