Query Metrics
7
Database Queries
7
Different statements
400.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.10 ms (50.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big lingerie"
]
|
||||||||||||||||||||||||||||||
|
175.55 ms (43.84%) |
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 181242 181544 384140 386764 386939 387281 389864 391026 401027 438369 443911 445016 447815 451161 457024 457200 463672 464631 465208 465878 465907 467359 469324 478113 483106 491984 492373 497077 499793 500542 506646 508590 509673 514731 515586 516006 517812 520939 521607 524594 528462 534741 535427 535543 540145 551251 556927 564979 568331 577728 578333 583230 599492 604918 622416 624286 634711 642855 648776 655515 661572 663263 675085 675122 675713 677329 686416 696748 701552 702632 711569 716055 716103 717663 718054 724341 724734 726777 726975 729836 731177 735678 735752 736152 738058 739961 749379 753492 755399 756388 756522 757365 760681 760686 760687 760801 767752 768401 769733 772017 774573 775202 780066 783206 783332 783344 786842 791455 792002 792682 807491 810289 811496 812448 813178 814412 815107 816158 817571 819272 ] |
||||||||||||||||||||||||||||||
|
13.64 ms (3.41%) |
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 648776 655515 718054 577728 624286 634711 599492 642855 810289 807491 731177 756522 760801 739961 755399 735752 760686 749379 389864 384140 181242 469324 528462 492373 540145 386764 443911 457200 457024 451161 517812 500542 520939 534741 524594 535427 583230 677329 686416 663263 716103 551251 604918 812448 774573 780066 783332 792002 724734 783206 791455 792682 753492 760687 767752 769733 724341 768401 756388 760681 786842 813178 447815 467359 391026 465878 478113 506646 514731 483106 509673 497077 499793 515586 521607 181544 386939 817571 661572 675085 675713 675122 701552 702632 716055 556927 622416 775202 783344 726975 729836 735678 772017 738058 696748 717663 491984 463672 387281 464631 811496 438369 508590 516006 535543 578333 711569 736152 757365 726777 445016 465907 465208 401027 814412 815107 819272 816158 568331 564979 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (0.70%) |
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 181242 181544 384140 386764 386939 387281 389864 391026 401027 438369 443911 445016 447815 451161 457024 457200 463672 464631 465208 465878 465907 467359 469324 478113 483106 491984 492373 497077 499793 500542 506646 508590 509673 514731 515586 516006 517812 520939 521607 524594 528462 534741 535427 535543 540145 551251 556927 564979 568331 577728 578333 583230 599492 604918 622416 624286 634711 642855 648776 655515 661572 663263 675085 675122 675713 677329 686416 696748 701552 702632 711569 716055 716103 717663 718054 724341 724734 726777 726975 729836 731177 735678 735752 736152 738058 739961 749379 753492 755399 756388 756522 757365 760681 760686 760687 760801 767752 768401 769733 772017 774573 775202 780066 783206 783332 783344 786842 791455 792002 792682 807491 810289 811496 812448 813178 814412 815107 816158 817571 819272 ] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие lingerie"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие lingerie"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.34%) |
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.