Query Metrics
7
Database Queries
7
Different statements
171.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.05 ms (86.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 446310 447289 453022 457012 460107 460112 465409 469308 469706 473542 488520 497389 505248 509399 536937 544879 550209 555161 555945 557726 560891 571993 573922 575695 577718 584970 585391 585790 588072 606511 606575 607866 626434 630846 633109 633671 636557 638067 638963 648563 652665 661921 664222 668554 668613 668988 670003 670032 670257 671419 674124 674825 697327 703211 709764 710891 727610 728115 729781 730450 732669 733074 733346 738022 740508 741832 741854 744675 747135 754253 756526 762476 763166 763579 763717 764956 767365 769344 769354 770065 772968 775054 775130 776629 777217 777477 777568 778068 779030 779085 779614 781405 783768 783838 786570 786705 786713 786831 786980 788979 789012 789891 790761 793311 794992 795669 795673 796024 797013 797267 798849 799528 801397 805354 807273 807275 812822 813308 820662 ] |
||||||||||||||||||||||||||||||
|
13.40 ms (7.82%) |
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 509399 744675 754253 638963 460107 638067 777568 794992 795673 796024 807275 813308 779030 789891 795669 756526 772968 728115 763717 766254 775130 779085 788979 797013 661921 571993 607866 790761 801397 807273 741854 763166 573922 446310 560891 465409 575695 550209 652665 668554 668613 670003 671419 703211 648563 710891 585790 630846 797267 729781 733346 781405 783768 762476 764956 727610 633109 633671 636557 777477 786713 460112 626434 584970 555161 730450 544879 670032 668988 674825 606511 775054 779614 786705 786980 776629 777217 786570 789012 793311 769354 770065 783838 799528 767365 763579 798849 557726 664222 585391 588072 805354 769344 741832 488520 820662 473542 577718 697327 709764 670257 674124 555945 606575 778068 786831 812822 738022 747135 733074 732669 740508 469706 497389 505248 457012 469308 536937 453022 447289 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.55%) |
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 446310 447289 453022 457012 460107 460112 465409 469308 469706 473542 488520 497389 505248 509399 536937 544879 550209 555161 555945 557726 560891 571993 573922 575695 577718 584970 585391 585790 588072 606511 606575 607866 626434 630846 633109 633671 636557 638067 638963 648563 652665 661921 664222 668554 668613 668988 670003 670032 670257 671419 674124 674825 697327 703211 709764 710891 727610 728115 729781 730450 732669 733074 733346 738022 740508 741832 741854 744675 747135 754253 756526 762476 763166 763579 763717 764956 767365 769344 769354 770065 772968 775054 775130 776629 777217 777477 777568 778068 779030 779085 779614 781405 783768 783838 786570 786705 786713 786831 786980 788979 789012 789891 790761 793311 794992 795669 795673 796024 797013 797267 798849 799528 801397 805354 807273 807275 812822 813308 820662 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"handjob facial"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк член facial"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дрочк член facial"
]
|
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.