Query Metrics
7
Database Queries
7
Different statements
422.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
398.30 ms (94.29%) |
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 517796 540072 540127 540129 540154 540165 542427 542442 542722 548895 548918 553692 554703 554705 554708 554715 554732 554735 555214 555224 555227 555308 555333 555385 555601 555724 555772 558264 561041 561768 562157 563976 566761 566973 567510 567639 576617 576817 577032 580903 581296 583913 592759 592966 600668 606071 629967 633202 633217 641644 646457 647822 648891 649294 649447 650693 653691 662881 666053 666057 667360 673944 681242 683045 683324 684780 687778 692683 692721 692763 693376 702034 703733 708320 710480 710935 714551 714581 714599 714836 715444 715621 719910 724040 726624 727534 728515 729063 729236 729246 729252 730528 733119 734360 734542 739618 745865 757050 769445 780889 784929 788643 789438 795943 795952 795961 800949 801084 801530 801794 810087 814058 818540 818573 824896 826209 826322 826541 827490 827602 ] |
||||||||||||||||||||||||||||||
|
13.31 ms (3.15%) |
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 540127 554735 555224 542427 548895 554708 555772 561768 563976 653691 673944 681242 666057 683324 687778 649447 662881 708320 715621 555214 555333 600668 633217 606071 592759 795952 795961 801530 769445 795943 801084 724040 728515 739618 730528 703733 566761 641644 814058 553692 567639 733119 810087 826541 818573 827490 540154 540072 540129 540165 554715 555308 555385 555601 577032 542722 548918 580903 555724 561041 562157 581296 684780 693376 646457 715444 567510 592966 784929 800949 801794 780889 729063 757050 788643 789438 727534 729236 729246 745865 726624 734360 633202 714551 714581 583913 629967 729252 734542 710935 818540 826209 826322 824896 827602 517796 554703 554705 558264 566973 576817 542442 554732 555227 576617 666053 683045 692763 702034 710480 667360 692683 692721 714599 714836 719910 647822 648891 649294 650693 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (0.68%) |
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 517796 540072 540127 540129 540154 540165 542427 542442 542722 548895 548918 553692 554703 554705 554708 554715 554732 554735 555214 555224 555227 555308 555333 555385 555601 555724 555772 558264 561041 561768 562157 563976 566761 566973 567510 567639 576617 576817 577032 580903 581296 583913 592759 592966 600668 606071 629967 633202 633217 641644 646457 647822 648891 649294 649447 650693 653691 662881 666053 666057 667360 673944 681242 683045 683324 684780 687778 692683 692721 692763 693376 702034 703733 708320 710480 710935 714551 714581 714599 714836 715444 715621 719910 724040 726624 727534 728515 729063 729236 729246 729252 730528 733119 734360 734542 739618 745865 757050 769445 780889 784929 788643 789438 795943 795952 795961 800949 801084 801530 801794 810087 814058 818540 818573 824896 826209 826322 826541 827490 827602 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (0.54%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен писсинг"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife piss"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен писсинг"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.40%) |
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.