Query Metrics
7
Database Queries
7
Different statements
220.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
190.02 ms (86.26%) |
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 4463 7157 21478 21500 48235 92307 95586 154374 182238 188699 310758 326115 337012 358566 359084 382071 382588 384423 385358 387905 388700 388770 391121 391744 391754 391961 394646 396397 396728 398073 402597 404587 406688 407350 407958 408616 411914 412261 413183 413637 414763 415758 416296 418770 419128 420473 421573 423487 424875 426155 426368 426539 429603 433217 440890 443166 460486 460704 461370 461402 464180 465958 467955 468718 468831 469489 471678 473325 474292 476074 476176 477007 479818 480389 485100 485363 486537 493810 496873 498454 500546 509580 512938 516062 516480 517844 523845 523847 523852 525376 525393 526528 531235 531698 538815 544508 546973 549221 563078 568480 580107 591333 596168 597018 599844 605308 607371 666582 668512 669215 683826 733645 748475 795538 799203 811450 815493 816484 817416 827973 ] |
||||||||||||||||||||||||||||||
|
20.46 ms (9.29%) |
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 461370 95586 426539 469489 479818 485100 538815 525393 568480 580107 599844 468718 512938 591333 382071 326115 382588 48235 391121 418770 827973 460486 473325 474292 509580 516062 461402 683826 607371 795538 733645 4463 443166 460704 468831 396397 413183 477007 420473 485363 525376 188699 406688 414763 476074 388700 391961 21500 423487 387905 412261 426368 531235 421573 517844 433217 407958 408616 415758 496873 549221 544508 476176 388770 391754 424875 523845 596168 391744 467955 402597 817416 815493 816484 531698 666582 668512 597018 605308 182238 398073 563078 669215 419128 493810 471678 799203 359084 480389 486537 416296 429603 465958 358566 396728 426155 523847 526528 498454 516480 523852 385358 154374 394646 310758 337012 21478 7157 404587 407350 411914 413637 440890 464180 500546 546973 811450 748475 92307 384423 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.39%) |
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 4463 7157 21478 21500 48235 92307 95586 154374 182238 188699 310758 326115 337012 358566 359084 382071 382588 384423 385358 387905 388700 388770 391121 391744 391754 391961 394646 396397 396728 398073 402597 404587 406688 407350 407958 408616 411914 412261 413183 413637 414763 415758 416296 418770 419128 420473 421573 423487 424875 426155 426368 426539 429603 433217 440890 443166 460486 460704 461370 461402 464180 465958 467955 468718 468831 469489 471678 473325 474292 476074 476176 477007 479818 480389 485100 485363 486537 493810 496873 498454 500546 509580 512938 516062 516480 517844 523845 523847 523852 525376 525393 526528 531235 531698 538815 544508 546973 549221 563078 568480 580107 591333 596168 597018 599844 605308 607371 666582 668512 669215 683826 733645 748475 795538 799203 811450 815493 816484 817416 827973 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая milf анал"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde milf anal"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"беловолосая milf анал"
]
|
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.