Query Metrics
7
Database Queries
7
Different statements
203.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.43 ms (85.15%) |
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 32585 204794 382213 390133 393339 393342 396288 397679 404180 432052 446621 451261 458920 459226 464716 464877 468786 473020 488669 488776 497470 508457 515110 521518 529301 530279 532339 534907 536711 536713 538996 539026 546510 550101 552951 552996 554795 561124 567462 567939 569457 573385 575398 580466 589324 590378 596545 604084 605691 606714 606755 607062 609909 609965 611924 617294 617312 618525 618734 619011 622858 622991 623960 630240 632984 645149 652282 661935 662905 674381 684012 684335 696617 716987 719040 720395 720883 725743 729538 732354 736068 736304 737594 740817 743138 748042 751735 751748 751751 758486 758523 761740 765196 767181 775018 789798 789821 798982 800258 806281 808670 810210 810265 810271 810575 811166 814154 818544 819193 820512 820989 821433 821484 821487 822231 822288 822353 826309 827888 ] |
||||||||||||||||||||||||||||||
|
19.89 ms (9.77%) |
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 488669 488776 497470 508457 393339 382213 390133 820989 821484 822353 821433 814154 822231 822288 826309 827888 459226 515110 534907 536713 539026 552951 567462 573385 554795 662905 719040 645149 696617 674381 720395 556306 561124 617294 617312 590378 606714 606755 619011 789821 810575 725743 751748 740817 758523 765196 761740 618734 630240 716987 808670 446621 204794 720883 32585 820512 818544 819193 821487 464877 529301 532339 536711 538996 530279 575398 550101 580466 684335 684012 652282 661935 546510 567939 605691 607062 609965 622991 596545 611924 622858 604084 589324 609909 623960 789798 810271 798982 800258 810265 729538 736068 743138 748042 811166 732354 736304 737594 751751 751735 767181 758486 632984 775018 806281 810210 458920 396288 397679 404180 432052 521518 618525 451261 468786 473020 552996 569457 464716 393342 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (1.41%) |
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 32585 204794 382213 390133 393339 393342 396288 397679 404180 432052 446621 451261 458920 459226 464716 464877 468786 473020 488669 488776 497470 508457 515110 521518 529301 530279 532339 534907 536711 536713 538996 539026 546510 550101 552951 552996 554795 561124 567462 567939 569457 573385 575398 580466 589324 590378 596545 604084 605691 606714 606755 607062 609909 609965 611924 617294 617312 618525 618734 619011 622858 622991 623960 630240 632984 645149 652282 661935 662905 674381 684012 684335 696617 716987 719040 720395 720883 725743 729538 732354 736068 736304 737594 740817 743138 748042 751735 751748 751751 758486 758523 761740 765196 767181 775018 789798 789821 798982 800258 806281 808670 810210 810265 810271 810575 811166 814154 818544 819193 820512 820989 821433 821484 821487 822231 822288 822353 826309 827888 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina skinny"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская худые"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.79%) |
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.