Query Metrics
7
Database Queries
7
Different statements
172.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.26 ms (85.90%) |
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 31134 32549 385172 385313 387263 390493 397068 398212 408578 409882 446790 453124 454557 454877 456158 457656 459329 460952 461422 469360 472279 474078 476155 479690 483675 483906 487328 487790 489340 490437 492622 497127 499849 501527 506848 514064 516076 519142 524909 527333 529458 533165 533390 544552 551664 556141 557025 557607 563112 576237 576771 585240 587769 589691 598087 609073 610939 612339 612622 614832 615964 624791 627232 627348 629833 640448 642126 648017 648273 650723 665456 668007 670952 677360 682404 687857 690515 691291 691578 701059 703709 703772 703783 707504 709298 710570 713063 713115 714361 714407 714496 715349 717144 719095 719121 719150 720344 722470 722532 725582 728953 729050 729051 729759 732048 734205 734320 739895 740666 745294 746055 768725 794284 794644 796726 800953 803741 810259 810306 825253 ] |
||||||||||||||||||||||||||||||
|
13.68 ms (7.93%) |
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 390493 385313 385172 387263 459329 479690 483675 514064 497127 519142 472279 557025 682404 691578 720344 690515 713115 810306 710570 717144 397068 490437 551664 576237 557607 650723 701059 707504 713063 715349 648273 648017 668007 703772 609073 612622 589691 610939 624791 627232 640448 729051 734205 734320 729050 739895 725582 728953 740666 745294 746055 703709 703783 714361 714407 719095 719121 732048 499849 825253 533390 446790 598087 585240 32549 409882 469360 492622 454877 483906 457656 489340 501527 506848 524909 527333 533165 461422 670952 677360 612339 642126 614832 615964 474078 398212 408578 476155 516076 31134 454557 460952 544552 714496 722470 722532 665456 687857 691291 587769 627348 800953 796726 768725 719150 794644 487328 453124 456158 487790 529458 556141 563112 576771 629833 803741 810259 729759 794284 709298 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.66%) |
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 31134 32549 385172 385313 387263 390493 397068 398212 408578 409882 446790 453124 454557 454877 456158 457656 459329 460952 461422 469360 472279 474078 476155 479690 483675 483906 487328 487790 489340 490437 492622 497127 499849 501527 506848 514064 516076 519142 524909 527333 529458 533165 533390 544552 551664 556141 557025 557607 563112 576237 576771 585240 587769 589691 598087 609073 610939 612339 612622 614832 615964 624791 627232 627348 629833 640448 642126 648017 648273 650723 665456 668007 670952 677360 682404 687857 690515 691291 691578 701059 703709 703772 703783 707504 709298 710570 713063 713115 714361 714407 714496 715349 717144 719095 719121 719150 720344 722470 722532 725582 728953 729050 729051 729759 732048 734205 734320 739895 740666 745294 746055 768725 794284 794644 796726 800953 803741 810259 810306 825253 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"член волосатая"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dick hairy"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.04%) |
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.