Query Metrics
7
Database Queries
7
Different statements
182.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.59 ms (88.48%) |
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 358259 392068 392095 411386 419599 421862 423823 424197 424434 426536 428527 436948 439480 439764 440222 444156 444838 446762 454552 455130 455201 455996 456078 456536 457459 457686 457852 457853 460627 460835 460922 461970 462005 463334 466559 466587 469402 470592 470647 470715 474794 477554 478414 479821 482872 485273 490945 494564 495223 496756 500026 502718 517711 519746 526792 527870 532060 540696 544526 555057 562967 564111 567403 567683 578348 581989 592422 605157 606619 609723 613432 624895 630246 633340 666374 675419 710510 712547 712564 713652 722160 725206 726352 726926 728662 731254 733251 754235 756683 757052 758003 763547 766612 766767 768290 778010 779534 780799 788942 788944 789152 790228 791356 795737 796001 797097 797334 797783 799847 800529 801205 801426 802201 802870 805692 807352 809654 809876 826241 827325 ] |
||||||||||||||||||||||||||||||
|
12.37 ms (6.77%) |
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 526792 562967 474794 807352 609723 606619 799847 789152 754235 801426 666374 527870 502718 578348 469402 555057 763547 731254 436948 462005 675419 411386 809876 358259 460835 809654 440222 392068 460627 797334 797783 454552 485273 457852 517711 768290 423823 791356 766767 780799 495223 788944 779534 802201 805692 544526 439480 456078 446762 500026 567403 439764 712564 444156 827325 722160 726926 788942 800529 756683 426536 457686 455130 456536 470647 567683 494564 457459 713652 613432 795737 482872 540696 455201 624895 801205 766612 461970 633340 424434 581989 605157 421862 490945 419599 564111 470715 466559 470592 496756 630246 726352 460922 826241 802870 466587 728662 797097 455996 392095 796001 710510 733251 592422 477554 725206 479821 757052 444838 428527 463334 532060 778010 519746 457853 478414 424197 758003 790228 712547 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.42%) |
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 358259 392068 392095 411386 419599 421862 423823 424197 424434 426536 428527 436948 439480 439764 440222 444156 444838 446762 454552 455130 455201 455996 456078 456536 457459 457686 457852 457853 460627 460835 460922 461970 462005 463334 466559 466587 469402 470592 470647 470715 474794 477554 478414 479821 482872 485273 490945 494564 495223 496756 500026 502718 517711 519746 526792 527870 532060 540696 544526 555057 562967 564111 567403 567683 578348 581989 592422 605157 606619 609723 613432 624895 630246 633340 666374 675419 710510 712547 712564 713652 722160 725206 726352 726926 728662 731254 733251 754235 756683 757052 758003 763547 766612 766767 768290 778010 779534 780799 788942 788944 789152 790228 791356 795737 796001 797097 797334 797783 799847 800529 801205 801426 802201 802870 805692 807352 809654 809876 826241 827325 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"домашнее миньет мамкÐ%…"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск минет оральн секс мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.28 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.