Query Metrics
7
Database Queries
7
Different statements
189.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.68 ms (88.47%) |
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 397883 418277 421836 421873 424120 424124 426864 440645 443711 443747 448975 455318 456000 456062 460601 462082 462489 463159 463173 464548 465367 465970 466368 466890 468355 477114 478377 486578 490741 492619 493195 506084 512001 513374 515720 516478 516480 516485 516787 516792 518335 519415 519672 519838 522711 523834 523836 524944 536434 537020 538005 538603 540746 544103 547762 547909 555093 558610 560319 562708 567076 568715 569299 569411 572203 582548 597590 601950 605369 605475 605649 609697 613052 619091 623280 623790 663297 678855 680037 692582 707470 739622 744494 748812 757135 757883 763738 765794 765803 765813 765830 765840 765854 765870 777747 778752 779534 779607 779609 786384 786385 786428 786781 787528 788428 791759 796495 803142 805129 807324 807331 807594 808468 811071 813416 816691 817733 818057 818368 819894 ] |
||||||||||||||||||||||||||||||
|
12.90 ms (6.80%) |
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 779607 440645 443711 456062 536434 663297 707470 786385 765813 538005 680037 477114 582548 555093 609697 623790 597590 605649 418277 519415 462489 463159 455318 460601 516478 524944 490741 493195 512001 519672 572203 547762 547909 619091 397883 424120 443747 464548 421836 456000 465970 466890 421873 448975 463173 478377 424124 426864 466368 468355 516485 506084 519838 523836 486578 516480 516792 518335 523834 544103 558610 562708 678855 567076 605369 788428 757883 601950 522711 817733 818057 819894 538603 560319 569411 692582 613052 605475 796495 805129 807324 778752 779609 786781 787528 808468 757135 807331 807594 811071 813416 739622 765854 765870 748812 744494 765830 765840 763738 765794 765803 623280 777747 779534 786384 786428 791759 803142 513374 515720 465367 516787 569299 537020 818368 816691 462082 492619 540746 568715 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.26%) |
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 397883 418277 421836 421873 424120 424124 426864 440645 443711 443747 448975 455318 456000 456062 460601 462082 462489 463159 463173 464548 465367 465970 466368 466890 468355 477114 478377 486578 490741 492619 493195 506084 512001 513374 515720 516478 516480 516485 516787 516792 518335 519415 519672 519838 522711 523834 523836 524944 536434 537020 538005 538603 540746 544103 547762 547909 555093 558610 560319 562708 567076 568715 569299 569411 572203 582548 597590 601950 605369 605475 605649 609697 613052 619091 623280 623790 663297 678855 680037 692582 707470 739622 744494 748812 757135 757883 763738 765794 765803 765813 765830 765840 765854 765870 777747 778752 779534 779607 779609 786384 786385 786428 786781 787528 788428 791759 796495 803142 805129 807324 807331 807594 808468 811071 813416 816691 817733 818057 818368 819894 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom russian homemade"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom русск домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom русск домашн любительск"
]
|
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.