Query Metrics
7
Database Queries
7
Different statements
182.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.37 ms (85.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 394490 417400 424038 432745 434488 435412 442524 444911 456594 459635 459650 460378 461306 464800 464895 467895 478508 480718 480823 482139 482633 487429 487987 492355 499083 500308 500332 505140 505327 511944 513899 530395 533276 541322 542306 555387 558582 559996 564222 564557 568493 575943 596796 602293 604226 604291 609343 616790 618021 619828 626684 632123 633241 639184 648669 655159 657543 674475 680215 685061 685832 685843 687844 692817 695882 704584 705769 707452 717291 721249 721875 733450 735772 744952 749598 752620 756849 756990 757435 758790 759005 761599 761711 767116 767149 767786 773351 776264 777742 783743 784770 785366 785553 787510 788147 790632 791846 792078 794759 795544 796194 796879 797178 799947 800353 800471 800513 801737 803394 803504 804249 806947 808101 809825 810076 824164 824362 824868 827282 827326 ] |
||||||||||||||||||||||||||||||
|
15.88 ms (8.71%) |
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 791846 604226 674475 721249 619828 827282 685832 456594 533276 530395 695882 707452 783743 785553 756849 794759 492355 424038 444911 824362 459650 499083 564222 648669 655159 685843 633241 790632 801737 761599 796194 797178 810076 759005 735772 761711 704584 785366 705769 487987 799947 500308 487429 692817 796879 756990 434488 824868 824164 680215 776264 800471 784770 788147 795544 804249 687844 564557 618021 777742 808101 767786 757435 721875 568493 744952 800353 559996 609343 467895 459635 792078 500332 394490 480718 604291 575943 749598 773351 639184 417400 432745 827326 482139 482633 505140 505327 511944 541322 542306 685061 717291 596796 602293 787510 803394 806947 758790 767116 767149 809825 480823 435412 803504 800513 555387 478508 733450 464800 558582 626684 752620 464895 442524 461306 513899 460378 657543 616790 632123 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.42%) |
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 394490 417400 424038 432745 434488 435412 442524 444911 456594 459635 459650 460378 461306 464800 464895 467895 478508 480718 480823 482139 482633 487429 487987 492355 499083 500308 500332 505140 505327 511944 513899 530395 533276 541322 542306 555387 558582 559996 564222 564557 568493 575943 596796 602293 604226 604291 609343 616790 618021 619828 626684 632123 633241 639184 648669 655159 657543 674475 680215 685061 685832 685843 687844 692817 695882 704584 705769 707452 717291 721249 721875 733450 735772 744952 749598 752620 756849 756990 757435 758790 759005 761599 761711 767116 767149 767786 773351 776264 777742 783743 784770 785366 785553 787510 788147 790632 791846 792078 794759 795544 796194 796879 797178 799947 800353 800471 800513 801737 803394 803504 804249 806947 808101 809825 810076 824164 824362 824868 827282 827326 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal orgasm wife"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал orgasm жен"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал orgasm жен"
]
|
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.