Query Metrics
7
Database Queries
7
Different statements
436.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
411.76 ms (94.32%) |
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 391949 392607 397937 424048 424114 424273 426724 435576 453595 454131 455194 460555 460565 467776 470493 470932 475872 477963 479137 481824 491098 491102 504167 504211 504296 506074 508802 509230 509659 509749 511042 513421 515361 517059 519444 520616 536434 536447 537078 541819 542259 543580 543679 543723 548016 548513 553436 555674 560413 575223 612787 619896 619899 621376 625381 658468 662863 666491 666518 669244 669876 672251 683084 687654 693087 694615 695358 695380 704144 704622 704990 705029 705461 708908 714466 714474 715043 715071 716125 716135 716250 717095 719881 722961 725467 742402 746161 751507 757135 759097 769452 780853 781758 782762 792243 794161 795948 808585 814973 814990 816101 816655 816699 817128 817737 818069 819297 819777 819851 819957 820156 820167 820323 823848 824294 824803 825523 825907 826303 828431 ] |
||||||||||||||||||||||||||||||
|
13.42 ms (3.07%) |
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 672251 794161 795948 808585 746161 757135 769452 725467 759097 751507 714466 714474 424048 508802 536434 504296 504211 424114 426724 825907 814973 819777 814990 455194 454131 481824 560413 742402 792243 424273 475872 392607 460565 467776 479137 470493 477963 435576 453595 470932 504167 509230 511042 491098 515361 517059 491102 391949 397937 816101 820167 824803 823848 816655 816699 819957 817737 818069 819297 817128 819851 820156 820323 824294 825523 826303 828431 460555 537078 506074 520616 509749 519444 536447 509659 513421 543580 548513 553436 555674 541819 542259 543679 543723 666518 687654 695358 695380 704990 705029 716125 716250 693087 694615 705461 708908 716135 719881 722961 658468 662863 666491 669244 669876 683084 704144 704622 715043 715071 717095 548016 575223 625381 612787 619896 621376 619899 780853 781758 782762 ] |
||||||||||||||||||||||||||||||
|
4.41 ms (1.01%) |
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 391949 392607 397937 424048 424114 424273 426724 435576 453595 454131 455194 460555 460565 467776 470493 470932 475872 477963 479137 481824 491098 491102 504167 504211 504296 506074 508802 509230 509659 509749 511042 513421 515361 517059 519444 520616 536434 536447 537078 541819 542259 543580 543679 543723 548016 548513 553436 555674 560413 575223 612787 619896 619899 621376 625381 658468 662863 666491 666518 669244 669876 672251 683084 687654 693087 694615 695358 695380 704144 704622 704990 705029 705461 708908 714466 714474 715043 715071 716125 716135 716250 717095 719881 722961 725467 742402 746161 751507 757135 759097 769452 780853 781758 782762 792243 794161 795948 808585 814973 814990 816101 816655 816699 817128 817737 818069 819297 819777 819851 819957 820156 820167 820323 823848 824294 824803 825523 825907 826303 828431 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер milf русск"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam milf russian"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер milf русск"
]
|
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.