Query Metrics
7
Database Queries
7
Different statements
155.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.11 ms (83.01%) |
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 3561 11947 44871 59488 309991 310190 365893 383098 385031 385380 388261 392675 393418 398824 401398 409045 413700 423944 428684 428702 432358 433418 437657 440802 443975 448114 464357 465673 466492 466868 469324 472907 477262 478382 479587 481257 484962 485089 487860 489222 492754 499874 503487 514766 515915 522438 526437 526508 526555 528500 529008 529654 531317 533270 537549 540474 541167 544801 546076 548458 554405 562603 563168 568181 568899 569320 570115 571312 573243 577052 577182 577204 578768 579547 580248 580577 582292 582558 602832 606337 607029 607269 611795 639861 666439 675310 715473 725473 728224 728295 729640 732793 744200 745461 745844 752950 755952 758809 759554 760777 763141 764234 770241 772557 774761 781856 786470 788365 794213 796494 798087 800239 801704 802150 803512 806473 808958 811705 818009 819237 ] |
||||||||||||||||||||||||||||||
|
17.24 ms (11.09%) |
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 802150 788365 801704 755952 763141 772557 781856 728224 744200 764234 770241 806473 401398 546076 554405 528500 544801 666439 811705 758809 725473 526508 579547 569320 423944 44871 428702 537549 529008 499874 465673 573243 580248 808958 385031 432358 437657 477262 365893 388261 515915 492754 526555 484962 464357 481257 443975 819237 548458 577204 578768 582292 602832 607269 611795 803512 752950 798087 800239 728295 745461 729640 715473 794213 796494 469324 568181 570115 759554 59488 818009 472907 563168 571312 580577 675310 774761 732793 745844 478382 479587 485089 503487 489222 487860 309991 310190 11947 398824 433418 529654 582558 568899 639861 760777 392675 409045 522438 607029 385380 606337 786470 577182 466868 440802 428684 383098 393418 3561 413700 448114 466492 531317 514766 526437 540474 533270 562603 577052 541167 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.45%) |
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 3561 11947 44871 59488 309991 310190 365893 383098 385031 385380 388261 392675 393418 398824 401398 409045 413700 423944 428684 428702 432358 433418 437657 440802 443975 448114 464357 465673 466492 466868 469324 472907 477262 478382 479587 481257 484962 485089 487860 489222 492754 499874 503487 514766 515915 522438 526437 526508 526555 528500 529008 529654 531317 533270 537549 540474 541167 544801 546076 548458 554405 562603 563168 568181 568899 569320 570115 571312 573243 577052 577182 577204 578768 579547 580248 580577 582292 582558 602832 606337 607029 607269 611795 639861 666439 675310 715473 725473 728224 728295 729640 732793 744200 745461 745844 752950 755952 758809 759554 760777 763141 764234 770241 772557 774761 781856 786470 788365 794213 796494 798087 800239 801704 802150 803512 806473 808958 811705 818009 819237 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"чулки большие попы"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"чулк нижн бел большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.