Query Metrics
7
Database Queries
7
Different statements
224.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
194.53 ms (86.54%) |
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 13703 34087 38068 96048 385751 391247 393338 395895 396994 408998 419492 419854 426406 435497 445182 446222 446344 447004 449809 451950 454558 454727 454925 462908 465490 468049 468705 471836 472481 474495 474563 475272 477342 478043 479792 481332 482605 483005 484553 496553 502530 513778 515096 518554 520229 524062 529105 531539 533511 534355 536523 536540 543499 544345 545403 549129 554338 554975 557274 564519 565149 566620 589779 591708 598847 599953 603516 604064 610643 640534 642399 643415 648118 661312 662910 663550 671729 674891 676759 682144 690394 696511 699670 710949 718329 718926 720405 727414 730556 733709 742246 745590 749695 760673 788505 808034 814815 815059 815519 815938 816038 817815 818942 819060 819098 819120 819122 819271 819637 819646 821123 821489 821577 821956 822203 822229 822768 823139 823383 825537 ] |
||||||||||||||||||||||||||||||
|
18.09 ms (8.05%) |
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 733709 742246 727414 730556 745590 749695 760673 710949 788505 808034 13703 393338 395895 96048 435497 426406 419854 465490 472481 482605 484553 446344 447004 454925 475272 483005 449809 454727 462908 481332 518554 496553 520229 524062 536523 529105 531539 536540 564519 565149 543499 554338 557274 566620 598847 642399 599953 640534 643415 408998 445182 446222 471836 474563 391247 468049 474495 478043 419492 451950 454558 468705 477342 479792 502530 385751 34087 38068 396994 815938 816038 819637 819646 823139 825537 815059 821956 822768 814815 818942 819060 819098 819120 819122 819271 821123 822203 815519 817815 821489 821577 822229 823383 515096 513778 534355 533511 544345 554975 545403 549129 671729 676759 682144 699670 648118 662910 674891 690394 696511 718329 661312 663550 718926 720405 589779 591708 603516 604064 610643 ] |
||||||||||||||||||||||||||||||
|
4.43 ms (1.97%) |
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 13703 34087 38068 96048 385751 391247 393338 395895 396994 408998 419492 419854 426406 435497 445182 446222 446344 447004 449809 451950 454558 454727 454925 462908 465490 468049 468705 471836 472481 474495 474563 475272 477342 478043 479792 481332 482605 483005 484553 496553 502530 513778 515096 518554 520229 524062 529105 531539 533511 534355 536523 536540 543499 544345 545403 549129 554338 554975 557274 564519 565149 566620 589779 591708 598847 599953 603516 604064 610643 640534 642399 643415 648118 661312 662910 663550 671729 674891 676759 682144 690394 696511 699670 710949 718329 718926 720405 727414 730556 733709 742246 745590 749695 760673 788505 808034 814815 815059 815519 815938 816038 817815 818942 819060 819098 819120 819122 819271 819637 819646 821123 821489 821577 821956 822203 822229 822768 823139 823383 825537 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (1.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"бассейна"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.68%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бассейн"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.64%) |
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.