Query Metrics
7
Database Queries
7
Different statements
142.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.42 ms (82.27%) |
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 6782 13249 114153 150336 233426 233608 233737 282237 282494 295523 336547 345974 365861 366004 373736 385928 386862 388290 388696 389116 389516 390242 390686 390875 391182 391595 391959 392632 393480 396052 397288 397381 398253 401124 402007 406091 408489 418866 423908 423909 426674 427207 429006 429077 432181 441535 441596 447503 447510 447567 448349 453598 453901 463328 465837 466098 470129 475908 479987 483614 483615 483901 490794 492020 503292 506470 524514 533673 533745 537974 541727 541734 561702 561880 572755 579762 595418 595477 596619 597584 597948 598012 598553 598580 598665 598695 598700 598773 598796 609194 621389 663166 678915 683297 684701 710364 714656 717662 719347 735330 742144 760409 762262 762298 765066 765091 766248 768715 776001 780784 781331 782126 790288 790446 793064 803848 812346 814508 827564 ] |
||||||||||||||||||||||||||||||
|
15.56 ms (10.90%) |
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 579762 714656 366004 827564 598553 483901 597584 391959 398253 447567 386862 598665 406091 475908 345974 793064 392632 423909 572755 596619 365861 6782 388696 684701 598012 598773 389516 447503 393480 397381 466098 533673 799895 782126 427207 385928 418866 282494 441535 396052 506470 561880 598695 541734 429006 760409 766248 710364 463328 401124 423908 389116 814508 561702 597948 233426 465837 483614 490794 524514 150336 598580 432181 717662 762298 609194 233608 598796 742144 390875 233737 470129 598700 390242 483615 812346 776001 503292 373736 663166 762262 114153 282237 336547 391182 479987 790288 803848 790446 768715 781331 719347 765066 441596 765091 595418 453901 453598 448349 533745 537974 735330 13249 426674 492020 388290 402007 397288 408489 391595 541727 678915 683297 595477 621389 780784 390686 295523 429077 447510 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (2.08%) |
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 6782 13249 114153 150336 233426 233608 233737 282237 282494 295523 336547 345974 365861 366004 373736 385928 386862 388290 388696 389116 389516 390242 390686 390875 391182 391595 391959 392632 393480 396052 397288 397381 398253 401124 402007 406091 408489 418866 423908 423909 426674 427207 429006 429077 432181 441535 441596 447503 447510 447567 448349 453598 453901 463328 465837 466098 470129 475908 479987 483614 483615 483901 490794 492020 503292 506470 524514 533673 533745 537974 541727 541734 561702 561880 572755 579762 595418 595477 596619 597584 597948 598012 598553 598580 598665 598695 598700 598773 598796 609194 621389 663166 678915 683297 684701 710364 714656 717662 719347 735330 742144 760409 762262 762298 765066 765091 766248 768715 776001 780784 781331 782126 790288 790446 793064 803848 812346 814508 827564 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian girl anal"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск девушк анал"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.