Query Metrics
7
Database Queries
7
Different statements
205.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.72 ms (86.41%) |
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 181009 396321 397366 405531 423836 424198 424493 424658 427487 428068 430072 434361 443119 443689 443773 448365 448619 454529 454658 458841 467923 469071 471007 472235 474496 476992 477376 477959 477966 484603 484609 484716 485363 486788 487450 490106 491986 498865 499865 503962 504176 504354 504640 505623 506050 509206 509232 510524 510750 512347 514913 518563 523415 524766 524886 525119 527624 527753 533384 534250 541781 542190 543088 544475 544477 544484 544829 550374 554889 555716 556906 558009 563063 563444 565659 565808 565983 566155 567396 567433 568560 573216 574464 576626 576636 581130 584073 585968 586256 590192 591134 592515 592970 594557 606618 622826 623608 663409 663448 663455 663507 664287 665107 665123 665274 665490 668412 668743 669738 672138 678967 702621 720603 726120 728194 742286 752679 790998 796071 802493 ] |
||||||||||||||||||||||||||||||
|
17.36 ms (8.44%) |
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 487450 510524 534250 504176 542190 544477 563063 563444 574464 541781 543088 558009 678967 663448 665107 397366 424658 510750 484716 506050 512347 484609 524886 491986 503962 181009 458841 523415 514913 509232 544484 581130 576626 606618 585968 623608 796071 726120 720603 802493 454529 424493 476992 472235 584073 566155 576636 555716 665490 702621 434361 527624 405531 428068 477959 448619 448365 474496 533384 544475 544829 550374 556906 565808 567396 567433 554889 568560 573216 665274 668412 663409 672138 664287 665123 668743 622826 591134 592970 594557 586256 590192 592515 790998 742286 752679 443119 467923 477376 423836 443689 424198 427487 471007 509206 484603 485363 498865 499865 504640 490106 527753 430072 454658 469071 486788 505623 524766 525119 504354 565983 565659 663507 663455 669738 728194 396321 443773 477966 518563 ] |
||||||||||||||||||||||||||||||
|
3.37 ms (1.64%) |
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 181009 396321 397366 405531 423836 424198 424493 424658 427487 428068 430072 434361 443119 443689 443773 448365 448619 454529 454658 458841 467923 469071 471007 472235 474496 476992 477376 477959 477966 484603 484609 484716 485363 486788 487450 490106 491986 498865 499865 503962 504176 504354 504640 505623 506050 509206 509232 510524 510750 512347 514913 518563 523415 524766 524886 525119 527624 527753 533384 534250 541781 542190 543088 544475 544477 544484 544829 550374 554889 555716 556906 558009 563063 563444 565659 565808 565983 566155 567396 567433 568560 573216 574464 576626 576636 581130 584073 585968 586256 590192 591134 592515 592970 594557 606618 622826 623608 663409 663448 663455 663507 664287 665107 665123 665274 665490 668412 668743 669738 672138 678967 702621 720603 726120 728194 742286 752679 790998 796071 802493 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny mature pussy"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые mature pussy"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые mature 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.