Query Metrics
7
Database Queries
7
Different statements
143.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.89 ms (84.06%) |
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 53510 83932 370949 381930 383722 384336 389966 391917 395689 395721 396110 401426 405501 420742 421992 423980 429947 432358 435398 442735 443766 444391 446536 453503 455478 458910 462226 467406 468880 471035 479139 483413 490603 490914 491996 506836 513142 519230 519268 523165 524886 526042 526888 526963 531593 537256 537549 538910 542471 548294 554430 555988 560075 560085 561030 562418 562606 569211 583867 587471 587473 589123 590425 596752 606413 607692 609047 614843 617029 620154 620156 620165 625172 629806 629833 630288 641658 645813 648896 651891 660426 663895 663903 665197 665285 668158 681312 683854 696271 714392 715370 722054 728954 729063 729246 736410 738278 743227 751030 755448 773884 775464 776434 781238 782534 784993 801471 802150 803079 803918 804940 809542 809869 812555 817804 818396 823229 825141 826224 827341 ] |
||||||||||||||||||||||||||||||
|
12.43 ms (8.64%) |
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 660426 554430 587471 609047 802150 809542 479139 569211 620165 801471 590425 625172 526042 519230 435398 395721 389966 53510 818396 663903 681312 804940 776434 782534 736410 396110 453503 620156 429947 370949 420742 542471 663895 651891 620154 423980 468880 483413 519268 383722 381930 537549 548294 561030 606413 641658 432358 443766 490914 444391 506836 391917 401426 405501 458910 471035 555988 560075 562418 446536 467406 513142 523165 526888 491996 462226 755448 630288 421992 442735 526963 560085 524886 395689 384336 83932 826224 817804 825141 823229 827341 537256 538910 562606 583867 665285 668158 683854 648896 696271 722054 589123 617029 587473 596752 775464 781238 809869 729063 743227 773884 812555 729246 738278 728954 751030 714392 784993 803079 803918 455478 490603 531593 715370 645813 665197 629833 607692 629806 614843 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.95%) |
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 53510 83932 370949 381930 383722 384336 389966 391917 395689 395721 396110 401426 405501 420742 421992 423980 429947 432358 435398 442735 443766 444391 446536 453503 455478 458910 462226 467406 468880 471035 479139 483413 490603 490914 491996 506836 513142 519230 519268 523165 524886 526042 526888 526963 531593 537256 537549 538910 542471 548294 554430 555988 560075 560085 561030 562418 562606 569211 583867 587471 587473 589123 590425 596752 606413 607692 609047 614843 617029 620154 620156 620165 625172 629806 629833 630288 641658 645813 648896 651891 660426 663895 663903 665197 665285 668158 681312 683854 696271 714392 715370 722054 728954 729063 729246 736410 738278 743227 751030 755448 773884 775464 776434 781238 782534 784993 801471 802150 803079 803918 804940 809542 809869 812555 817804 818396 823229 825141 826224 827341 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy stockings"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.