Query Metrics
7
Database Queries
7
Different statements
244.65 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 9.73 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 11.87 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cock into cock"
]
|
||||||||||||||||||||||||||||||
| 3 | 40.72 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 725333 729169 729971 732563 733986 741042 741131 742973 746311 746581 749550 750339 753121 753428 754195 754539 755102 760529 761394 767694 783803 794842 801347 805303 808689 810211 811886 725260 730625 735311 736161 736297 737859 739616 743967 744451 748633 748912 750002 753382 756229 756761 762010 764695 768550 769226 724459 724603 724829 726308 727495 728160 728505 729992 733361 735795 735798 738875 740518 743837 747075 748350 754229 756328 757610 761954 726015 726350 732048 732247 733648 734457 734495 734497 738221 738283 739326 739585 739707 741802 741812 742953 747196 748743 762348 764676 771622 772289 727009 729122 738085 738976 744680 748586 749654 749749 753238 758057 764386 770161 772889 773751 606513 607005 629850 632514 696703 698811 700329 703342 710552 716991 717721 717801 720259 720283 721277 721759 721808 722184 ] |
||||||||||||||||||||||||||||||
| 4 | 10.35 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 606513 607005 629850 632514 696703 698811 700329 703342 710552 716991 717721 717801 720259 720283 721277 721759 721808 722184 724459 724603 724829 725260 725333 726015 726308 726350 727009 727495 728160 728505 729122 729169 729971 729992 730625 732048 732247 732563 733361 733648 733986 734457 734495 734497 735311 735795 735798 736161 736297 737859 738085 738221 738283 738875 738976 739326 739585 739616 739707 740518 741042 741131 741802 741812 742953 742973 743837 743967 744451 744680 746311 746581 747075 747196 748350 748586 748633 748743 748912 749550 749654 749749 750002 750339 753121 753238 753382 753428 754195 754229 754539 755102 756229 756328 756761 757610 758057 760529 761394 761954 762010 762348 764386 764676 764695 767694 768550 769226 770161 771622 772289 772889 773751 783803 794842 801347 805303 808689 810211 811886 ] |
||||||||||||||||||||||||||||||
| 5 | 155.32 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 606513 607005 629850 632514 696703 698811 700329 703342 710552 716991 717721 717801 720259 720283 721277 721759 721808 722184 724459 724603 724829 725260 725333 726015 726308 726350 727009 727495 728160 728505 729122 729169 729971 729992 730625 732048 732247 732563 733361 733648 733986 734457 734495 734497 735311 735795 735798 736161 736297 737859 738085 738221 738283 738875 738976 739326 739585 739616 739707 740518 741042 741131 741802 741812 742953 742973 743837 743967 744451 744680 746311 746581 747075 747196 748350 748586 748633 748743 748912 749550 749654 749749 750002 750339 753121 753238 753382 753428 754195 754229 754539 755102 756229 756328 756761 757610 758057 760529 761394 761954 762010 762348 764386 764676 764695 767694 768550 769226 770161 771622 772289 772889 773751 783803 794842 801347 805303 808689 810211 811886 ] |
||||||||||||||||||||||||||||||
| 6 | 7.69 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cock cock"
]
|
||||||||||||||||||||||||||||||
| 7 | 8.96 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cock cock"
]
|
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.