Query Metrics
7
Database Queries
7
Different statements
155.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.61 ms (83.57%) |
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 100976 145624 153311 213330 383090 383480 383694 386250 386685 387625 387732 388176 388543 388767 389283 391001 408766 411818 412018 413223 415612 416402 426446 429298 433581 437322 439441 440526 448166 451465 456062 456879 460630 480613 483421 489539 492418 508706 527790 529692 529857 531924 537558 544353 547787 548327 554978 556009 557062 557237 558724 564371 584996 612344 613107 618010 632453 632989 698476 705382 714228 715904 720901 724475 726370 729226 732725 733452 738208 738276 738847 741146 741624 744205 746436 753710 755326 756875 759682 759709 760898 768052 768862 771224 772678 785118 789006 793535 796541 796888 803820 804622 808585 810315 815884 817745 817825 818502 819676 819816 820380 823690 823738 824277 824278 824533 824952 825212 826160 826206 826493 828146 828158 828360 828487 828601 828715 828746 828762 ] |
||||||||||||||||||||||||||||||
|
15.06 ms (9.71%) |
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 738847 759709 771224 741624 755326 759682 760898 768052 726370 732725 733452 738208 738276 741146 744205 746436 753710 768862 772678 612344 618010 632989 698476 705382 715904 720901 785118 796541 796888 803820 810315 412018 413223 388767 213330 100976 544353 387625 391001 411818 386685 426446 439441 456879 448166 529692 460630 547787 804622 808585 724475 756875 729226 408766 433581 437322 388543 440526 451465 456062 508706 527790 564371 714228 632453 613107 793535 824278 825212 824952 537558 556009 823690 828601 389283 824277 824808 828158 828762 828746 828360 828487 828715 789006 386250 383090 383480 383694 153311 145624 387732 388176 415612 416402 429298 826206 584996 826493 819676 819816 823738 826160 817745 820380 824533 815884 817825 818502 828146 480613 489539 529857 531924 483421 492418 548327 554978 557062 557237 558724 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"натуральная натуральные milf"
]
|
||||||||||||||||||||||||||||||
|
2.55 ms (1.64%) |
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 100976 145624 153311 213330 383090 383480 383694 386250 386685 387625 387732 388176 388543 388767 389283 391001 408766 411818 412018 413223 415612 416402 426446 429298 433581 437322 439441 440526 448166 451465 456062 456879 460630 480613 483421 489539 492418 508706 527790 529692 529857 531924 537558 544353 547787 548327 554978 556009 557062 557237 558724 564371 584996 612344 613107 618010 632453 632989 698476 705382 714228 715904 720901 724475 726370 729226 732725 733452 738208 738276 738847 741146 741624 744205 746436 753710 755326 756875 759682 759709 760898 768052 768862 771224 772678 785118 789006 793535 796541 796888 803820 804622 808585 810315 815884 817745 817825 818502 819676 819816 820380 823690 823738 824277 824278 824533 824952 825212 826160 826206 826493 828146 828158 828360 828487 828601 828715 828746 828762 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"натуральная натуральные milf"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"natural milf"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.88%) |
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.