Query Metrics
7
Database Queries
7
Different statements
155.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.33 ms (81.38%) |
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 205910 233987 261074 391597 419652 421514 428552 432478 448892 448900 453682 454852 455693 457631 464298 464678 474249 474305 474310 474622 476207 476703 479758 484777 486877 487013 487581 491403 493470 495296 496665 499291 502214 505344 505537 505739 507181 507215 507747 510049 511670 513022 514047 517538 519912 520284 520835 520994 524823 525342 526985 529777 530183 536296 536559 537319 537359 537483 538679 538751 541106 541465 545636 545788 552078 552881 554439 555508 555522 556501 557463 561975 562010 563103 565112 568325 574449 578185 579454 580221 581999 582791 585663 587120 587206 587445 590512 590524 596539 598842 599255 601742 602184 602753 604198 604645 611280 612265 613859 617805 619425 619591 620591 621734 622464 623930 624426 626251 626395 628343 646167 671887 762705 783492 794944 795271 797072 798836 804554 809282 ] |
||||||||||||||||||||||||||||||
|
18.19 ms (11.72%) |
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 762705 783492 795271 797072 798836 809282 261074 391597 448892 474310 205910 448900 474249 428552 457631 453682 455693 496665 499291 484777 419652 476207 476703 487013 454852 464678 507747 510049 511670 520835 530183 538679 538751 505344 520284 536559 537319 507181 513022 517538 524823 525342 526985 537359 502214 537483 464298 474305 474622 493470 545636 554439 563103 582791 557463 578185 541106 545788 552078 552881 555508 562010 568325 580221 581999 646167 671887 555522 579454 585663 598842 602184 611280 612265 617805 601742 619425 619591 622464 587206 590512 596539 604645 624426 628343 587120 587445 590524 613859 620591 794944 804554 602753 621734 626251 626395 432478 421514 479758 487581 495296 505739 519912 507215 491403 520994 505537 514047 541465 565112 561975 556501 599255 623930 604198 486877 529777 233987 536296 574449 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ"
]
|
||||||||||||||||||||||||||||||
|
2.36 ms (1.52%) |
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 205910 233987 261074 391597 419652 421514 428552 432478 448892 448900 453682 454852 455693 457631 464298 464678 474249 474305 474310 474622 476207 476703 479758 484777 486877 487013 487581 491403 493470 495296 496665 499291 502214 505344 505537 505739 507181 507215 507747 510049 511670 513022 514047 517538 519912 520284 520835 520994 524823 525342 526985 529777 530183 536296 536559 537319 537359 537483 538679 538751 541106 541465 545636 545788 552078 552881 554439 555508 555522 556501 557463 561975 562010 563103 565112 568325 574449 578185 579454 580221 581999 582791 585663 587120 587206 587445 590512 590524 596539 598842 599255 601742 602184 602753 604198 604645 611280 612265 613859 617805 619425 619591 620591 621734 622464 623930 624426 626251 626395 628343 646167 671887 762705 783492 794944 795271 797072 798836 804554 809282 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"груди"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.