Query Metrics
7
Database Queries
7
Different statements
144.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.32 ms (83.69%) |
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 340613 383601 388161 388535 401414 411536 418467 418663 421386 445099 445973 446994 449921 452840 452897 453002 457807 466394 468240 471026 471461 479838 483741 496723 499922 500222 500282 500433 505385 510331 510945 516465 517763 518057 518613 526244 526616 527474 557896 564758 564955 568219 579559 584418 602255 619230 621051 627116 627314 628602 630961 661590 664723 668703 673006 700468 700682 706422 707724 714727 722433 725742 727277 733670 736089 736163 736340 736833 737858 738479 739805 740270 740580 740841 741130 743246 747415 748296 748511 749599 749696 751342 751344 753969 754423 756492 758664 758745 759068 759338 761248 761331 764717 764791 766276 768033 768481 772632 782070 782343 783168 784236 784625 790422 790689 791336 791884 793969 794937 796401 797058 803510 803822 807266 811097 812032 814394 817645 819157 ] |
||||||||||||||||||||||||||||||
|
13.59 ms (9.37%) |
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 736163 736340 736833 737858 748511 749696 751342 756492 758664 759068 759338 764791 739805 740270 754423 733670 738479 740580 741130 743246 748296 749599 766276 768481 725742 727277 736089 740841 747415 751344 753969 758745 761248 761331 764717 768033 627116 630961 707724 722433 782343 783168 784625 790422 791336 791884 793969 794937 796401 797058 803510 807266 812032 814394 664723 466394 817645 819157 500433 526616 706422 628602 784236 803822 627314 383601 505385 527474 579559 661590 668703 700468 700682 619230 621051 811097 782070 517763 584418 673006 790689 772632 564955 826351 602255 452897 516465 500222 518613 564758 388535 388161 401414 418663 411536 471026 479838 452840 471461 449921 457807 496723 510945 499922 500282 468240 557896 714727 568219 340613 445099 421386 445973 446994 453002 418467 510331 483741 518057 526244 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (2.21%) |
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 340613 383601 388161 388535 401414 411536 418467 418663 421386 445099 445973 446994 449921 452840 452897 453002 457807 466394 468240 471026 471461 479838 483741 496723 499922 500222 500282 500433 505385 510331 510945 516465 517763 518057 518613 526244 526616 527474 557896 564758 564955 568219 579559 584418 602255 619230 621051 627116 627314 628602 630961 661590 664723 668703 673006 700468 700682 706422 707724 714727 722433 725742 727277 733670 736089 736163 736340 736833 737858 738479 739805 740270 740580 740841 741130 743246 747415 748296 748511 749599 749696 751342 751344 753969 754423 756492 758664 758745 759068 759338 761248 761331 764717 764791 766276 768033 768481 772632 782070 782343 783168 784236 784625 790422 790689 791336 791884 793969 794937 796401 797058 803510 803822 807266 811097 812032 814394 817645 819157 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер pussy соло"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер pussy соло"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam pussy solo"
]
|
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.