Query Metrics
7
Database Queries
7
Different statements
149.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.96 ms (86.28%) |
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 233234 240689 383448 383478 386939 400322 401517 412841 415047 415769 416417 426078 432374 432544 432706 433792 434109 441852 445841 451638 452703 453430 454460 456115 458188 463597 463996 468365 469173 483921 494165 495096 499549 500456 514826 515016 516486 517513 517720 526831 527157 528125 528228 529770 533076 534972 535885 540888 541735 544024 546033 552806 554998 555578 555784 559068 560957 563301 567720 568092 568181 577031 577262 579391 580541 590313 592244 592482 595105 600779 602043 605074 605384 610697 612131 618716 619269 623244 640514 640608 643317 668622 668712 675435 682974 693064 704594 709533 715632 719929 725440 731028 731057 735696 735902 740259 743946 746512 751506 757487 758176 770600 775315 776215 780835 783868 792390 792404 795735 796284 797067 797231 798844 811702 813414 814056 824450 826802 828480 828819 ] |
||||||||||||||||||||||||||||||
|
11.73 ms (7.85%) |
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 433792 826802 828819 526831 552806 415047 592244 528228 458188 495096 240689 775315 560957 540888 451638 529770 541735 546033 563301 568092 577262 668622 580541 811702 797067 797231 770600 731028 735696 725440 640608 719929 792390 798844 426078 415769 483921 514826 533076 494165 568181 469173 675435 468365 463996 605384 746512 743946 527157 528125 555784 554998 605074 828480 693064 432706 456115 600779 595105 386939 401517 412841 535885 682974 602043 592482 441852 383448 432544 824450 400322 534972 814056 668712 715632 590313 623244 640514 618716 619269 783868 780835 796284 792404 731057 740259 757487 751506 758176 735902 612131 704594 795735 813414 383478 416417 463597 577031 454460 516486 610697 709533 233234 643317 776215 453430 515016 517513 500456 555578 452703 499549 567720 579391 517720 559068 544024 432374 434109 445841 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.39%) |
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 233234 240689 383448 383478 386939 400322 401517 412841 415047 415769 416417 426078 432374 432544 432706 433792 434109 441852 445841 451638 452703 453430 454460 456115 458188 463597 463996 468365 469173 483921 494165 495096 499549 500456 514826 515016 516486 517513 517720 526831 527157 528125 528228 529770 533076 534972 535885 540888 541735 544024 546033 552806 554998 555578 555784 559068 560957 563301 567720 568092 568181 577031 577262 579391 580541 590313 592244 592482 595105 600779 602043 605074 605384 610697 612131 618716 619269 623244 640514 640608 643317 668622 668712 675435 682974 693064 704594 709533 715632 719929 725440 731028 731057 735696 735902 740259 743946 746512 751506 757487 758176 770600 775315 776215 780835 783868 792390 792404 795735 796284 797067 797231 798844 811702 813414 814056 824450 826802 828480 828819 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass panties"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.92%) |
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.