Query Metrics
7
Database Queries
7
Different statements
208.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
184.96 ms (88.62%) |
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 395381 396074 396083 400026 400592 428574 471476 486213 489881 493616 518907 519551 519772 520764 521253 522190 530481 532038 538505 539275 539276 541394 541584 541734 544186 544204 547380 547400 549051 556346 567122 568524 568893 571357 575889 576225 582303 584260 584915 588898 592323 594267 595447 603847 604215 605850 608818 610121 617031 617592 623429 636238 643593 655281 657177 661455 662194 666434 676797 680358 680374 682633 683303 685449 685460 685492 686414 691170 692943 696536 709192 715584 715654 715808 717923 720328 724713 730038 731213 734973 735112 736558 736830 740675 746555 748701 752709 752735 756822 761430 764813 765593 766845 767090 767326 768041 769070 777151 777652 781585 783194 785579 787952 788580 789871 790069 791681 793982 800303 800523 801246 804327 804871 809314 810125 814523 818753 823818 827601 ] |
||||||||||||||||||||||||||||||
|
14.20 ms (6.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 539276 584260 662194 655281 636238 785579 804871 734973 748701 752735 764813 765593 767090 777151 777652 396083 657177 769070 400026 539275 538505 809314 766845 549051 761430 736558 680374 691170 489881 520764 518907 541584 692943 676797 685460 594267 608818 680358 395381 604215 532038 686414 486213 736830 575889 544204 682633 685492 683303 643593 709192 519551 696536 595447 617031 471476 588898 541734 791973 823818 827601 521253 568893 571357 720328 781585 793982 756822 717923 428574 547380 715654 661455 685449 791681 801246 740675 783194 810125 768041 752709 715808 789871 804327 568524 623429 814523 530481 800523 396074 818753 556346 731213 541394 610121 788580 519772 493616 724713 584915 522190 544186 576225 582303 547400 715584 666434 567122 605850 617592 592323 787952 790069 767326 735112 730038 746555 603847 800303 400592 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.29%) |
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 395381 396074 396083 400026 400592 428574 471476 486213 489881 493616 518907 519551 519772 520764 521253 522190 530481 532038 538505 539275 539276 541394 541584 541734 544186 544204 547380 547400 549051 556346 567122 568524 568893 571357 575889 576225 582303 584260 584915 588898 592323 594267 595447 603847 604215 605850 608818 610121 617031 617592 623429 636238 643593 655281 657177 661455 662194 666434 676797 680358 680374 682633 683303 685449 685460 685492 686414 691170 692943 696536 709192 715584 715654 715808 717923 720328 724713 730038 731213 734973 735112 736558 736830 740675 746555 748701 752709 752735 756822 761430 764813 765593 766845 767090 767326 768041 769070 777151 777652 781585 783194 785579 787952 788580 789871 790069 791681 793982 800303 800523 801246 804327 804871 809314 810125 814523 818753 823818 827601 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск худые анал"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade skinny anal"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск худые анал"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.72%) |
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.