Query Metrics
7
Database Queries
7
Different statements
207.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
188.71 ms (91.00%) |
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 482182 494757 506238 531328 531575 533975 533979 533987 540949 543073 543160 543271 543566 543788 546224 549215 561041 562524 574065 588067 588279 595997 599646 601469 603196 615492 622969 626821 626825 629518 635182 637929 639217 652531 653517 653530 654058 654535 654714 654983 655058 655371 656011 657289 657337 658380 658387 659830 660104 663330 663356 663907 665504 666019 668435 674412 674616 674635 677513 680405 687525 688121 689371 692070 693553 698930 705121 707552 716604 716630 716763 720044 774713 776887 777508 779850 781242 782509 783440 786070 790349 790947 793354 793433 796854 804775 812431 815145 815551 815859 816367 816550 817758 817901 818122 818416 818644 818673 818790 819299 819382 819477 820691 820703 821104 821293 821411 821414 821830 822393 822675 823046 823143 823229 823650 825019 825220 825274 827575 827939 ] |
||||||||||||||||||||||||||||||
|
8.79 ms (4.24%) |
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 817901 818416 818673 818790 820691 822393 823650 827575 815859 816550 817758 819382 819477 821411 821830 822675 823046 823229 825019 815145 815551 816367 818122 818644 819299 820703 821104 821293 821414 823143 825220 827939 825274 482182 533975 533987 531328 531575 506238 533979 494757 540949 543160 543566 543788 546224 549215 543073 543271 562524 561041 653530 654058 654535 658387 663330 668435 674412 705121 716630 652531 654714 654983 658380 659830 660104 663356 666019 674616 674635 680405 692070 693553 698930 707552 716604 716763 653517 655058 655371 656011 657289 657337 663907 665504 677513 687525 688121 689371 720044 574065 601469 615492 629518 588279 599646 622969 588067 603196 635182 637929 639217 595997 626821 626825 774713 776887 777508 782509 790349 793354 793433 796854 804775 812431 779850 781242 783440 786070 790947 ] |
||||||||||||||||||||||||||||||
|
3.37 ms (1.63%) |
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 482182 494757 506238 531328 531575 533975 533979 533987 540949 543073 543160 543271 543566 543788 546224 549215 561041 562524 574065 588067 588279 595997 599646 601469 603196 615492 622969 626821 626825 629518 635182 637929 639217 652531 653517 653530 654058 654535 654714 654983 655058 655371 656011 657289 657337 658380 658387 659830 660104 663330 663356 663907 665504 666019 668435 674412 674616 674635 677513 680405 687525 688121 689371 692070 693553 698930 705121 707552 716604 716630 716763 720044 774713 776887 777508 779850 781242 782509 783440 786070 790349 790947 793354 793433 796854 804775 812431 815145 815551 815859 816367 816550 817758 817901 818122 818416 818644 818673 818790 819299 819382 819477 820691 820703 821104 821293 821411 821414 821830 822393 822675 823046 823143 823229 823650 825019 825220 825274 827575 827939 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob deep throat"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс глубокийминет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.