Query Metrics
7
Database Queries
7
Different statements
147.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.64 ms (83.11%) |
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 11013 88031 123029 316575 324183 341691 382330 382579 387281 387993 390185 394597 398486 398760 398984 399061 400421 400672 400945 401677 407290 411025 414021 416713 421264 445326 452623 453228 466563 468790 469221 487270 493715 497830 497894 498449 517288 529922 530605 530809 532741 536580 536597 537750 539030 546160 546803 548439 550804 556331 556476 556874 559910 576439 576564 580109 580620 597275 621824 629725 630769 633444 634161 636628 647330 656826 657697 666858 670460 678067 679574 680179 680801 693502 694556 696278 704167 705028 707166 708069 719765 722378 722380 725628 726292 735152 738817 740699 745139 751437 752752 752755 761114 770860 783755 788567 789883 791703 792395 794096 794312 796849 796853 799579 800283 800317 800538 809664 810234 811968 819858 820032 821501 822910 824567 827944 827949 827964 827981 ] |
||||||||||||||||||||||||||||||
|
14.54 ms (9.86%) |
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 800538 726292 466563 382330 400421 580620 123029 387993 390185 398486 821501 822910 824567 468790 530809 529922 517288 580109 548439 670460 705028 694556 550804 629725 800317 740699 796853 761114 708069 800283 819858 827981 827964 827944 679574 789883 794312 791703 811968 809664 810234 735152 621824 382579 316575 398984 794096 416713 752755 487270 11013 421264 556331 401677 88031 399061 537750 536597 576564 657697 757736 796849 678067 820032 799579 387281 559910 719765 634161 597275 407290 452623 696278 324183 532741 633444 536580 469221 722380 398760 400672 493715 539030 497894 498449 530605 576439 556874 666858 707166 722378 656826 680801 546160 630769 636628 751437 752752 770860 725628 745139 704167 341691 827949 792395 783755 394597 445326 453228 546803 556476 647330 693502 680179 788567 738817 414021 400945 411025 497830 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (2.17%) |
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 11013 88031 123029 316575 324183 341691 382330 382579 387281 387993 390185 394597 398486 398760 398984 399061 400421 400672 400945 401677 407290 411025 414021 416713 421264 445326 452623 453228 466563 468790 469221 487270 493715 497830 497894 498449 517288 529922 530605 530809 532741 536580 536597 537750 539030 546160 546803 548439 550804 556331 556476 556874 559910 576439 576564 580109 580620 597275 621824 629725 630769 633444 634161 636628 647330 656826 657697 666858 670460 678067 679574 680179 680801 693502 694556 696278 704167 705028 707166 708069 719765 722378 722380 725628 726292 735152 738817 740699 745139 751437 752752 752755 761114 770860 783755 788567 789883 791703 792395 794096 794312 796849 796853 799579 800283 800317 800538 809664 810234 811968 819858 820032 821501 822910 824567 827944 827949 827964 827981 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex teens hardcore"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс teens хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс teens хардкор"
]
|
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.