Query Metrics
7
Database Queries
7
Different statements
237.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.22 ms (87.97%) |
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 187847 358453 396568 413518 414125 415143 416365 417080 418121 419599 421471 421974 424200 428583 430393 430526 434371 441004 442629 447671 451112 454524 463764 467886 468149 469514 472581 472611 474699 476295 477068 478462 482532 485363 502866 512219 523994 530481 533594 538870 541394 543846 547453 547465 547475 547486 547501 547890 548153 550925 554271 554851 554866 561019 562961 563533 565164 566684 568560 569919 571035 577344 580207 580653 583501 583739 585968 586975 589208 599872 600314 601542 606185 606618 606633 607296 608122 610040 614935 615946 617825 623608 624197 627338 635450 660369 660405 660412 666016 668690 669016 669017 669056 670366 671002 671038 672138 672925 672942 672952 702463 725553 741541 752656 752687 758141 766669 785934 786115 806947 815062 815087 815093 815094 815126 818613 820542 827259 827829 828380 ] |
||||||||||||||||||||||||||||||
|
19.54 ms (8.21%) |
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 543846 565164 550925 671002 669016 606618 585968 623608 758141 752656 617825 702463 562961 600314 607296 752687 476295 478462 571035 441004 538870 554866 554271 635450 815087 815062 828380 512219 523994 533594 541394 547465 547475 547501 561019 566684 577344 580653 547453 568560 580207 660369 672138 672952 668690 671038 672942 610040 586975 589208 601542 606633 614935 624197 615946 785934 806947 725553 741541 608122 430393 187847 447671 485363 530481 670366 599872 358453 463764 430526 827829 472581 672925 606185 396568 419599 482532 474699 472611 468149 421471 627338 827259 766669 414125 477068 428583 418121 442629 451112 454524 469514 547890 569919 467886 434371 502866 416365 424200 421974 413518 547486 554851 583739 563533 583501 548153 660405 660412 669056 666016 669017 786115 417080 415143 815126 820542 815093 815094 818613 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.09%) |
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 187847 358453 396568 413518 414125 415143 416365 417080 418121 419599 421471 421974 424200 428583 430393 430526 434371 441004 442629 447671 451112 454524 463764 467886 468149 469514 472581 472611 474699 476295 477068 478462 482532 485363 502866 512219 523994 530481 533594 538870 541394 543846 547453 547465 547475 547486 547501 547890 548153 550925 554271 554851 554866 561019 562961 563533 565164 566684 568560 569919 571035 577344 580207 580653 583501 583739 585968 586975 589208 599872 600314 601542 606185 606618 606633 607296 608122 610040 614935 615946 617825 623608 624197 627338 635450 660369 660405 660412 666016 668690 669016 669017 669056 670366 671002 671038 672138 672925 672942 672952 702463 725553 741541 752656 752687 758141 766669 785934 786115 806947 815062 815087 815093 815094 815126 818613 820542 827259 827829 828380 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.67%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худая мам анал"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худая мам анал"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"худые мамы anal"
]
|
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.