Query Metrics
7
Database Queries
7
Different statements
177.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.65 ms (85.55%) |
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 393453 397075 398670 402195 403808 409075 412434 422434 424757 436642 437104 437724 441284 444038 447792 449321 451676 461773 494662 499439 503825 505520 517532 533649 533699 536084 538420 544186 550792 552726 555693 556131 557681 566019 566239 570225 570371 570435 571745 572501 575118 575847 576558 586542 588051 588541 594297 594632 595424 597714 598672 599903 600497 601897 602813 611435 612476 613774 617142 621116 621183 622510 624144 627155 627768 628957 630313 631742 702629 702636 715235 716829 724833 724916 727890 728793 731397 731562 733367 734293 736361 737287 740675 741167 743034 744097 744242 746137 747298 748682 749918 751189 752985 755048 758861 762112 764799 766333 778141 779089 779687 779722 783194 783232 783612 785274 786421 790839 792158 793205 793680 801453 805193 807662 808900 810548 810919 811349 812191 812348 ] |
||||||||||||||||||||||||||||||
|
15.40 ms (8.69%) |
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 715235 716829 557681 572501 576558 586542 588051 599903 611435 613774 628957 595424 597714 598672 588541 594632 601897 612476 621183 622510 624144 630313 631742 594297 600497 602813 617142 621116 627155 627768 779722 783612 801453 810548 783232 790839 793680 808900 811349 728793 733367 740675 743034 748682 751189 752985 755048 758861 783194 793205 805193 810919 812348 724833 727890 731397 734293 741167 744242 749918 762112 764799 746137 737287 744097 747298 724916 731562 736361 766333 702629 702636 778141 779089 779687 785274 786421 792158 807662 812191 412434 444038 422434 461773 393453 397075 398670 402195 403808 436642 437724 424757 441284 409075 437104 449321 447792 451676 505520 533649 533699 536084 494662 503825 499439 517532 538420 544186 552726 566019 570225 570371 570435 571745 575118 555693 556131 566239 575847 550792 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.77%) |
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 393453 397075 398670 402195 403808 409075 412434 422434 424757 436642 437104 437724 441284 444038 447792 449321 451676 461773 494662 499439 503825 505520 517532 533649 533699 536084 538420 544186 550792 552726 555693 556131 557681 566019 566239 570225 570371 570435 571745 572501 575118 575847 576558 586542 588051 588541 594297 594632 595424 597714 598672 599903 600497 601897 602813 611435 612476 613774 617142 621116 621183 622510 624144 627155 627768 628957 630313 631742 702629 702636 715235 716829 724833 724916 727890 728793 731397 731562 733367 734293 736361 737287 740675 741167 743034 744097 744242 746137 747298 748682 749918 751189 752985 755048 758861 762112 764799 766333 778141 779089 779687 779722 783194 783232 783612 785274 786421 790839 792158 793205 793680 801453 805193 807662 808900 810548 810919 811349 812191 812348 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny cum in"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые cum"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые cum"
]
|
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.