Query Metrics
7
Database Queries
7
Different statements
179.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.31 ms (86.11%) |
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 3483 154535 340635 382392 385380 386627 391993 397225 398290 405816 429705 433556 436021 443804 449596 450272 454133 460465 464987 466389 468912 469127 469171 471006 473410 476711 483334 491431 494247 511407 516718 517222 517441 526541 533723 535336 535616 537167 541847 544322 545375 547858 554324 567718 574768 576176 577182 578682 580900 581195 581381 586189 586404 587181 589140 596033 596694 602063 603119 603345 603390 604998 605096 606813 606945 609644 613577 613647 614787 617713 623300 628518 643126 645835 645928 646865 697284 697461 697543 710585 711651 720478 723674 728036 731806 740141 740153 744807 745485 750885 754299 758279 760725 762191 770167 770190 771867 772547 774773 776819 777721 781320 782618 786948 790731 801833 802071 802388 803129 803146 806928 806955 808979 816168 817587 819229 819247 819250 819766 826498 ] |
||||||||||||||||||||||||||||||
|
14.94 ms (8.34%) |
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 606813 770167 728036 754299 535616 586189 533723 645835 603119 603345 731806 603390 454133 535336 614787 385380 473410 516718 469127 466389 613647 3483 801833 468912 578682 605096 405816 450272 537167 483334 494247 544322 398290 476711 777721 436021 391993 554324 433556 464987 471006 460465 469171 397225 586404 587181 511407 589140 491431 771867 602063 382392 817587 819250 819247 819229 819766 580900 581381 646865 710585 697461 604998 774773 790731 802388 740153 744807 750885 760725 617713 786948 803146 781320 776819 816168 574768 826498 517441 547858 576176 567718 581195 541847 645928 720478 697284 697543 596033 628518 613577 782618 806955 808979 745485 772547 806928 723674 770190 740141 758279 606945 609644 711651 802071 443804 154535 803129 386627 449596 517222 545375 596694 623300 643126 762191 340635 429705 526541 577182 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.50%) |
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 3483 154535 340635 382392 385380 386627 391993 397225 398290 405816 429705 433556 436021 443804 449596 450272 454133 460465 464987 466389 468912 469127 469171 471006 473410 476711 483334 491431 494247 511407 516718 517222 517441 526541 533723 535336 535616 537167 541847 544322 545375 547858 554324 567718 574768 576176 577182 578682 580900 581195 581381 586189 586404 587181 589140 596033 596694 602063 603119 603345 603390 604998 605096 606813 606945 609644 613577 613647 614787 617713 623300 628518 643126 645835 645928 646865 697284 697461 697543 710585 711651 720478 723674 728036 731806 740141 740153 744807 745485 750885 754299 758279 760725 762191 770167 770190 771867 772547 774773 776819 777721 781320 782618 786948 790731 801833 802071 802388 803129 803146 806928 806955 808979 816168 817587 819229 819247 819250 819766 826498 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf stockings solo"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf чулк нижн бел соло"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf чулк нижн бел соло"
]
|
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.