Query Metrics
7
Database Queries
7
Different statements
199.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.97 ms (89.30%) |
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 13527 116626 149612 233198 366044 386128 386266 389841 390282 392572 397151 454141 454552 457649 467486 474985 478103 486111 506567 511534 533659 535617 536066 536157 539603 543956 545869 545871 547056 547120 548321 548755 550683 553183 553545 557977 567936 567974 584375 589731 601551 602965 618629 625502 628026 637630 643214 645335 662064 691846 697707 698618 698932 701278 702355 702379 712666 720664 721947 722298 730687 730829 731771 732994 733508 734618 744764 746403 747629 748469 751381 753781 754002 759854 762050 765880 765962 765963 766394 766490 768967 782289 789639 789696 790088 801381 814541 814588 814592 814594 816175 817421 817459 818265 818755 818963 819818 819912 820317 823270 824176 824269 825165 826058 826443 826769 827999 828032 828055 828106 828150 828192 828281 828364 828608 828719 828732 828830 ] |
||||||||||||||||||||||||||||||
|
10.70 ms (5.37%) |
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 814541 814592 818755 828106 828830 828055 828192 828032 474985 478103 535617 533659 536066 550683 547056 567936 545871 701278 722298 744764 730829 733508 765963 766490 768967 731771 734618 748469 702355 486111 511534 557977 548755 553545 601551 589731 454552 457649 454141 467486 386266 233198 824821 826058 817421 819818 819912 825165 826443 826769 814594 823270 824176 824269 827999 828150 828732 828364 828281 828719 828608 539603 567974 545869 584375 543956 553183 662064 691846 697707 698932 712666 720664 721947 547120 548321 618629 602965 637630 643214 789696 732994 782289 790088 762050 766394 765880 730687 751381 759854 765962 746403 625502 628026 702379 789639 801381 392572 386128 366044 754002 149612 506567 116626 536157 645335 698618 747629 753781 13527 389841 390282 397151 816175 817459 818265 818963 820317 824261 814588 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.44%) |
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 13527 116626 149612 233198 366044 386128 386266 389841 390282 392572 397151 454141 454552 457649 467486 474985 478103 486111 506567 511534 533659 535617 536066 536157 539603 543956 545869 545871 547056 547120 548321 548755 550683 553183 553545 557977 567936 567974 584375 589731 601551 602965 618629 625502 628026 637630 643214 645335 662064 691846 697707 698618 698932 701278 702355 702379 712666 720664 721947 722298 730687 730829 731771 732994 733508 734618 744764 746403 747629 748469 751381 753781 754002 759854 762050 765880 765962 765963 766394 766490 768967 782289 789639 789696 790088 801381 814541 814588 814592 814594 816175 817421 817459 818265 818755 818963 819818 819912 820317 823270 824176 824269 825165 826058 826443 826769 827999 828032 828055 828106 828150 828192 828281 828364 828608 828719 828732 828830 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скрыт камер"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"скрыто камера"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.87%) |
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.