Query Metrics
7
Database Queries
7
Different statements
144.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.77 ms (82.73%) |
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 108018 406724 418858 422286 423516 427714 428095 428159 435503 435701 436626 440798 442645 447090 450650 451141 451632 452786 454652 455058 455343 457194 457379 459252 459363 461567 468863 469168 470559 473974 475542 478402 478988 478992 481406 484118 486859 486872 487086 487228 489220 491373 492289 492337 495130 501250 501839 504741 504748 510619 512373 514392 514609 515337 515589 516440 523051 524069 526219 527277 527519 529053 534359 535707 546510 553653 555591 562484 576697 578185 578386 582477 584128 584217 591210 591494 602355 602714 603420 605579 631550 634362 647605 647606 651039 652129 660807 665831 676375 693796 693806 709729 709919 709938 716383 718864 719456 719640 721793 725579 728494 731382 732242 734611 737632 743933 744585 745565 747640 771251 774994 787399 790841 796640 801866 805041 807982 810383 816568 ] |
||||||||||||||||||||||||||||||
|
15.49 ms (10.70%) |
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 647605 652129 546510 810383 747640 728494 745565 737632 743933 725579 731382 719456 719640 721793 807982 108018 495130 676375 486859 435503 523051 447090 515589 486872 452786 473974 422286 660807 555591 584217 605579 591494 796640 805041 602355 514392 501250 524069 406724 427714 435701 457379 469168 718864 771251 418858 512373 478402 709938 651039 468863 801866 716383 428095 457194 461567 481406 491373 647606 665831 693796 693806 631550 591210 634362 734611 732242 744585 787399 470559 487228 450650 459363 534359 582477 790841 454652 535707 527519 576697 709729 603420 578185 451141 455058 553653 428159 455343 489220 510619 492289 526219 578386 604621 440798 816568 451632 478988 527277 515337 475542 562484 584128 709919 602714 774994 436626 459252 478992 501839 487086 516440 504741 504748 514609 484118 492337 442645 423516 529053 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.76%) |
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 108018 406724 418858 422286 423516 427714 428095 428159 435503 435701 436626 440798 442645 447090 450650 451141 451632 452786 454652 455058 455343 457194 457379 459252 459363 461567 468863 469168 470559 473974 475542 478402 478988 478992 481406 484118 486859 486872 487086 487228 489220 491373 492289 492337 495130 501250 501839 504741 504748 510619 512373 514392 514609 515337 515589 516440 523051 524069 526219 527277 527519 529053 534359 535707 546510 553653 555591 562484 576697 578185 578386 582477 584128 584217 591210 591494 602355 602714 603420 605579 631550 634362 647605 647606 651039 652129 660807 665831 676375 693796 693806 709729 709919 709938 716383 718864 719456 719640 721793 725579 728494 731382 732242 734611 737632 743933 744585 745565 747640 771251 774994 787399 790841 796640 801866 805041 807982 810383 816568 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real big tits"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real большие сиськ"
]
|
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.