Query Metrics
7
Database Queries
7
Different statements
393.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.17 ms (53.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young волосатая анал"
]
|
||||||||||||||||||||||||||||||
|
153.71 ms (39.10%) |
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 385314 385469 388722 389966 390402 390567 390747 391034 391945 395596 395682 395860 396020 401137 401967 404318 404644 404698 404768 404829 404939 405029 405485 405830 406062 408245 409083 409877 410237 411761 411918 413460 415112 422592 422652 424410 424426 424436 424461 424462 426434 427433 428703 443695 445903 447094 451464 453096 454298 457500 458011 459802 459804 461056 461620 462470 463948 466212 469283 469576 474685 476344 481998 483149 486542 488373 491354 491392 493951 495558 496032 503127 510578 511815 512800 513149 513785 519268 522611 528020 529524 544478 565156 565172 576720 577368 579389 586628 590802 597494 600316 614023 614401 619439 623493 624427 628327 630526 661974 685791 688546 688624 703140 703902 706286 712311 718496 727812 736440 776312 789691 790813 799146 802723 804464 815869 816340 818442 820327 821365 ] |
||||||||||||||||||||||||||||||
|
20.54 ms (5.23%) |
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 424436 619439 404698 422592 422652 469576 503127 630526 804464 415112 404318 385314 409877 427433 395860 410237 411761 424462 401137 790813 736440 623493 821365 510578 597494 706286 703140 528020 624427 727812 586628 426434 453096 395682 776312 404939 688624 614023 614401 451464 491354 462470 685791 396020 481998 495558 401967 463948 512800 712311 390747 411918 469283 424426 496032 390567 816340 818442 688546 789691 385469 511815 590802 544478 428703 466212 405485 454298 513785 459804 408245 458011 404644 461620 404829 388722 519268 483149 404768 600316 445903 491392 628327 577368 579389 565172 576720 565156 488373 389966 457500 529524 395596 406062 447094 486542 661974 703902 802723 424410 391945 443695 405029 476344 405830 424461 513149 820327 815869 718496 390402 409083 459802 474685 461056 391034 413460 522611 799146 493951 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (0.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 385314 385469 388722 389966 390402 390567 390747 391034 391945 395596 395682 395860 396020 401137 401967 404318 404644 404698 404768 404829 404939 405029 405485 405830 406062 408245 409083 409877 410237 411761 411918 413460 415112 422592 422652 424410 424426 424436 424461 424462 426434 427433 428703 443695 445903 447094 451464 453096 454298 457500 458011 459802 459804 461056 461620 462470 463948 466212 469283 469576 474685 476344 481998 483149 486542 488373 491354 491392 493951 495558 496032 503127 510578 511815 512800 513149 513785 519268 522611 528020 529524 544478 565156 565172 576720 577368 579389 586628 590802 597494 600316 614023 614401 619439 623493 624427 628327 630526 661974 685791 688546 688624 703140 703902 706286 712311 718496 727812 736440 776312 789691 790813 799146 802723 804464 815869 816340 818442 820327 821365 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young hairy anal"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young волосатая анал"
]
|
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.