Query Metrics
7
Database Queries
7
Different statements
178.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.76 ms (84.36%) |
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 41776 66938 80801 181242 198001 382285 382575 388424 390807 391527 393759 398212 399865 411262 412691 417099 417878 420278 420700 421575 426078 427089 428998 429249 431205 434447 435510 442546 457146 458267 459434 459578 459875 459993 461943 462259 465118 466123 466712 468111 469769 469901 473617 473819 475260 476547 477870 480620 480867 544610 550021 551810 552668 552794 554979 557000 560467 563718 564145 565794 567676 570413 570643 570690 571381 572689 573100 579218 582016 584051 585345 586220 587054 588379 589673 591422 591974 592027 593838 597593 598341 599240 599492 599742 601857 602625 606197 606668 609192 611331 614803 615535 615945 618300 618970 621044 625150 627103 629742 631583 636429 640905 670034 672975 687937 727668 741929 744602 745728 758880 762886 770444 775379 775385 775630 780463 781959 810392 810539 812792 ] |
||||||||||||||||||||||||||||||
|
16.72 ms (9.35%) |
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 670034 672975 687937 544610 550021 551810 552668 552794 554979 557000 560467 563718 564145 565794 567676 570413 570643 570690 571381 572689 573100 579218 582016 584051 585345 586220 589673 593838 598341 599742 611331 625150 588379 591974 599240 602625 606668 609192 615535 629742 631583 615945 587054 591422 592027 597593 599492 601857 606197 614803 618300 618970 627103 636429 775379 775630 812792 727668 770444 781959 745728 741929 758880 762886 744602 621044 640905 775385 780463 810392 810539 66938 382285 382575 427089 428998 429249 431205 459578 459875 461943 462259 468111 476547 480867 80801 393759 398212 411262 417099 417878 420278 421575 435510 442546 458267 459434 459993 466123 466712 469769 477870 480620 390807 391527 399865 412691 420700 426078 434447 457146 465118 469901 473617 473819 475260 41776 181242 198001 388424 ] |
||||||||||||||||||||||||||||||
|
3.33 ms (1.86%) |
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 41776 66938 80801 181242 198001 382285 382575 388424 390807 391527 393759 398212 399865 411262 412691 417099 417878 420278 420700 421575 426078 427089 428998 429249 431205 434447 435510 442546 457146 458267 459434 459578 459875 459993 461943 462259 465118 466123 466712 468111 469769 469901 473617 473819 475260 476547 477870 480620 480867 544610 550021 551810 552668 552794 554979 557000 560467 563718 564145 565794 567676 570413 570643 570690 571381 572689 573100 579218 582016 584051 585345 586220 587054 588379 589673 591422 591974 592027 593838 597593 598341 599240 599492 599742 601857 602625 606197 606668 609192 611331 614803 615535 615945 618300 618970 621044 625150 627103 629742 631583 636429 640905 670034 672975 687937 727668 741929 744602 745728 758880 762886 770444 775379 775385 775630 780463 781959 810392 810539 812792 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сину"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"син"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.