Query Metrics
7
Database Queries
7
Different statements
170.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.47 ms (84.86%) |
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 14382 117513 342450 382330 390147 390413 395145 395407 396528 396564 398204 400965 403726 404240 407654 413225 414448 416200 416931 418952 419751 420207 421537 432813 449011 451552 451724 467163 475703 482800 484954 485325 489083 494617 494690 495269 495270 515902 519184 526188 529732 530494 531090 531440 531614 539192 539424 543872 543877 544784 547366 550093 554472 556369 556415 560152 564184 565096 566810 573477 579358 583976 597870 605022 606864 609682 614430 615812 627805 628085 630612 641543 667278 671353 688041 702164 712337 721617 726476 726479 726492 726493 726498 726515 726557 726572 726599 726681 726786 727410 729911 730406 733012 737123 738070 740824 742892 742894 742970 750774 750852 755222 757355 807769 808002 808047 810765 811663 814147 816233 817048 821605 823388 823558 823593 824178 824345 824900 825001 825155 ] |
||||||||||||||||||||||||||||||
|
17.07 ms (10.03%) |
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 609682 614430 615812 627805 630612 810765 729911 757355 628085 413225 382330 390413 418952 451552 475703 485325 489083 494690 495269 495270 824178 817048 823593 825155 824900 451724 529732 531614 564184 606864 641543 597870 605022 808002 807769 726786 726476 726479 726492 726557 726599 727410 733012 750774 738070 742892 755222 726493 726681 712337 117513 494617 414448 432813 449011 14382 404240 395145 342450 396528 398204 407654 416931 814147 823388 816233 823558 824345 556369 667278 671353 811663 730406 740824 742894 726515 726572 737123 750852 726498 742970 808047 403726 395407 390147 396564 400965 416200 419751 421537 420207 825001 821605 482800 484954 515902 519184 526188 530494 531090 539424 531440 539192 467163 547366 550093 573477 554472 579358 543872 543877 544784 560152 583976 721617 702164 688041 556415 565096 566810 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young interracial"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.21%) |
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 14382 117513 342450 382330 390147 390413 395145 395407 396528 396564 398204 400965 403726 404240 407654 413225 414448 416200 416931 418952 419751 420207 421537 432813 449011 451552 451724 467163 475703 482800 484954 485325 489083 494617 494690 495269 495270 515902 519184 526188 529732 530494 531090 531440 531614 539192 539424 543872 543877 544784 547366 550093 554472 556369 556415 560152 564184 565096 566810 573477 579358 583976 597870 605022 606864 609682 614430 615812 627805 628085 630612 641543 667278 671353 688041 702164 712337 721617 726476 726479 726492 726493 726498 726515 726557 726572 726599 726681 726786 727410 729911 730406 733012 737123 738070 740824 742892 742894 742970 750774 750852 755222 757355 807769 808002 808047 810765 811663 814147 816233 817048 821605 823388 823558 823593 824178 824345 824900 825001 825155 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young межрасов"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.18 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young межрасов"
]
|
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.