Query Metrics
7
Database Queries
7
Different statements
182.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.80 ms (88.29%) |
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 33707 34146 326207 373884 386082 386357 390292 393759 411443 413186 413429 413569 420022 421033 421138 421734 423455 423876 426069 430920 434783 436840 437437 438020 441758 442995 443002 443004 443027 443055 448647 449598 451634 452370 452423 452704 452709 452725 455522 455598 456071 456583 458217 461231 461811 463496 463725 465796 467755 469814 473048 473068 477232 478131 478139 490705 493276 501916 502630 504623 505263 509522 518058 518061 522578 522897 525216 525720 526940 526941 529255 530518 531429 551604 552241 552609 558618 569231 569308 578342 579357 581833 585011 586700 591295 593421 594594 594607 594619 594638 610082 614658 616699 622264 631717 637747 659379 660307 668471 669398 700299 701495 705737 713699 718529 720955 721791 728067 728557 730662 734154 744313 749437 751128 753259 753993 787033 795385 809179 817298 ] |
||||||||||||||||||||||||||||||
|
12.24 ms (6.72%) |
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 421734 529255 434783 452704 469814 413569 502630 465796 795385 728067 809179 441758 436840 443002 458217 817298 421033 718529 753259 730662 569231 622264 721791 442995 386357 463725 501916 579357 660307 614658 720955 509522 430920 616699 787033 728557 525720 669398 421138 452725 552609 578342 594638 734154 610082 33707 438020 478131 505263 518058 552241 423455 386082 326207 637747 393759 443055 373884 34146 504623 668471 586700 531429 749437 581833 413186 461811 744313 420022 448647 713699 705737 443004 456583 751128 526941 522897 452423 593421 452370 522578 461231 530518 558618 700299 659379 591295 753993 437437 455598 411443 426069 525216 455522 449598 467755 594607 423876 473068 490705 390292 456071 473048 594619 413429 452709 443027 477232 493276 463496 518061 585011 594594 551604 451634 478139 701495 569308 631717 526940 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.32%) |
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 33707 34146 326207 373884 386082 386357 390292 393759 411443 413186 413429 413569 420022 421033 421138 421734 423455 423876 426069 430920 434783 436840 437437 438020 441758 442995 443002 443004 443027 443055 448647 449598 451634 452370 452423 452704 452709 452725 455522 455598 456071 456583 458217 461231 461811 463496 463725 465796 467755 469814 473048 473068 477232 478131 478139 490705 493276 501916 502630 504623 505263 509522 518058 518061 522578 522897 525216 525720 526940 526941 529255 530518 531429 551604 552241 552609 558618 569231 569308 578342 579357 581833 585011 586700 591295 593421 594594 594607 594619 594638 610082 614658 616699 622264 631717 637747 659379 660307 668471 669398 700299 701495 705737 713699 718529 720955 721791 728067 728557 730662 734154 744313 749437 751128 753259 753993 787033 795385 809179 817298 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс sensual"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob sensual"
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс sensual"
]
|
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.