Query Metrics
7
Database Queries
7
Different statements
388.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
216.79 ms (55.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов close up"
]
|
||||||||||||||||||||||||||||||
|
147.95 ms (38.11%) |
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 386685 419173 422447 438335 441747 442497 444848 449514 450929 466553 473409 489155 495822 496880 498705 503069 513822 526945 529124 533395 534518 553244 558265 578171 582931 589881 591186 591822 594366 606981 613895 616438 622984 631044 636925 637481 647108 650099 650565 656147 656208 668788 670064 672680 676660 676673 681926 690461 696373 696374 700716 705383 707412 707512 707690 714400 715575 717885 721650 727500 731517 737891 743989 750203 757914 758008 760266 761307 761354 763431 764763 765385 765927 770340 772371 773761 778476 778641 779002 779889 780238 781110 781268 781441 782418 784547 785585 786008 786939 787946 790777 791784 792201 793084 793165 793859 794590 795795 796034 796037 796346 796458 798750 799843 800165 801714 803782 804806 805654 809337 809638 816136 818837 819021 819023 820857 822475 825458 827441 828698 ] |
||||||||||||||||||||||||||||||
|
14.65 ms (3.77%) |
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 781110 796458 727500 765385 792201 773761 820857 750203 489155 690461 793165 798750 790777 496880 533395 498705 578171 696374 707512 650565 656147 676673 636925 637481 594366 616438 786939 779889 780238 793084 799843 809337 764763 761354 782418 787946 450929 705383 796037 781268 793859 717885 449514 534518 438335 816136 631044 715575 819021 529124 495822 553244 681926 700716 650099 676660 647108 672680 696373 795795 801714 781441 757914 441747 721650 589881 804806 784547 786008 796034 800165 772371 743989 770340 778641 818837 819023 606981 761307 419173 473409 785585 796346 442497 503069 513822 558265 582931 668788 670064 656208 591186 613895 591822 791784 794590 805654 763431 765927 779002 809638 422447 444848 466553 526945 707690 731517 386685 707412 714400 778476 803782 737891 758008 760266 827441 822475 825458 828698 622984 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (0.82%) |
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 386685 419173 422447 438335 441747 442497 444848 449514 450929 466553 473409 489155 495822 496880 498705 503069 513822 526945 529124 533395 534518 553244 558265 578171 582931 589881 591186 591822 594366 606981 613895 616438 622984 631044 636925 637481 647108 650099 650565 656147 656208 668788 670064 672680 676660 676673 681926 690461 696373 696374 700716 705383 707412 707512 707690 714400 715575 717885 721650 727500 731517 737891 743989 750203 757914 758008 760266 761307 761354 763431 764763 765385 765927 770340 772371 773761 778476 778641 779002 779889 780238 781110 781268 781441 782418 784547 785585 786008 786939 787946 790777 791784 792201 793084 793165 793859 794590 795795 796034 796037 796346 796458 798750 799843 800165 801714 803782 804806 805654 809337 809638 816136 818837 819021 819023 820857 822475 825458 827441 828698 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.53%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов close up"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov close up"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.44%) |
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.