Query Metrics
7
Database Queries
7
Different statements
351.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.40 ms (58.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
124.90 ms (35.51%) |
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 118436 151179 248347 388183 388696 390587 391994 408880 414050 414253 414595 419822 422676 441160 444540 452815 453223 465454 466476 467952 470403 471682 473213 475335 475336 477055 479723 497693 500787 505143 519700 530021 531347 531844 534114 534530 534545 534546 534563 537861 540868 541451 544829 545395 545411 546202 547502 548723 550919 550922 553224 553646 564293 576479 580188 580189 583713 595145 598115 604412 609920 612070 613000 615983 628113 634106 637544 648710 660364 660367 660380 669046 674043 696594 696596 696607 711615 717859 718772 722388 725400 728540 735703 738483 740409 745088 745106 749090 750426 751609 752634 752648 752670 752677 752679 754902 758785 758786 761608 762222 767208 770814 775184 777039 778393 782854 785589 788908 788953 794669 795404 796333 796675 796703 800538 801620 803122 804306 808746 817173 ] |
||||||||||||||||||||||||||||||
|
15.18 ms (4.32%) |
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 465454 473213 531844 537861 505143 497693 500787 475335 475336 477055 544829 550922 564293 545395 547502 553646 583713 711615 546202 595145 800538 762222 728540 804306 388696 414050 248347 422676 452815 151179 390587 408880 414595 444540 414253 540868 817173 453223 479723 471682 534530 534545 534546 530021 534114 534563 519700 545411 580189 541451 550919 576479 580188 648710 660367 660380 669046 718772 660364 696594 696607 717859 674043 696596 548723 553224 613000 634106 598115 604412 615983 609920 628113 637544 785589 795404 796703 801620 777039 782854 794669 796333 749090 767208 770814 808746 740409 750426 752679 758785 738483 745088 745106 752677 758786 725400 735703 751609 761608 752634 752648 752670 754902 612070 722388 775184 778393 788908 796675 803122 391994 419822 441160 388183 466476 118436 470403 467952 531347 788953 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (0.73%) |
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 118436 151179 248347 388183 388696 390587 391994 408880 414050 414253 414595 419822 422676 441160 444540 452815 453223 465454 466476 467952 470403 471682 473213 475335 475336 477055 479723 497693 500787 505143 519700 530021 531347 531844 534114 534530 534545 534546 534563 537861 540868 541451 544829 545395 545411 546202 547502 548723 550919 550922 553224 553646 564293 576479 580188 580189 583713 595145 598115 604412 609920 612070 613000 615983 628113 634106 637544 648710 660364 660367 660380 669046 674043 696594 696596 696607 711615 717859 718772 722388 725400 728540 735703 738483 740409 745088 745106 749090 750426 751609 752634 752648 752670 752677 752679 754902 758785 758786 761608 762222 767208 770814 775184 777039 778393 782854 785589 788908 788953 794669 795404 796333 796675 796703 800538 801620 803122 804306 808746 817173 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge anal"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные анал"
]
|
||||||||||||||||||||||||||||||
|
1.23 ms (0.35%) |
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.