Query Metrics
7
Database Queries
7
Different statements
162.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.08 ms (81.93%) |
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 7178 310672 379559 398800 400852 401014 401456 401666 402375 404742 405175 407019 408383 411307 414421 414643 418320 419370 421043 423299 426475 427091 427487 428778 433473 440339 444208 446110 453735 457890 461402 462915 464139 468581 468667 469616 470166 471809 475487 476136 482559 482583 483189 484715 485363 485621 486768 489831 491276 491429 493838 499919 502043 504102 504211 510815 511944 513114 513817 515370 517074 517725 517743 517807 519578 522867 528163 531137 535016 536887 541074 544747 554752 557268 561134 563864 564731 568560 573320 586456 588684 596075 601553 604313 608569 612816 613122 619482 637650 647656 647882 656206 683003 683826 689735 704928 714630 718701 718784 725581 741291 741607 744654 747310 751510 751611 752759 756246 758468 767175 770402 770520 777544 784569 795538 800288 803086 805222 805431 806686 ] |
||||||||||||||||||||||||||||||
|
19.08 ms (11.75%) |
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 531137 499919 511944 513817 461402 486768 563864 564731 573320 544747 568560 683003 718784 647882 683826 714630 689735 704928 718701 554752 608569 612816 613122 604313 586456 601553 619482 795538 805222 805431 800288 806686 751611 758468 741607 756246 767175 747310 752759 725581 741291 744654 751510 770520 777544 379559 414421 468581 7178 398800 401666 402375 418320 427091 310672 401014 427487 444208 414643 453735 513114 485363 493838 404742 433473 510815 469616 482559 489831 485621 541074 596075 637650 803086 400852 407019 440339 470166 475487 484715 491429 517807 482583 536887 656206 557268 784569 770402 464139 517743 502043 647656 535016 419370 411307 408383 462915 504211 471809 561134 588684 401456 476136 457890 405175 428778 421043 446110 468667 504102 517725 522867 483189 519578 517074 491276 515370 528163 426475 423299 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.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 7178 310672 379559 398800 400852 401014 401456 401666 402375 404742 405175 407019 408383 411307 414421 414643 418320 419370 421043 423299 426475 427091 427487 428778 433473 440339 444208 446110 453735 457890 461402 462915 464139 468581 468667 469616 470166 471809 475487 476136 482559 482583 483189 484715 485363 485621 486768 489831 491276 491429 493838 499919 502043 504102 504211 510815 511944 513114 513817 515370 517074 517725 517743 517807 519578 522867 528163 531137 535016 536887 541074 544747 554752 557268 561134 563864 564731 568560 573320 586456 588684 596075 601553 604313 608569 612816 613122 619482 637650 647656 647882 656206 683003 683826 689735 704928 714630 718701 718784 725581 741291 741607 744654 747310 751510 751611 752759 756246 758468 767175 770402 770520 777544 784569 795538 800288 803086 805222 805431 806686 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature красивая анал"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature beautiful anal"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature красивая анал"
]
|
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.