Query Metrics
7
Database Queries
7
Different statements
154.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.36 ms (81.74%) |
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 387377 395596 395639 395826 396013 400807 400808 400812 400826 400852 401229 401307 411344 411350 415658 420635 421871 421907 422158 422205 424411 424460 433733 438001 439457 439518 439529 439558 439565 439574 439591 439607 439623 439641 439643 439649 439667 439673 439681 439696 439699 440598 440991 440993 440999 441004 444100 449428 456614 464649 465892 466020 466021 466191 466239 466272 466869 469909 470941 472148 474635 476344 476588 477730 479049 480059 482088 484069 484585 484629 484671 484704 484738 485460 486341 487339 488698 489379 491209 494567 495665 496862 506529 515994 518566 518827 519945 522343 523019 526775 534285 549799 564826 565351 566993 567337 573800 586564 588376 589591 647960 672805 677142 699549 699583 707368 720343 735778 739532 742449 743065 758432 761007 766613 807327 807340 807927 817261 825812 826888 ] |
||||||||||||||||||||||||||||||
|
18.01 ms (11.65%) |
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 400807 472148 479049 400808 401229 439591 440598 489379 761007 491209 439529 439574 439607 449428 465892 422205 440991 484585 484704 486341 439623 482088 766613 464649 534285 807340 807927 743065 400826 400852 439643 400812 466020 474635 444100 466272 411344 677142 565351 494567 817261 826888 438001 469909 433733 440993 396013 485460 707368 742449 395639 395596 699549 720343 564826 420635 441004 699583 758432 387377 488698 421907 487339 480059 439641 415658 439565 466869 439673 439681 456614 515994 549799 589591 424460 466021 440999 477730 484629 496862 522343 421871 672805 476344 495665 825812 466191 807327 739532 439699 422158 439457 411350 424411 470941 484671 484738 518827 439649 395826 567337 518566 506529 588376 401307 519945 526775 586564 647960 573800 439518 439558 735778 523019 484069 566993 439667 476588 439696 466239 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.82%) |
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 387377 395596 395639 395826 396013 400807 400808 400812 400826 400852 401229 401307 411344 411350 415658 420635 421871 421907 422158 422205 424411 424460 433733 438001 439457 439518 439529 439558 439565 439574 439591 439607 439623 439641 439643 439649 439667 439673 439681 439696 439699 440598 440991 440993 440999 441004 444100 449428 456614 464649 465892 466020 466021 466191 466239 466272 466869 469909 470941 472148 474635 476344 476588 477730 479049 480059 482088 484069 484585 484629 484671 484704 484738 485460 486341 487339 488698 489379 491209 494567 495665 496862 506529 515994 518566 518827 519945 522343 523019 526775 534285 549799 564826 565351 566993 567337 573800 586564 588376 589591 647960 672805 677142 699549 699583 707368 720343 735778 739532 742449 743065 758432 761007 766613 807327 807340 807927 817261 825812 826888 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old wife anal"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old жен анал"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old жен анал"
]
|
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.