Query Metrics
7
Database Queries
7
Different statements
206.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.64 ms (89.69%) |
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 365295 383288 424910 495204 534477 540190 555674 556759 562997 565895 566463 566535 569187 570466 573260 579089 582772 583642 589965 599074 604037 608600 612605 613965 614386 615184 625092 628131 628189 634236 634649 638423 638549 638889 638962 643329 645745 659792 664804 665421 666388 667823 672629 677544 679171 690697 699509 704982 706602 709378 710051 710463 712312 715107 715521 716198 716877 717258 718180 718253 718256 720378 720628 721751 728340 729010 729804 729814 729816 730772 733357 734328 734394 735569 735789 737192 740186 743412 746639 747501 749023 750616 753157 753679 759441 759689 760500 760751 766001 766236 767324 767635 768723 775026 778083 784327 788633 789435 789489 789506 790820 792821 794383 796623 801512 802437 805343 805561 817082 817172 817370 817498 817703 818347 818831 818847 818899 825213 828184 ] |
||||||||||||||||||||||||||||||
|
12.26 ms (5.92%) |
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 583642 562997 667823 672629 699509 710463 715107 716877 690697 709378 720628 712312 718180 721751 634649 628189 638549 589965 599074 638423 643329 604037 634236 638889 638962 784327 789435 789506 734328 737192 753157 760500 760751 767635 785758 730772 734394 728340 735789 729010 729804 735569 740186 753679 759441 759689 766236 743412 750616 608600 612605 717258 718253 790820 794383 796623 801512 805561 677544 706602 775026 570466 573260 582772 802437 817082 818347 818847 825213 556759 569187 645745 715521 659792 664804 665421 710051 566463 615184 613965 625092 628131 614386 778083 805343 749023 767324 792821 766001 768723 729814 733357 729816 746639 747501 720378 788633 789489 383288 365295 424910 817370 817498 818831 817703 818899 817172 828184 540190 534477 495204 555674 579089 566535 565895 666388 704982 679171 716198 718256 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.26%) |
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 365295 383288 424910 495204 534477 540190 555674 556759 562997 565895 566463 566535 569187 570466 573260 579089 582772 583642 589965 599074 604037 608600 612605 613965 614386 615184 625092 628131 628189 634236 634649 638423 638549 638889 638962 643329 645745 659792 664804 665421 666388 667823 672629 677544 679171 690697 699509 704982 706602 709378 710051 710463 712312 715107 715521 716198 716877 717258 718180 718253 718256 720378 720628 721751 728340 729010 729804 729814 729816 730772 733357 734328 734394 735569 735789 737192 740186 743412 746639 747501 749023 750616 753157 753679 759441 759689 760500 760751 766001 766236 767324 767635 768723 775026 778083 784327 788633 789435 789489 789506 790820 792821 794383 796623 801512 802437 805343 805561 817082 817172 817370 817498 817703 818347 818831 818847 818899 825213 828184 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс condom"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс condom"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex condom"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.65%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.