Query Metrics
7
Database Queries
7
Different statements
149.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.26 ms (81.73%) |
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 81734 108925 182118 391754 391945 391961 397186 398106 399083 414071 414157 418112 419454 424219 429600 429900 434309 434367 435537 440708 440723 441925 443249 443257 445323 446022 446695 449020 455078 458115 464815 465670 467089 468165 468482 468813 469096 469139 469463 476671 477757 477759 479530 483523 483731 485468 493411 493535 493825 494481 494495 499919 511005 513842 514254 522020 527224 530429 530765 530784 531403 532729 532854 540575 541836 541851 544964 545454 547237 547485 548464 550282 558098 568379 576981 585977 590281 592384 594491 600269 600719 604523 604890 629808 631616 632094 632121 635224 636955 639782 650476 660359 669012 680484 692711 713505 733582 745341 747468 749219 749254 752644 752668 752672 756192 758778 782653 782804 782806 786876 786906 796319 804674 805120 806793 813605 814270 815559 817192 818387 ] |
||||||||||||||||||||||||||||||
|
17.14 ms (11.46%) |
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 752668 443249 429600 440708 458115 476671 477759 493825 464815 600719 805120 446022 434309 455078 418112 414071 446695 532729 545454 547237 544964 550282 594491 629808 782804 756192 747468 632121 806793 399083 391945 440723 434367 108925 81734 493535 468482 547485 541851 590281 530784 604890 817192 635224 796319 397186 568379 443257 468165 494481 541836 680484 493411 604523 429900 745341 804674 467089 449020 530429 530765 532854 540575 669012 419454 445323 522020 813605 636955 632094 585977 424219 469463 391754 511005 494495 499919 558098 576981 468813 441925 414157 650476 631616 398106 479530 391961 469139 477757 592384 527224 435537 814270 818387 815559 483731 485468 514254 531403 469096 548464 660359 692711 713505 600269 639782 782653 782806 786906 733582 752672 749219 749254 752644 758778 786876 465670 513842 483523 182118 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.87%) |
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 81734 108925 182118 391754 391945 391961 397186 398106 399083 414071 414157 418112 419454 424219 429600 429900 434309 434367 435537 440708 440723 441925 443249 443257 445323 446022 446695 449020 455078 458115 464815 465670 467089 468165 468482 468813 469096 469139 469463 476671 477757 477759 479530 483523 483731 485468 493411 493535 493825 494481 494495 499919 511005 513842 514254 522020 527224 530429 530765 530784 531403 532729 532854 540575 541836 541851 544964 545454 547237 547485 548464 550282 558098 568379 576981 585977 590281 592384 594491 600269 600719 604523 604890 629808 631616 632094 632121 635224 636955 639782 650476 660359 669012 680484 692711 713505 733582 745341 747468 749219 749254 752644 752668 752672 756192 758778 782653 782804 782806 786876 786906 796319 804674 805120 806793 813605 814270 815559 817192 818387 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo anal milf"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд анал milf"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.06%) |
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.