Query Metrics
7
Database Queries
7
Different statements
262.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
237.75 ms (90.47%) |
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 382276 404209 404366 416367 417317 418428 427158 429153 429249 434319 443047 443170 443836 443868 446049 446657 447321 449001 449019 450958 451030 451433 458485 459061 462379 464281 464703 467357 470390 474913 475508 477556 478765 479248 489583 499113 508102 508185 514796 523298 524442 524720 525915 528960 531583 536606 538196 538372 540595 547805 554475 556017 560019 561669 562226 562463 562489 565914 566307 566459 566673 568371 568592 569942 570708 573056 576042 590590 590813 593975 594007 594257 597864 599410 602967 605437 605927 606019 615999 623312 623499 653526 654394 655639 660964 669737 677899 678929 679087 679102 679344 686749 696203 699586 709628 712276 716652 721188 728835 742286 747976 752685 759026 765007 766681 777081 778159 778915 782094 783963 786815 790710 794860 801952 802493 802572 814553 818158 821560 825076 ] |
||||||||||||||||||||||||||||||
|
14.43 ms (5.49%) |
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 427158 531583 561669 669737 562226 449001 382276 416367 417317 594007 576042 721188 712276 615999 782094 524720 752685 778915 709628 418428 802493 790710 429249 447321 446049 562489 655639 599410 590590 499113 538196 818158 794860 429153 821560 569942 679344 777081 443170 479248 560019 449019 524442 778159 759026 443047 554475 451433 474913 677899 605927 594257 742286 728835 653526 606019 590813 783963 623312 747976 458485 470390 568592 450958 566307 565914 766681 570708 679087 679102 602967 467357 538372 568371 404366 459061 523298 654394 678929 605437 696203 464703 514796 451030 540595 825076 508102 716652 765007 802572 464281 699586 489583 462379 573056 623499 801952 446657 443836 814553 525915 528960 536606 562463 597864 593975 475508 443868 478765 477556 547805 786815 660964 404209 556017 566673 686749 434319 566459 508185 ] |
||||||||||||||||||||||||||||||
|
4.31 ms (1.64%) |
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 382276 404209 404366 416367 417317 418428 427158 429153 429249 434319 443047 443170 443836 443868 446049 446657 447321 449001 449019 450958 451030 451433 458485 459061 462379 464281 464703 467357 470390 474913 475508 477556 478765 479248 489583 499113 508102 508185 514796 523298 524442 524720 525915 528960 531583 536606 538196 538372 540595 547805 554475 556017 560019 561669 562226 562463 562489 565914 566307 566459 566673 568371 568592 569942 570708 573056 576042 590590 590813 593975 594007 594257 597864 599410 602967 605437 605927 606019 615999 623312 623499 653526 654394 655639 660964 669737 677899 678929 679087 679102 679344 686749 696203 699586 709628 712276 716652 721188 728835 742286 747976 752685 759026 765007 766681 777081 778159 778915 782094 783963 786815 790710 794860 801952 802493 802572 814553 818158 821560 825076 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.67%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"very small girl"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.60%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"very маленькая девушк"
]
|
||||||||||||||||||||||||||||||
|
1.26 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"very маленькая девушк"
]
|
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.