Query Metrics
7
Database Queries
7
Different statements
235.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.22 ms (89.61%) |
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 61226 154694 233355 385734 387080 392665 398253 398604 415870 420432 422149 432408 438646 438650 448080 449166 462142 466304 467808 470642 475216 487833 504312 505771 506319 510127 511443 512143 514323 518818 521202 523980 527189 534040 534066 542479 546618 560662 561920 561972 562219 562226 565638 570322 572141 572158 573665 577834 580343 590292 594805 597585 601545 614983 615057 616500 616778 621509 622815 635125 641319 653246 653258 653290 658468 659425 662038 673009 673126 674894 677450 679363 679397 704022 705030 709363 715701 716695 719956 721197 722923 729737 730645 734300 739959 741796 747840 750463 750630 758734 763473 764556 766001 768542 768732 774855 780051 780843 781481 782152 782743 782745 784084 786225 786227 789401 792800 795929 797307 801606 805209 806242 810842 811589 811775 816836 820009 820729 826153 ] |
||||||||||||||||||||||||||||||
|
14.75 ms (6.26%) |
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 780051 466304 577834 820009 820729 511443 542479 659425 716695 674894 677450 704022 705030 719956 722923 658468 673126 679397 709363 594805 622815 782743 786227 797307 811775 781481 805209 729737 734300 764556 784084 730645 750463 766001 768732 758734 768542 750630 621128 715701 721197 795929 811589 570322 562226 573665 601545 415870 438650 534066 521202 616778 518818 826153 816836 653246 673009 653258 653290 662038 679363 561920 580343 590292 616500 635125 641319 597585 621509 786225 801606 810842 774855 780843 782745 782152 789401 747840 763473 741796 739959 615057 792800 806242 572158 387080 233355 448080 422149 505771 514323 527189 561972 534040 614983 385734 462142 398253 470642 510127 523980 560662 392665 475216 420432 512143 565638 572141 546618 438646 467808 487833 504312 154694 61226 506319 562219 449166 432408 398604 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.22%) |
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 61226 154694 233355 385734 387080 392665 398253 398604 415870 420432 422149 432408 438646 438650 448080 449166 462142 466304 467808 470642 475216 487833 504312 505771 506319 510127 511443 512143 514323 518818 521202 523980 527189 534040 534066 542479 546618 560662 561920 561972 562219 562226 565638 570322 572141 572158 573665 577834 580343 590292 594805 597585 601545 614983 615057 616500 616778 621509 622815 635125 641319 653246 653258 653290 658468 659425 662038 673009 673126 674894 677450 679363 679397 704022 705030 709363 715701 716695 719956 721197 722923 729737 730645 734300 739959 741796 747840 750463 750630 758734 763473 764556 766001 768542 768732 774855 780051 780843 781481 782152 782743 782745 784084 786225 786227 789401 792800 795929 797307 801606 805209 806242 810842 811589 811775 816836 820009 820729 826153 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск hot девушк"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian hot girls"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск hot девушк"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.64%) |
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.