Query Metrics
7
Database Queries
7
Different statements
179.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.15 ms (87.36%) |
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 31822 411534 420823 423707 444641 470998 478770 521693 544018 544029 549642 550786 550905 550928 554659 602677 617368 648221 669581 693084 703571 710846 717976 718033 720570 721649 723701 725269 725661 727013 728888 728905 729241 730099 733350 733487 736089 738479 739588 740580 741503 742838 743094 743603 746170 746480 746711 747423 747592 748502 749598 751339 752654 767363 768105 768515 768755 772453 773177 773178 773355 775659 777859 777873 777877 779048 779671 783183 784128 784418 784888 784945 785866 786877 786884 787382 787813 790711 791814 792019 792339 792442 794709 796367 796791 800524 802331 804205 804398 804949 811901 813820 816659 816668 817007 817359 818763 818765 819178 819687 819703 820057 824230 824508 824509 824853 824855 825159 825855 826253 826694 826862 827478 827541 827543 827581 827694 828026 828294 ] |
||||||||||||||||||||||||||||||
|
13.16 ms (7.31%) |
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 423707 444641 824855 825855 816659 817007 825159 826862 827478 827541 827543 824230 824508 824853 826253 828026 470998 521693 544018 544029 549642 550928 703571 721649 648221 669581 720570 550905 554659 775659 777877 779671 791814 792339 794709 796791 804398 777859 786884 787813 790711 792019 796367 800524 804949 723701 743094 746711 747423 752654 772453 773177 783183 784418 784888 786877 787382 792442 802331 811901 725269 728888 733487 748502 768515 773355 728905 739588 743603 746480 725661 729241 738479 740580 742838 747592 727013 733350 736089 751339 767363 717976 718033 777873 784128 784945 785866 804205 779048 749598 478770 710846 617368 768105 602677 411534 827581 828294 741503 768755 746170 773178 730099 813820 550786 693084 31822 420823 817359 826694 816668 819178 819703 827694 816149 818763 819687 824509 818765 820057 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.51%) |
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 31822 411534 420823 423707 444641 470998 478770 521693 544018 544029 549642 550786 550905 550928 554659 602677 617368 648221 669581 693084 703571 710846 717976 718033 720570 721649 723701 725269 725661 727013 728888 728905 729241 730099 733350 733487 736089 738479 739588 740580 741503 742838 743094 743603 746170 746480 746711 747423 747592 748502 749598 751339 752654 767363 768105 768515 768755 772453 773177 773178 773355 775659 777859 777873 777877 779048 779671 783183 784128 784418 784888 784945 785866 786877 786884 787382 787813 790711 791814 792019 792339 792442 794709 796367 796791 800524 802331 804205 804398 804949 811901 813820 816659 816668 817007 817359 818763 818765 819178 819687 819703 820057 824230 824508 824509 824853 824855 825159 825855 826253 826694 826862 827478 827541 827543 827581 827694 828026 828294 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife amateur orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен любительск orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен любительск orgasm"
]
|
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.