Query Metrics
7
Database Queries
7
Different statements
250.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
224.17 ms (89.65%) |
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 395406 395446 395702 396577 397045 400138 402257 402266 404318 404349 404768 404800 405082 414068 414666 415145 415188 415256 418867 418939 422649 422671 422709 422901 423039 426139 428726 429939 434201 434710 435669 442358 443215 443429 445565 445835 446198 446863 447407 447484 452646 452828 457902 458723 461056 462470 464916 465575 466288 466916 467844 470067 470778 471811 473045 473797 474061 477068 481719 489607 489820 492565 492994 493116 495792 497590 497892 498319 501324 504974 510063 515269 516894 518936 524003 528071 530677 535039 537186 550210 550327 554256 562872 566033 566297 568287 571210 571468 580271 580691 581687 582722 585982 587188 587795 588190 590695 593167 594173 597494 597793 598777 600157 601617 601755 605347 606816 609182 618483 619470 626850 644657 686047 703039 722504 730098 732899 736663 811994 815002 ] |
||||||||||||||||||||||||||||||
|
15.02 ms (6.01%) |
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 598777 609182 619470 587188 587795 600157 597494 601617 605347 618483 626850 811994 732899 736663 730098 601755 644657 703039 404349 418867 415256 445565 473045 429939 465575 489820 528071 489607 493116 515269 510063 422709 422901 442358 466288 404768 434710 446198 462470 452828 404318 492565 404800 418939 422671 423039 443215 414068 414666 415188 443429 415145 422649 434201 428726 435669 815002 452646 473797 447407 477068 445835 457902 518936 537186 495792 504974 535039 501324 516894 464916 566297 580271 580691 582722 554256 562872 566033 568287 571210 581687 722504 686047 550210 550327 571468 588190 606816 585982 590695 593167 594173 597793 466916 467844 481719 396577 400138 446863 470778 471811 474061 395406 395446 402257 470067 395702 397045 402266 405082 426139 447484 458723 530677 497892 492994 497590 498319 524003 461056 ] |
||||||||||||||||||||||||||||||
|
3.71 ms (1.48%) |
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 395406 395446 395702 396577 397045 400138 402257 402266 404318 404349 404768 404800 405082 414068 414666 415145 415188 415256 418867 418939 422649 422671 422709 422901 423039 426139 428726 429939 434201 434710 435669 442358 443215 443429 445565 445835 446198 446863 447407 447484 452646 452828 457902 458723 461056 462470 464916 465575 466288 466916 467844 470067 470778 471811 473045 473797 474061 477068 481719 489607 489820 492565 492994 493116 495792 497590 497892 498319 501324 504974 510063 515269 516894 518936 524003 528071 530677 535039 537186 550210 550327 554256 562872 566033 566297 568287 571210 571468 580271 580691 581687 582722 585982 587188 587795 588190 590695 593167 594173 597494 597793 598777 600157 601617 601755 605347 606816 609182 618483 619470 626850 644657 686047 703039 722504 730098 732899 736663 811994 815002 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые волосатая teen"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые волосатая teen"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny hairy teen"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.61%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.