Query Metrics
7
Database Queries
7
Different statements
165.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.08 ms (81.00%) |
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 12405 107874 243071 343398 381748 385125 387304 389789 392527 416875 416933 417530 417955 418724 419353 421653 422500 423247 423498 424549 426467 426632 426635 426805 426911 427172 429278 430585 431513 431682 433883 452995 453801 456212 456363 456710 456726 463026 465971 466956 470087 479345 484023 484464 487768 487982 491178 491365 491611 492155 499042 500494 504740 507441 508989 515884 516452 521287 522412 524717 526314 527717 527769 530470 532694 532912 533019 534742 534853 535585 536012 537758 537806 538891 539101 540317 540357 541102 541597 544783 544910 547058 550062 550067 550071 550557 559198 563876 565246 565842 568478 569725 572011 578002 590876 600402 603999 620244 622731 623842 629007 630801 638052 648524 653520 665649 689483 689964 699480 709306 720422 747195 747228 764485 775587 784735 814697 817073 817182 824051 ] |
||||||||||||||||||||||||||||||
|
19.53 ms (11.80%) |
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 465971 456726 418724 107874 392527 381748 12405 430585 824051 817073 817182 814697 537758 487982 466956 527769 530470 540357 515884 532694 533019 526314 534742 499042 500494 507441 534853 537806 491178 550071 578002 541102 550557 665649 689964 648524 689483 569725 629007 775587 764485 638052 699480 709306 426632 385125 487768 527717 565246 539101 484023 550067 429278 603999 630801 479345 522412 470087 559198 565842 491365 343398 389789 387304 419353 426635 423498 421653 424549 416933 431682 452995 456710 456363 492155 535585 536012 538891 516452 544783 568478 541597 550062 547058 720422 622731 784735 431513 426911 427172 521287 422500 590876 747195 747228 453801 600402 623842 463026 417955 524717 508989 416875 532912 620244 426805 243071 426467 484464 540317 544910 563876 433883 491611 504740 653520 572011 417530 423247 456212 ] |
||||||||||||||||||||||||||||||
|
4.22 ms (2.55%) |
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 12405 107874 243071 343398 381748 385125 387304 389789 392527 416875 416933 417530 417955 418724 419353 421653 422500 423247 423498 424549 426467 426632 426635 426805 426911 427172 429278 430585 431513 431682 433883 452995 453801 456212 456363 456710 456726 463026 465971 466956 470087 479345 484023 484464 487768 487982 491178 491365 491611 492155 499042 500494 504740 507441 508989 515884 516452 521287 522412 524717 526314 527717 527769 530470 532694 532912 533019 534742 534853 535585 536012 537758 537806 538891 539101 540317 540357 541102 541597 544783 544910 547058 550062 550067 550071 550557 559198 563876 565246 565842 568478 569725 572011 578002 590876 600402 603999 620244 622731 623842 629007 630801 638052 648524 653520 665649 689483 689964 699480 709306 720422 747195 747228 764485 775587 784735 814697 817073 817182 824051 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"slave girl bondage"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"доминирован девушк бдсм"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.96%) |
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.