Query Metrics
7
Database Queries
7
Different statements
201.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.19 ms (86.64%) |
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 132836 229361 386548 397876 400311 402141 413140 413507 415860 415875 418512 422017 429353 446405 449112 460056 462170 463661 473928 476452 478787 485818 489156 491658 492384 492661 493080 493934 496419 499050 500745 501227 513054 513613 515296 520492 522461 527507 527526 529820 531588 533464 533708 537791 544880 549415 552212 553775 553776 558655 574144 577900 579204 587091 589181 589218 590334 590830 593999 594108 594339 595077 603145 603542 603925 608091 609649 618432 619774 620967 622068 622540 623932 623960 624078 639960 644404 648360 650731 650765 671077 676491 676495 676517 676521 677041 685892 703708 706465 709179 723368 727335 732167 736967 744840 746935 747481 748634 756074 757098 765448 767308 770984 778514 778595 778833 782737 784994 785288 786344 786458 789166 789876 792441 795120 806031 806672 807967 810271 814019 ] |
||||||||||||||||||||||||||||||
|
17.29 ms (8.60%) |
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 492661 493080 496419 513054 513613 515296 537791 473928 478787 499050 501227 463661 462170 491658 520492 492384 402141 397876 619774 603145 732167 770984 644404 400311 415860 413507 476452 709179 603542 778595 418512 413140 522461 609649 622068 623932 806031 807967 789876 765448 748634 229361 814019 446405 531588 558655 671077 608091 590830 622540 623960 786458 757098 795120 746935 723368 429353 386548 132836 422017 415875 460056 485818 449112 489156 533708 500745 527507 527526 533464 529820 493934 579204 553776 577900 552212 650731 676491 676517 677041 706465 648360 650765 676521 685892 703708 676495 544880 549415 553775 574144 593999 594108 594339 624078 587091 590334 639960 603925 620967 589181 589218 595077 618432 778514 782737 810271 778833 784994 786344 727335 736967 744840 767308 785288 789166 792441 806672 747481 756074 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.46%) |
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 132836 229361 386548 397876 400311 402141 413140 413507 415860 415875 418512 422017 429353 446405 449112 460056 462170 463661 473928 476452 478787 485818 489156 491658 492384 492661 493080 493934 496419 499050 500745 501227 513054 513613 515296 520492 522461 527507 527526 529820 531588 533464 533708 537791 544880 549415 552212 553775 553776 558655 574144 577900 579204 587091 589181 589218 590334 590830 593999 594108 594339 595077 603145 603542 603925 608091 609649 618432 619774 620967 622068 622540 623932 623960 624078 639960 644404 648360 650731 650765 671077 676491 676495 676517 676521 677041 685892 703708 706465 709179 723368 727335 732167 736967 744840 746935 747481 748634 756074 757098 765448 767308 770984 778514 778595 778833 782737 784994 785288 786344 786458 789166 789876 792441 795120 806031 806672 807967 810271 814019 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"18летней ира ростов"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"18 ир 19 рост лет"
]
|
||||||||||||||||||||||||||||||
|
1.21 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"18 ир 19 рост лет"
]
|
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.