Query Metrics
7
Database Queries
7
Different statements
143.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.18 ms (85.13%) |
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 6626 383341 387200 387399 392611 417707 453471 454457 456125 456955 457289 463178 463984 473291 482846 491681 491853 496311 496571 497660 501280 504101 508648 509784 510145 516391 516995 518410 525642 528899 530082 532189 540346 540443 540637 542475 542621 543683 551221 554441 554751 555092 560493 568142 569087 578401 581028 582218 584709 588285 589358 589799 590606 592146 595086 603959 606114 606792 606798 611413 611954 612990 614455 616839 628772 630064 631136 647282 650935 655799 662480 669566 689266 691223 692824 693174 695662 695665 696052 701604 702476 705368 710323 711320 711548 714040 714572 721954 727391 728276 731031 731147 732584 734429 744596 745074 747941 749860 753761 763932 764381 769423 797858 802217 806684 815455 818925 819793 820426 822578 823642 824539 827405 828126 828221 828249 828382 ] |
||||||||||||||||||||||||||||||
|
11.79 ms (8.22%) |
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 753761 473291 463178 589358 606792 763932 482846 518410 818925 828382 392611 491681 540443 542475 551221 560493 689266 692824 714040 647282 695665 711548 606114 603959 590606 611413 731031 749860 764381 732584 745074 728276 731147 611954 501280 453471 457289 463984 456955 554441 508648 496311 554751 595086 509784 797858 769423 710323 721954 387200 669566 747941 806684 578401 582218 824539 828249 6626 417707 516995 383341 504101 696052 616839 631136 592146 387399 530082 630064 820426 510145 532189 525642 542621 543683 693174 691223 612990 727391 588285 581028 589799 628772 711320 695662 662480 650935 614455 734429 701604 456125 568142 497660 827405 655799 555092 802217 744596 705368 491853 822666 815455 823062 714572 702476 454457 540346 569087 516391 528899 496571 584709 606798 540637 819793 823642 822578 823697 828221 828126 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.79%) |
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 6626 383341 387200 387399 392611 417707 453471 454457 456125 456955 457289 463178 463984 473291 482846 491681 491853 496311 496571 497660 501280 504101 508648 509784 510145 516391 516995 518410 525642 528899 530082 532189 540346 540443 540637 542475 542621 543683 551221 554441 554751 555092 560493 568142 569087 578401 581028 582218 584709 588285 589358 589799 590606 592146 595086 603959 606114 606792 606798 611413 611954 612990 614455 616839 628772 630064 631136 647282 650935 655799 662480 669566 689266 691223 692824 693174 695662 695665 696052 701604 702476 705368 710323 711320 711548 714040 714572 721954 727391 728276 731031 731147 732584 734429 744596 745074 747941 749860 753761 763932 764381 769423 797858 802217 806684 815455 818925 819793 820426 822578 823642 824539 827405 828126 828221 828249 828382 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public big cock"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на улиц большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.09%) |
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.