Query Metrics
7
Database Queries
7
Different statements
193.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.79 ms (88.60%) |
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 35091 45868 45985 88220 310725 382074 382462 382465 382898 383455 384521 387146 393108 395398 395653 395699 396312 397161 399187 399632 401251 401541 402047 402530 406847 406957 406969 407890 408414 409125 409224 414753 415889 418135 419838 419892 420262 423319 424548 425630 429739 430245 438009 442236 442296 445046 452921 457816 463826 465673 466457 468155 468800 472180 476206 481659 484969 490166 490826 493265 504155 504339 508236 509164 510589 518814 519570 520633 521024 522200 528394 529654 531521 534260 537165 539644 562881 567743 568062 569035 570730 598550 602363 607289 619490 623945 634876 673987 681122 683066 684198 696140 702819 721778 723592 726236 730235 730977 737522 744642 744860 752864 753007 754598 756239 760684 760800 768606 770031 774736 774738 781464 785094 787073 789705 790028 799386 800939 803766 810604 ] |
||||||||||||||||||||||||||||||
|
12.95 ms (6.68%) |
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 810604 726236 752864 754598 768606 730977 753007 760684 770031 619490 634876 774736 774738 789705 790028 799386 800939 803766 382462 382465 387146 310725 397161 383455 396312 401541 406847 415889 463826 490826 522200 465673 569035 570730 681122 702819 673987 683066 684198 696140 721778 562881 598550 607289 623945 781464 787073 737522 756239 760800 730235 744860 744642 602363 785094 35091 88220 382074 382898 399187 401251 402530 407890 419838 429739 468155 481659 45868 45985 402047 408414 409125 452921 384521 395653 406957 409224 457816 476206 406969 414753 424548 442296 472180 520633 490166 518814 521024 420262 568062 567743 508236 509164 510589 393108 395398 395699 399632 425630 438009 418135 430245 442236 445046 419892 423319 723592 466457 468800 484969 493265 519570 528394 529654 539644 504339 531521 534260 537165 504155 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.33%) |
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 35091 45868 45985 88220 310725 382074 382462 382465 382898 383455 384521 387146 393108 395398 395653 395699 396312 397161 399187 399632 401251 401541 402047 402530 406847 406957 406969 407890 408414 409125 409224 414753 415889 418135 419838 419892 420262 423319 424548 425630 429739 430245 438009 442236 442296 445046 452921 457816 463826 465673 466457 468155 468800 472180 476206 481659 484969 490166 490826 493265 504155 504339 508236 509164 510589 518814 519570 520633 521024 522200 528394 529654 531521 534260 537165 539644 562881 567743 568062 569035 570730 598550 602363 607289 619490 623945 634876 673987 681122 683066 684198 696140 702819 721778 723592 726236 730235 730977 737522 744642 744860 752864 753007 754598 756239 760684 760800 768606 770031 774736 774738 781464 785094 787073 789705 790028 799386 800939 803766 810604 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"красивую милфу"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая милф"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.74%) |
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.