Query Metrics
7
Database Queries
7
Different statements
587.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
346.87 ms (59.03%) |
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 134454 142253 386194 392744 395639 395824 396709 400169 400249 401969 402680 418346 428523 469338 469914 501338 501785 511011 515134 517101 522532 524635 528181 529612 532344 532717 540089 541108 543095 543401 552330 559715 565364 569140 574828 576046 576337 583819 603572 619585 641744 644656 648852 649139 649837 650833 650852 652172 652865 654094 654481 654574 654765 655994 656677 657571 659504 659589 670112 672584 675043 675936 676146 676283 676522 676889 676907 678576 679061 679078 679079 681002 681022 684369 688100 689310 691497 692330 693188 694557 697494 697761 699531 705893 718919 721792 724330 740392 742876 743053 744588 745208 749269 752183 756433 758599 762221 767190 770314 771723 775926 787914 788669 788921 793175 797578 797799 799246 801474 804188 807928 811181 817341 818374 819176 821484 821857 822003 822052 823419 ] |
||||||||||||||||||||||||||||||
|
216.46 ms (36.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая секс втро"
]
|
||||||||||||||||||||||||||||||
|
14.48 ms (2.46%) |
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 762221 395824 676889 676907 134454 401969 822003 676522 649139 775926 743053 418346 552330 559715 576337 676283 724330 770314 469914 517101 469338 501338 428523 392744 818374 540089 543095 657571 649837 676146 692330 652865 697494 641744 758599 804188 752183 756433 742876 745208 721792 788669 386194 142253 565364 583819 515134 400169 511011 543401 574828 569140 672584 675936 652172 670112 650833 793175 740392 797799 395639 402680 501785 524635 396709 817341 532344 654574 678576 679061 679078 679079 648852 650852 691497 699531 656677 689310 694557 788921 797578 749269 771723 697761 400249 522532 529612 576046 541108 807928 528181 821484 822052 823419 819176 821857 532717 654094 654481 655994 659589 705893 718919 659504 681022 684369 688100 654765 675043 681002 693188 619585 644656 603572 787914 801474 811181 799246 744588 767190 ] |
||||||||||||||||||||||||||||||
|
3.87 ms (0.66%) |
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 134454 142253 386194 392744 395639 395824 396709 400169 400249 401969 402680 418346 428523 469338 469914 501338 501785 511011 515134 517101 522532 524635 528181 529612 532344 532717 540089 541108 543095 543401 552330 559715 565364 569140 574828 576046 576337 583819 603572 619585 641744 644656 648852 649139 649837 650833 650852 652172 652865 654094 654481 654574 654765 655994 656677 657571 659504 659589 670112 672584 675043 675936 676146 676283 676522 676889 676907 678576 679061 679078 679079 681002 681022 684369 688100 689310 691497 692330 693188 694557 697494 697761 699531 705893 718919 721792 724330 740392 742876 743053 744588 745208 749269 752183 756433 758599 762221 767190 770314 771723 775926 787914 788669 788921 793175 797578 797799 799246 801474 804188 807928 811181 817341 818374 819176 821484 821857 822003 822052 823419 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful threesome"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.