Query Metrics
7
Database Queries
7
Different statements
199.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.01 ms (88.82%) |
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 61315 72285 151155 191265 197736 383558 384178 384778 388570 389122 392030 394425 394780 395133 395926 396768 397224 397387 399421 400473 401225 401958 402160 402419 403316 407383 407610 407694 407732 409241 409942 411069 411593 411720 411766 416871 424416 445920 465099 513115 515177 516461 537849 541597 545733 548538 552599 560408 562518 563478 565703 567628 568018 572611 580776 586647 589658 608042 616997 617178 621337 630049 647657 663383 663396 663429 663489 663898 664285 665215 665218 665240 665301 665306 665395 665418 665499 666791 666808 667010 667012 667614 667649 667679 667772 667900 669448 699140 712331 718499 720607 722056 722127 722664 722687 732203 736620 737382 743834 744986 745015 746025 748145 748229 752876 758436 770178 781694 781748 781766 782216 785497 793436 801371 802657 807333 808496 816258 820228 823915 ] |
||||||||||||||||||||||||||||||
|
12.41 ms (6.23%) |
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 399421 402160 407610 409241 411069 608042 411720 401958 396768 820228 823915 552599 568018 718499 572611 781748 781694 736620 732203 630049 782216 785497 197736 560408 548538 395926 565703 567628 666791 666808 667649 586647 616997 743834 752876 424416 191265 416871 537849 513115 722056 621337 617178 808496 770178 445920 580776 562518 722687 389122 407694 384178 151155 394780 395133 394425 72285 409942 411593 816258 541597 781766 737382 746025 748145 722664 392030 388570 465099 663429 401225 402419 712331 807333 589658 397387 400473 411766 515177 545733 563478 663898 665395 667900 665215 665240 667614 667679 647657 665218 793436 801371 758436 802657 748229 744986 745015 699140 720607 61315 407383 383558 384778 403316 397224 407732 516461 667010 667012 722127 663383 663489 665301 665418 665499 667772 669448 663396 664285 665306 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.54%) |
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 61315 72285 151155 191265 197736 383558 384178 384778 388570 389122 392030 394425 394780 395133 395926 396768 397224 397387 399421 400473 401225 401958 402160 402419 403316 407383 407610 407694 407732 409241 409942 411069 411593 411720 411766 416871 424416 445920 465099 513115 515177 516461 537849 541597 545733 548538 552599 560408 562518 563478 565703 567628 568018 572611 580776 586647 589658 608042 616997 617178 621337 630049 647657 663383 663396 663429 663489 663898 664285 665215 665218 665240 665301 665306 665395 665418 665499 666791 666808 667010 667012 667614 667649 667679 667772 667900 669448 699140 712331 718499 720607 722056 722127 722664 722687 732203 736620 737382 743834 744986 745015 746025 748145 748229 752876 758436 770178 781694 781748 781766 782216 785497 793436 801371 802657 807333 808496 816258 820228 823915 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"большие старые сиськи…"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие старые сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.79%) |
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.