Query Metrics
7
Database Queries
7
Different statements
205.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.60 ms (88.86%) |
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 389639 393765 401196 415698 419949 422403 425694 428617 429543 437559 438738 443428 443594 443760 443814 445035 446608 454250 454594 455378 457682 458532 460727 462661 462806 465140 465404 466953 467149 467391 470477 471518 471524 471819 473320 473796 477053 477440 477704 479327 481321 484943 489443 490167 491947 491993 502048 508874 510759 515109 519137 521973 546908 552650 552758 554203 560104 560210 560584 561441 561639 563141 564056 565992 569962 571802 573410 574807 575103 581315 586201 586671 598086 598532 598909 599734 601355 605412 614797 614865 616481 617203 618465 620025 620983 621308 621443 622197 631961 637737 645011 667013 668676 679365 686082 687185 687271 700588 708519 709293 714864 721395 721795 726706 726777 741605 743130 743381 744319 761102 770663 771180 781447 789692 790501 790877 798647 804215 807944 809688 ] |
||||||||||||||||||||||||||||||
|
13.47 ms (6.56%) |
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 560210 560584 561441 564056 565992 569962 571802 573410 574807 668676 700588 709293 714864 667013 679365 687185 645011 686082 687271 546908 552650 552758 554203 560104 561639 563141 575103 581315 599734 616481 598086 598909 601355 614865 620025 620983 586671 621308 637737 586201 598532 605412 617203 618465 621443 622197 790877 798647 807944 790501 809688 771180 726706 741605 743130 743381 744319 761102 726777 770663 614797 631961 708519 721395 721795 781447 789692 804215 415698 438738 443594 445035 458532 462806 466953 477053 389639 428617 443428 460727 467149 471524 477704 479327 393765 401196 429543 437559 446608 457682 465140 467391 473320 473796 481321 422403 425694 454250 454594 455378 465404 470477 471518 471819 419949 443760 443814 462661 477440 515109 519137 484943 489443 490167 491947 491993 502048 508874 510759 521973 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.31%) |
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 389639 393765 401196 415698 419949 422403 425694 428617 429543 437559 438738 443428 443594 443760 443814 445035 446608 454250 454594 455378 457682 458532 460727 462661 462806 465140 465404 466953 467149 467391 470477 471518 471524 471819 473320 473796 477053 477440 477704 479327 481321 484943 489443 490167 491947 491993 502048 508874 510759 515109 519137 521973 546908 552650 552758 554203 560104 560210 560584 561441 561639 563141 564056 565992 569962 571802 573410 574807 575103 581315 586201 586671 598086 598532 598909 599734 601355 605412 614797 614865 616481 617203 618465 620025 620983 621308 621443 622197 631961 637737 645011 667013 668676 679365 686082 687185 687271 700588 708519 709293 714864 721395 721795 726706 726777 741605 743130 743381 744319 761102 770663 771180 781447 789692 790501 790877 798647 804215 807944 809688 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy sleep"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.89%) |
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:
[
"pussy спящ"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy спящ"
]
|
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.