Query Metrics
7
Database Queries
7
Different statements
142.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.57 ms (84.05%) |
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 53698 72499 393072 393848 394167 399074 399164 403789 409274 413735 435215 438109 438401 446191 447574 447632 449986 457301 464144 474982 481941 501708 512936 519160 531374 531971 536815 537386 539583 539802 540539 542840 542990 545744 547048 548399 548408 552985 554978 556109 560181 562502 566636 567940 582472 593820 596450 599385 601634 605700 606055 609194 610830 612388 612447 621727 624503 626226 626649 629957 632232 649367 650301 654180 664610 664731 697676 719928 726075 726809 727500 728116 737987 758267 762560 764972 765776 768182 771963 772059 772146 773225 773682 780708 781156 783462 783487 783508 787765 789314 789912 793878 794289 795027 795063 795568 795818 796458 797363 798571 800443 801939 802564 804574 806081 807398 809824 810277 811483 811693 812882 818401 818510 819324 823878 828008 828115 828443 828574 828810 ] |
||||||||||||||||||||||||||||||
|
12.69 ms (8.92%) |
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 818510 819324 823878 828810 828008 828443 539802 542990 545744 582472 548399 552985 664610 664731 697676 719928 650301 654180 606055 612388 624503 632232 781156 795063 795818 797363 780708 783508 789912 812882 762560 772059 772146 789314 794289 795027 796458 809824 726809 727500 771963 758267 768182 773225 728116 765776 726075 764972 773682 605700 609194 795568 596450 394167 409274 449986 457301 531971 519160 610830 399164 474982 393848 72499 53698 447632 560181 393072 413735 435215 438109 818401 828115 828574 542840 547048 801939 804574 802564 539583 531374 536815 537386 554978 562502 567940 548408 556109 649367 593820 626226 626649 621727 629957 807398 783462 737987 783487 800443 810277 811693 793878 798571 806081 811483 446191 403789 512936 501708 540539 566636 599385 601634 612447 787765 399074 438401 447574 481941 464144 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (2.11%) |
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 53698 72499 393072 393848 394167 399074 399164 403789 409274 413735 435215 438109 438401 446191 447574 447632 449986 457301 464144 474982 481941 501708 512936 519160 531374 531971 536815 537386 539583 539802 540539 542840 542990 545744 547048 548399 548408 552985 554978 556109 560181 562502 566636 567940 582472 593820 596450 599385 601634 605700 606055 609194 610830 612388 612447 621727 624503 626226 626649 629957 632232 649367 650301 654180 664610 664731 697676 719928 726075 726809 727500 728116 737987 758267 762560 764972 765776 768182 771963 772059 772146 773225 773682 780708 781156 783462 783487 783508 787765 789314 789912 793878 794289 795027 795063 795568 795818 796458 797363 798571 800443 801939 802564 804574 806081 807398 809824 810277 811483 811693 812882 818401 818510 819324 823878 828008 828115 828443 828574 828810 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits pov"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ пов"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.11%) |
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.