Query Metrics
7
Database Queries
7
Different statements
183.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.22 ms (87.69%) |
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 74508 76011 150349 230986 271197 272566 314496 357442 377241 381926 384895 385600 388180 388523 391764 392524 397213 397837 397870 398500 400569 400976 401476 401593 403343 409076 418517 424284 444853 453277 458790 469908 471338 474324 480759 486060 486307 504161 505252 510056 515542 542643 558948 565026 565228 565706 592289 598307 630561 631253 635018 638047 642109 644431 653369 660357 666610 671892 675965 678458 681777 692662 693660 693719 698914 715118 721713 721987 722158 727500 729124 730822 733055 733065 733073 733078 733079 733082 733380 733553 734059 734130 734691 743013 743773 754185 756696 757227 757250 759519 763519 764095 765823 765957 765963 768587 773437 773442 774255 781115 783124 783134 784016 786485 788505 788523 790120 791528 796761 797220 797261 797266 797273 797277 797281 797542 801133 807272 809242 812684 ] |
||||||||||||||||||||||||||||||
|
12.26 ms (6.67%) |
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 486307 791528 773442 809242 314496 401476 400976 801133 397213 510056 797542 765963 743773 768587 504161 418517 424284 486060 565026 388523 469908 692662 721987 631253 797273 733055 733078 733079 734059 734691 515542 397870 272566 565228 660357 781115 790120 774255 786485 392524 357442 409076 453277 471338 403343 377241 505252 722158 678458 807272 74508 715118 653369 797261 797277 733073 733380 743013 757227 765823 733065 797281 681777 666610 598307 635018 783134 796761 764095 765957 773437 150349 271197 400569 398500 474324 565706 675965 644431 812684 763519 784016 388180 458790 444853 480759 542643 671892 693719 558948 592289 638047 642109 759519 754185 756696 783124 397837 630561 391764 385600 381926 76011 721713 693660 788523 797220 797266 727500 730822 733553 729124 733082 734130 757250 698914 788505 384895 230986 401593 ] |
||||||||||||||||||||||||||||||
|
3.30 ms (1.80%) |
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 74508 76011 150349 230986 271197 272566 314496 357442 377241 381926 384895 385600 388180 388523 391764 392524 397213 397837 397870 398500 400569 400976 401476 401593 403343 409076 418517 424284 444853 453277 458790 469908 471338 474324 480759 486060 486307 504161 505252 510056 515542 542643 558948 565026 565228 565706 592289 598307 630561 631253 635018 638047 642109 644431 653369 660357 666610 671892 675965 678458 681777 692662 693660 693719 698914 715118 721713 721987 722158 727500 729124 730822 733055 733065 733073 733078 733079 733082 733380 733553 734059 734130 734691 743013 743773 754185 756696 757227 757250 759519 763519 764095 765823 765957 765963 768587 773437 773442 774255 781115 783124 783134 784016 786485 788505 788523 790120 791528 796761 797220 797261 797266 797273 797277 797281 797542 801133 807272 809242 812684 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен беловолосая"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife blonde"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен беловолосая"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.79%) |
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.