Query Metrics
7
Database Queries
7
Different statements
181.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.05 ms (86.89%) |
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 145624 386786 390928 411625 419839 458987 460003 470152 476161 489115 490437 490594 510895 510900 510947 532616 539892 545735 557607 559423 562984 576237 576450 576766 577308 581291 584383 587805 589655 591904 604581 605628 609073 612622 619620 621051 627232 632101 640448 643000 644199 647856 648017 648273 652757 660383 666058 666094 668007 668023 676677 680300 685758 696144 697306 701059 703709 703772 703783 707481 708035 708743 709884 710182 713063 713453 714352 714373 714407 714706 717127 719144 719193 722167 723966 724503 724703 728148 729050 729051 733223 733326 734205 735391 735976 739895 740541 740666 742274 742863 746848 747251 755414 759701 759731 759916 776469 778481 794268 794574 794591 796710 796741 800737 802307 804251 804398 807827 808464 815766 817955 819310 819347 824077 824418 825064 825341 826004 827326 827585 ] |
||||||||||||||||||||||||||||||
|
13.95 ms (7.67%) |
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 666094 708035 644199 587805 778481 742863 724503 735391 807827 490437 539892 545735 576237 557607 576766 701059 713063 648273 668023 676677 648017 668007 703772 722167 609073 612622 627232 640448 729051 734205 740541 728148 729050 739895 747251 740666 703709 703783 714407 735976 619620 759701 800737 824418 621051 827585 386786 419839 476161 460003 759731 817955 819347 714706 755414 719193 652757 632101 562984 589655 742274 470152 510895 532616 559423 708743 660383 794591 794574 802307 796710 796741 724703 746848 710182 794268 827326 458987 826004 804398 717127 819310 825064 145624 411625 825341 510900 584383 605628 591904 776469 808464 733326 804251 489115 490594 824077 510947 815766 709884 643000 733223 723966 759916 581291 719144 647856 685758 604581 390928 577308 576450 666058 707481 713453 680300 696144 697306 714352 714373 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (1.67%) |
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 145624 386786 390928 411625 419839 458987 460003 470152 476161 489115 490437 490594 510895 510900 510947 532616 539892 545735 557607 559423 562984 576237 576450 576766 577308 581291 584383 587805 589655 591904 604581 605628 609073 612622 619620 621051 627232 632101 640448 643000 644199 647856 648017 648273 652757 660383 666058 666094 668007 668023 676677 680300 685758 696144 697306 701059 703709 703772 703783 707481 708035 708743 709884 710182 713063 713453 714352 714373 714407 714706 717127 719144 719193 722167 723966 724503 724703 728148 729050 729051 733223 733326 734205 735391 735976 739895 740541 740666 742274 742863 746848 747251 755414 759701 759731 759916 776469 778481 794268 794574 794591 796710 796741 800737 802307 804251 804398 807827 808464 815766 817955 819310 819347 824077 824418 825064 825341 826004 827326 827585 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy big pussy"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая большие pussy"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая большие pussy"
]
|
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.