Query Metrics
7
Database Queries
7
Different statements
154.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.32 ms (85.24%) |
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 395463 402238 420600 424074 427230 443367 446634 454250 455114 455708 456193 458739 458777 459751 462523 462540 463169 464580 469874 469905 470251 470731 470737 470792 473239 475453 475962 476381 476742 479314 491198 494369 495845 499506 507370 511591 511691 518316 519725 533514 545528 545914 546001 546627 548064 548092 549774 556845 561901 562148 570469 574808 575685 576292 595465 597077 597135 597195 598013 598032 598804 600894 611700 611890 621288 641749 654438 659858 660272 678607 678783 679381 684588 694114 694160 694533 694585 695804 715083 717745 717810 721368 721439 721496 721556 721574 722332 722596 723439 725638 731035 735524 735821 744698 747558 752685 754141 758986 762414 763349 768691 779798 780141 781708 787930 789182 790876 798992 800000 800365 802596 804903 804972 805162 807333 810844 813549 816661 823359 825499 ] |
||||||||||||||||||||||||||||||
|
14.93 ms (9.69%) |
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 575685 721556 717745 641749 597077 780141 800365 763349 731035 747558 762414 545914 598013 476742 462523 463169 519725 562148 598804 473239 455114 470737 443367 455708 464580 475962 494369 816661 717810 659858 779798 545528 546627 548092 598032 462540 470792 499506 721574 823359 825499 660272 678783 723439 694160 722332 595465 597135 611890 790876 758986 802596 804972 725638 744698 715083 402238 469874 518316 574808 549774 556845 576292 597195 424074 458739 459751 454250 456193 476381 470731 511591 491198 533514 600894 546001 470251 813549 570469 561901 654438 679381 684588 694585 694533 721439 722596 548064 621288 800000 810844 787930 798992 735821 754141 789182 395463 469905 611700 427230 458777 475453 420600 495845 511691 721496 807333 781708 805162 479314 678607 768691 804903 446634 752685 735524 507370 695804 721368 694114 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.49%) |
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 395463 402238 420600 424074 427230 443367 446634 454250 455114 455708 456193 458739 458777 459751 462523 462540 463169 464580 469874 469905 470251 470731 470737 470792 473239 475453 475962 476381 476742 479314 491198 494369 495845 499506 507370 511591 511691 518316 519725 533514 545528 545914 546001 546627 548064 548092 549774 556845 561901 562148 570469 574808 575685 576292 595465 597077 597135 597195 598013 598032 598804 600894 611700 611890 621288 641749 654438 659858 660272 678607 678783 679381 684588 694114 694160 694533 694585 695804 715083 717745 717810 721368 721439 721496 721556 721574 722332 722596 723439 725638 731035 735524 735821 744698 747558 752685 754141 758986 762414 763349 768691 779798 780141 781708 787930 789182 790876 798992 800000 800365 802596 804903 804972 805162 807333 810844 813549 816661 823359 825499 ] |
||||||||||||||||||||||||||||||
|
1.54 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ÐÇÐâÐüÐüð║ð░ÐÅ ð┤ðÁð▓ÐâÐêð║ð░ Ðü ð┤ðÁð┤ÐÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск девушк старый"
]
|
||||||||||||||||||||||||||||||
|
1.26 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск девушк старый"
]
|
||||||||||||||||||||||||||||||
|
1.21 ms (0.78%) |
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.