Query Metrics
7
Database Queries
7
Different statements
177.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.46 ms (85.51%) |
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 17093 425285 426092 426693 429042 429715 429885 432363 432569 433397 439425 439504 441031 441610 443482 445784 447536 447538 452268 452673 452910 455873 459490 459492 459740 460351 461554 465148 468429 468597 470133 470580 470782 474271 478395 478789 479764 480207 480306 481441 481548 489573 489615 491522 491563 491662 493236 496736 496742 497482 501098 501510 502362 502800 503391 503685 505531 506077 506119 509037 513458 513495 513713 513716 514043 516902 518555 521973 524403 524670 524751 528938 529909 533658 535591 537407 539489 542070 546487 552632 553517 554485 558026 558040 558826 558861 560416 560451 561712 561713 561836 564351 566344 568960 569427 575092 575103 575928 576279 576284 579026 586366 594195 595458 597013 597950 599031 600081 600248 619334 634223 634602 639527 654402 671866 677342 677361 679355 686576 ] |
||||||||||||||||||||||||||||||
|
15.93 ms (8.99%) |
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 496742 497482 506119 513495 489573 493236 509037 501098 465573 595458 441610 481548 506077 533658 535591 537407 501510 503685 505531 514043 539489 474271 481441 546487 554485 558040 558826 564351 568960 575928 553517 560416 560451 561713 575092 576284 552632 579026 654402 671866 677342 679355 677361 686576 558026 558861 561712 566344 575103 576279 619334 599031 634223 594195 600248 600081 634602 639527 17093 425285 432569 468429 441031 445784 459490 459492 460351 470782 426693 429715 439425 455873 470133 426092 429042 447536 452910 459740 461554 478395 468597 470580 479764 491662 502800 513713 513716 518555 521973 524670 491522 491563 524403 496736 513458 529909 597950 597013 542070 561836 569427 586366 432363 433397 429885 465148 439504 452673 480207 480306 443482 447538 452268 478789 503391 489615 516902 528938 502362 524751 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.49%) |
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 17093 425285 426092 426693 429042 429715 429885 432363 432569 433397 439425 439504 441031 441610 443482 445784 447536 447538 452268 452673 452910 455873 459490 459492 459740 460351 461554 465148 468429 468597 470133 470580 470782 474271 478395 478789 479764 480207 480306 481441 481548 489573 489615 491522 491563 491662 493236 496736 496742 497482 501098 501510 502362 502800 503391 503685 505531 506077 506119 509037 513458 513495 513713 513716 514043 516902 518555 521973 524403 524670 524751 528938 529909 533658 535591 537407 539489 542070 546487 552632 553517 554485 558026 558040 558826 558861 560416 560451 561712 561713 561836 564351 566344 568960 569427 575092 575103 575928 576279 576284 579026 586366 594195 595458 597013 597950 599031 600081 600248 619334 634223 634602 639527 654402 671866 677342 677361 679355 686576 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск постел teen"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian bed teen"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск постел teen"
]
|
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.