Query Metrics
7
Database Queries
7
Different statements
166.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.75 ms (87.14%) |
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 540072 540129 540154 540165 542442 542722 548918 553692 554703 554705 554715 554732 555224 555308 555333 555385 555601 555724 561041 562157 566761 567510 567639 575358 576617 577032 580903 581296 583913 588391 592759 592966 606071 613958 614330 633202 633217 641644 646457 647822 648891 649294 650693 661944 662881 665082 666053 666991 667360 669248 681242 683045 684780 692683 692721 692763 693376 699185 702034 704582 707557 709913 710480 710935 714551 714581 715133 715444 715621 723541 724040 725474 726624 727534 728515 728616 729063 729236 729246 729252 730528 733119 734360 734542 739618 744765 744832 745865 756461 757050 765812 769445 778692 780889 783930 784246 784929 785114 788643 789438 795943 795952 795961 796635 800949 801084 801530 801776 801794 810081 810087 814058 818540 818573 819424 824896 825824 826541 827490 827602 ] |
||||||||||||||||||||||||||||||
|
12.25 ms (7.38%) |
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 681242 662881 555333 633217 606071 592759 769445 724040 728515 715133 801776 723541 825824 819424 555224 715621 801530 801084 739618 730528 744832 540154 581296 684780 693376 646457 733119 566761 540072 540129 548918 555724 561041 795952 795961 795943 553692 567639 827490 540165 554715 555385 577032 542722 580903 562157 592966 800949 757050 729246 726624 633202 714551 714581 641644 810087 707557 826541 818573 555308 555601 715444 567510 784929 801794 780889 729063 788643 789438 727534 729236 745865 734360 702034 710935 542442 576617 666053 683045 710480 647822 648891 649294 650693 661944 669248 709913 575358 588391 814058 729252 734542 818540 824896 827602 554703 554705 554732 692763 667360 692683 692721 665082 666991 699185 704582 613958 614330 784246 785114 778692 725474 765812 756461 744765 728616 783930 796635 810081 583913 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.59%) |
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 540072 540129 540154 540165 542442 542722 548918 553692 554703 554705 554715 554732 555224 555308 555333 555385 555601 555724 561041 562157 566761 567510 567639 575358 576617 577032 580903 581296 583913 588391 592759 592966 606071 613958 614330 633202 633217 641644 646457 647822 648891 649294 650693 661944 662881 665082 666053 666991 667360 669248 681242 683045 684780 692683 692721 692763 693376 699185 702034 704582 707557 709913 710480 710935 714551 714581 715133 715444 715621 723541 724040 725474 726624 727534 728515 728616 729063 729236 729246 729252 730528 733119 734360 734542 739618 744765 744832 745865 756461 757050 765812 769445 778692 780889 783930 784246 784929 785114 788643 789438 795943 795952 795961 796635 800949 801084 801530 801776 801794 810081 810087 814058 818540 818573 819424 824896 825824 826541 827490 827602 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur wife piss"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск жен писсинг"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск жен писсинг"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.81%) |
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.