Query Metrics
7
Database Queries
7
Different statements
148.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.81 ms (83.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 184943 188462 352187 366448 387374 389726 391985 394700 399408 406071 411336 421343 422484 428502 434070 434133 434167 443408 443628 444776 445560 450251 450854 452287 452295 457263 457993 459255 466898 477514 496454 497859 502033 505496 509540 510425 525355 525513 526226 527258 546617 547445 554350 555202 555205 555210 555248 555256 555271 555761 556529 558316 560692 578780 586201 586950 591013 591997 592945 592975 596041 607345 607626 607765 609071 610166 614254 626027 626772 628295 628673 666951 668678 683903 684235 687608 691821 696587 705966 712569 714934 715724 716393 719139 726749 731482 732934 733282 736041 736339 739400 742265 748102 756252 757176 758919 760054 761271 768792 772355 773390 775649 787756 788632 788651 788848 801197 812469 815822 818252 819612 819615 819988 823600 823860 824125 824630 825044 825447 827634 ] |
||||||||||||||||||||||||||||||
|
14.54 ms (9.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 591013 592975 586950 607345 586201 592945 787756 756252 758919 610166 715724 788848 188462 411336 428502 434167 421343 457263 443628 525355 527258 497859 509540 502033 607626 733282 422484 450854 452287 457993 719139 466898 406071 558316 510425 596041 387374 505496 556529 736339 731482 352187 824630 823860 825447 547445 555256 554350 555202 555205 555210 555761 668678 691821 555271 614254 626027 628673 607765 812469 801197 739400 760054 768792 788651 726749 773390 736041 757176 391985 815822 818252 819988 823600 819615 824125 819612 827634 546617 555248 716393 696587 683903 684235 705966 712569 714934 628295 626772 772355 748102 732934 775649 366448 399408 434070 444776 445560 450251 459255 496454 609071 443408 389726 434133 452295 525513 526226 591997 394700 825044 560692 578780 477514 184943 666951 687608 742265 761271 788632 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.61%) |
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 184943 188462 352187 366448 387374 389726 391985 394700 399408 406071 411336 421343 422484 428502 434070 434133 434167 443408 443628 444776 445560 450251 450854 452287 452295 457263 457993 459255 466898 477514 496454 497859 502033 505496 509540 510425 525355 525513 526226 527258 546617 547445 554350 555202 555205 555210 555248 555256 555271 555761 556529 558316 560692 578780 586201 586950 591013 591997 592945 592975 596041 607345 607626 607765 609071 610166 614254 626027 626772 628295 628673 666951 668678 683903 684235 687608 691821 696587 705966 712569 714934 715724 716393 719139 726749 731482 732934 733282 736041 736339 739400 742265 748102 756252 757176 758919 760054 761271 768792 772355 773390 775649 787756 788632 788651 788848 801197 812469 815822 818252 819612 819615 819988 823600 823860 824125 824630 825044 825447 827634 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy big ass"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.09%) |
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.