Query Metrics
7
Database Queries
7
Different statements
203.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.42 ms (87.68%) |
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 118450 229233 382316 383950 393441 400100 410770 413593 416715 417790 419658 425365 427250 428154 432580 434801 441081 441519 444393 445531 447507 448077 448321 453030 454458 454475 455574 458286 459424 459506 462901 463669 463890 464470 464763 465195 465905 468254 468269 469619 470312 475512 479298 480611 483682 483762 484210 486221 496512 498752 504471 505549 510415 517385 520361 520670 520675 521346 522048 522313 523197 524319 525321 525583 525617 528841 531810 536750 537845 541878 543629 544465 551129 551803 552009 556012 562326 563325 566395 573395 574502 577920 589969 591988 600457 602930 603781 618118 621056 637701 638759 640520 645626 658978 670034 691567 693957 694715 697322 697634 715810 717623 717770 750325 753465 759567 768905 770608 772618 776426 779310 780041 786448 786874 791355 795761 802503 803112 804748 ] |
||||||||||||||||||||||||||||||
|
15.00 ms (7.37%) |
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 566395 715810 776426 400100 479298 525583 697322 574502 786874 410770 465195 464763 670034 791355 802503 804748 759567 753465 717623 448321 486221 528841 383950 441519 470312 458286 638759 589969 454475 469619 432580 428154 496512 520361 537845 780041 772618 522048 483762 417790 448077 697634 694715 645626 770608 562326 600457 536750 577920 229233 393441 544465 416715 591988 484210 525617 504471 520675 658978 551803 602930 768905 531810 541878 556012 640520 427250 459506 462901 522313 551129 382316 543629 419658 468254 510415 618118 480611 465905 453030 520670 573395 750325 454458 464470 498752 444393 425365 455574 459424 468269 525321 563325 603781 447507 463669 475512 521346 691567 118450 552009 413593 621056 505549 517385 524319 570835 693957 717770 637701 779310 795761 786448 463890 483682 434801 523197 803112 445531 441081 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (1.57%) |
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 118450 229233 382316 383950 393441 400100 410770 413593 416715 417790 419658 425365 427250 428154 432580 434801 441081 441519 444393 445531 447507 448077 448321 453030 454458 454475 455574 458286 459424 459506 462901 463669 463890 464470 464763 465195 465905 468254 468269 469619 470312 475512 479298 480611 483682 483762 484210 486221 496512 498752 504471 505549 510415 517385 520361 520670 520675 521346 522048 522313 523197 524319 525321 525583 525617 528841 531810 536750 537845 541878 543629 544465 551129 551803 552009 556012 562326 563325 566395 573395 574502 577920 589969 591988 600457 602930 603781 618118 621056 637701 638759 640520 645626 658978 670034 691567 693957 694715 697322 697634 715810 717623 717770 750325 753465 759567 768905 770608 772618 776426 779310 780041 786448 786874 791355 795761 802503 803112 804748 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass girls"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп девушк"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.76%) |
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.