Query Metrics
7
Database Queries
7
Different statements
371.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.77 ms (56.73%) |
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 415294 415818 426784 427053 427292 432179 434324 434364 434367 434933 439531 444194 459081 467886 467893 467904 483486 492703 500335 502826 509659 519364 520865 544018 547800 547979 547984 561344 572902 577610 588844 590788 591197 593524 597085 597448 598728 601541 610797 611469 629474 631246 648221 658797 669581 672809 682884 683257 705029 705727 705732 705769 707867 713325 713768 715261 716125 722433 730511 731581 733670 736334 736376 736816 737062 737891 738291 738877 740837 741503 742131 746126 747419 747423 751604 751943 752570 752805 766297 766329 768711 768911 768948 770880 771229 772559 772651 773178 774872 777242 777869 777873 777884 782109 782467 783707 784871 785871 786598 788378 789284 790230 790649 792237 793101 793619 793999 794773 796408 797716 801690 802263 803966 809630 810372 810381 810463 812695 813359 826233 ] |
||||||||||||||||||||||||||||||
|
138.05 ms (37.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 415294 415818 426784 427053 427292 432179 434324 434364 434367 434933 439531 444194 459081 467886 467893 467904 483486 492703 500335 502826 509659 519364 520865 544018 547800 547979 547984 561344 572902 577610 588844 590788 591197 593524 597085 597448 598728 601541 610797 611469 629474 631246 648221 658797 669581 672809 682884 683257 705029 705727 705732 705769 707867 713325 713768 715261 716125 722433 730511 731581 733670 736334 736376 736816 737062 737891 738291 738877 740837 741503 742131 746126 747419 747423 751604 751943 752570 752805 766297 766329 768711 768911 768948 770880 771229 772559 772651 773178 774872 777242 777869 777873 777884 782109 782467 783707 784871 785871 786598 788378 789284 790230 790649 792237 793101 793619 793999 794773 796408 797716 801690 802263 803966 809630 810372 810381 810463 812695 813359 826233 ] |
||||||||||||||||||||||||||||||
|
15.85 ms (4.26%) |
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 705732 544018 547984 648221 669581 715261 610797 593524 786598 788378 801690 790649 737062 747423 751604 770880 772651 768711 738877 752805 766329 768911 733670 747419 766297 713325 722433 777873 794773 803966 672809 598728 731581 713768 427053 591197 459081 611469 432179 439531 467893 427292 434364 444194 500335 601541 572902 415818 707867 588844 826233 509659 547979 577610 682884 705029 705727 716125 705769 597448 629474 774872 777242 792237 802263 777869 777884 789284 793619 796408 730511 736334 737891 740837 741503 751943 772559 782109 790230 793101 793999 809630 736816 738291 742131 752570 771229 773178 768948 736376 782467 783707 797716 810372 810381 810463 812695 813359 426784 520865 561344 547800 658797 590788 785871 746126 784871 467886 415294 434324 467904 434367 434933 492703 519364 502826 483486 683257 597085 631246 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"женские оргазмы русск…"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (0.53%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"женск оргазм русск"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.39%) |
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.