Query Metrics
7
Database Queries
7
Different statements
127.94 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.65 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.80 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom squirt"
]
|
||||||||||||||||||||||||||||||
| 3 | 13.03 ms |
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 502043 523027 526005 822707 818327 547774 644436 586411 597908 778805 789469 794015 807591 637752 795720 505771 826663 478983 567022 653720 653730 673987 808226 750739 758330 739556 742457 534994 546804 666850 675008 597216 633502 494081 478988 666650 639791 779986 797443 791516 748504 779996 794375 509821 495376 815471 476778 547751 547779 547776 591313 643126 777043 785226 805896 734484 791505 773412 599988 639810 814931 818456 575882 547756 575031 571042 672418 582281 586940 813101 527641 516941 599940 714503 626588 628414 639816 626576 751589 805139 599803 424305 527931 572259 600365 596235 513182 604419 577435 508451 ] |
||||||||||||||||||||||||||||||
| 4 | 2.66 ms |
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 424305 476778 478983 478988 494081 495376 502043 505771 508451 509821 513182 516941 523027 526005 527641 527931 534994 546804 547751 547756 547774 547776 547779 567022 571042 572259 575031 575882 577435 582281 586411 586940 591313 596235 597216 597908 599803 599940 599988 600365 604419 626576 626588 628414 633502 637752 639791 639810 639816 643126 644436 653720 653730 666650 666850 672418 673987 675008 714503 734484 739556 742457 748504 750739 751589 758330 773412 777043 778805 779986 779996 785226 789469 791505 791516 794015 794375 795720 797443 805139 805896 807591 808226 813101 814931 815471 818327 818456 822707 826663 ] |
||||||||||||||||||||||||||||||
| 5 | 105.41 ms |
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 424305 476778 478983 478988 494081 495376 502043 505771 508451 509821 513182 516941 523027 526005 527641 527931 534994 546804 547751 547756 547774 547776 547779 567022 571042 572259 575031 575882 577435 582281 586411 586940 591313 596235 597216 597908 599803 599940 599988 600365 604419 626576 626588 628414 633502 637752 639791 639810 639816 643126 644436 653720 653730 666650 666850 672418 673987 675008 714503 734484 739556 742457 748504 750739 751589 758330 773412 777043 778805 779986 779996 785226 789469 791505 791516 794015 794375 795720 797443 805139 805896 807591 808226 813101 814931 815471 818327 818456 822707 826663 ] |
||||||||||||||||||||||||||||||
| 6 | 1.77 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.62 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom сквирт оргазм"
]
|
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.