Query Metrics
7
Database Queries
7
Different statements
158.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.47 ms (82.75%) |
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 95986 154157 195768 346188 391668 400791 403319 414292 416697 420658 427745 439514 448431 456240 457474 462377 464499 466475 469691 473745 476674 484809 493535 494481 510811 511864 512543 512928 515571 519816 520797 525603 526005 526179 527409 529794 530378 531107 531871 533042 534586 536466 536576 537269 538817 541278 544850 545369 548445 548857 550813 550900 550930 573202 574951 578642 583665 583921 584362 591021 599880 609885 617807 619281 620648 622693 625783 627491 630798 632121 632623 634098 635975 639753 639767 641791 641996 643100 650344 660399 662046 662423 669362 671520 672939 672954 673035 679093 680195 693925 693927 694063 713194 713505 722393 722520 735128 735132 735133 735260 737605 738814 738827 744939 748961 752689 758332 761429 761646 774912 782108 788555 792706 801610 806543 816371 816722 818825 824441 825027 ] |
||||||||||||||||||||||||||||||
|
18.12 ms (11.40%) |
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 662423 533042 599880 635975 639767 641996 680195 400791 403319 414292 457474 464499 515571 538817 541278 574951 660399 672954 693925 643100 639753 738814 748961 632623 801610 462377 456240 527409 95986 416697 511864 534586 525603 526179 512543 548445 583665 584362 662046 672939 713505 619281 466475 469691 494481 622693 484809 625783 439514 520797 493535 531107 583921 391668 427745 526005 154157 195768 346188 818825 824441 825027 537269 510811 531871 550930 544850 550900 573202 722520 650344 671520 679093 693927 713194 548857 550813 641791 630798 627491 788555 806543 761646 782108 735128 737605 735133 752689 735260 758332 617807 722393 792706 529794 816722 816371 473745 476674 536576 519816 545369 669362 673035 694063 578642 591021 609885 634098 620648 774912 761429 738827 744939 735132 632121 448431 420658 530378 536466 512928 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.59%) |
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 95986 154157 195768 346188 391668 400791 403319 414292 416697 420658 427745 439514 448431 456240 457474 462377 464499 466475 469691 473745 476674 484809 493535 494481 510811 511864 512543 512928 515571 519816 520797 525603 526005 526179 527409 529794 530378 531107 531871 533042 534586 536466 536576 537269 538817 541278 544850 545369 548445 548857 550813 550900 550930 573202 574951 578642 583665 583921 584362 591021 599880 609885 617807 619281 620648 622693 625783 627491 630798 632121 632623 634098 635975 639753 639767 641791 641996 643100 650344 660399 662046 662423 669362 671520 672939 672954 673035 679093 680195 693925 693927 694063 713194 713505 722393 722520 735128 735132 735133 735260 737605 738814 738827 744939 748961 752689 758332 761429 761646 774912 782108 788555 792706 801610 806543 816371 816722 818825 824441 825027 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"фистинг чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fisting stockings"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фистинг чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.91%) |
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.