Query Metrics
7
Database Queries
7
Different statements
235.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.54 ms (90.10%) |
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 3381 34016 80314 118141 120432 232978 382200 385832 386240 386403 386734 387012 387850 388078 392930 394361 396088 396110 396369 397381 401014 405907 407871 408219 409938 417952 418622 420289 420335 420384 420513 421054 422162 424038 425679 426374 432323 432776 434425 435378 441269 442571 443906 444074 445236 445279 447999 448245 449094 450385 450791 452652 452982 453047 453361 456564 456701 459650 461396 463376 464118 465245 465511 466752 468338 468359 469266 470180 470434 474267 477754 478492 486076 489953 490689 491584 493657 494448 509580 511988 512922 512964 525028 537662 549177 554817 564830 566901 571846 574101 586294 590167 594581 598700 626917 636816 641560 643233 661912 672321 674522 685401 686502 690947 704916 715680 725612 742338 752105 757831 758495 765657 765721 766691 767236 770376 784219 789540 801008 ] |
||||||||||||||||||||||||||||||
|
14.46 ms (6.13%) |
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 486076 120432 80314 232978 490689 382200 426374 459650 789540 765657 3381 386403 396110 463376 491584 468359 407871 453047 468338 461396 447999 452652 432323 564830 674522 685401 566901 775033 549177 465511 450791 511988 537662 477754 489953 387012 465245 470434 509580 474267 672321 690947 626917 388078 444074 512922 493657 422162 452982 661912 641560 34016 405907 464118 586294 590167 636816 386734 118141 686502 715680 598700 767236 396369 386240 470180 434425 396088 448245 442571 766691 435378 456701 594581 387850 425679 420384 469266 758495 784219 757831 770376 424038 401014 392930 643233 385832 725612 742338 445279 421054 441269 494448 418622 449094 443906 394361 408219 409938 765721 752105 704916 554817 432776 450385 512964 456564 466752 397381 420513 445236 571846 801008 420289 420335 574101 478492 453361 525028 417952 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.07%) |
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 3381 34016 80314 118141 120432 232978 382200 385832 386240 386403 386734 387012 387850 388078 392930 394361 396088 396110 396369 397381 401014 405907 407871 408219 409938 417952 418622 420289 420335 420384 420513 421054 422162 424038 425679 426374 432323 432776 434425 435378 441269 442571 443906 444074 445236 445279 447999 448245 449094 450385 450791 452652 452982 453047 453361 456564 456701 459650 461396 463376 464118 465245 465511 466752 468338 468359 469266 470180 470434 474267 477754 478492 486076 489953 490689 491584 493657 494448 509580 511988 512922 512964 525028 537662 549177 554817 564830 566901 571846 574101 586294 590167 594581 598700 626917 636816 641560 643233 661912 672321 674522 685401 686502 690947 704916 715680 725612 742338 752105 757831 758495 765657 765721 766691 767236 770376 784219 789540 801008 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal dick"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.71%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал член"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.66%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.61%) |
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.