Query Metrics
7
Database Queries
7
Different statements
157.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.80 ms (85.84%) |
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 8867 31563 51569 85250 88945 151455 215337 233321 233344 233608 266369 275727 289778 357513 382021 382390 382947 383117 389697 390233 397937 403279 407466 439680 484706 497381 515721 523908 526484 535324 573187 581285 585322 589629 589707 590134 591133 597130 603379 603437 605232 618380 622972 645831 645840 645841 645881 646191 648199 658463 660025 663357 665285 665962 675498 681290 705078 705452 705887 707379 710264 714465 715107 720464 720482 720496 720511 720514 720525 720548 721751 724235 728355 731812 731823 739160 741099 742734 744219 744226 744769 744803 744806 744807 746066 746677 751648 755355 755359 759904 760695 770131 772875 774323 779220 787329 788696 789556 790982 796276 799168 799211 799631 802986 803008 803729 807997 808159 809701 811403 811467 815715 816542 818506 819241 819250 819643 824807 825015 826388 ] |
||||||||||||||||||||||||||||||
|
11.60 ms (7.39%) |
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 589707 605232 675498 731823 744226 746677 233321 31563 645831 779220 772875 731812 744769 85250 439680 819241 289778 819250 796276 88945 744803 8867 403279 382021 266369 707379 705887 803729 811403 774323 742734 746066 802986 807997 357513 648199 523908 484706 215337 581285 645881 645841 603437 809701 744807 751648 720511 618380 233608 818506 658463 799631 755355 714465 808159 382947 407466 715107 603379 755359 744219 720548 799211 720525 646191 803008 811467 597130 397937 51569 589629 741099 720464 233344 824807 826388 497381 660025 710264 721751 590134 622972 724235 788696 789556 383117 759904 573187 816542 526484 681290 720514 705452 645840 585322 770131 389697 815715 535324 720482 705078 720496 591133 787329 744806 799168 728355 739160 760695 790982 390233 151455 275727 382390 825015 819643 515721 665285 663357 665962 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.94%) |
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 8867 31563 51569 85250 88945 151455 215337 233321 233344 233608 266369 275727 289778 357513 382021 382390 382947 383117 389697 390233 397937 403279 407466 439680 484706 497381 515721 523908 526484 535324 573187 581285 585322 589629 589707 590134 591133 597130 603379 603437 605232 618380 622972 645831 645840 645841 645881 646191 648199 658463 660025 663357 665285 665962 675498 681290 705078 705452 705887 707379 710264 714465 715107 720464 720482 720496 720511 720514 720525 720548 721751 724235 728355 731812 731823 739160 741099 742734 744219 744226 744769 744803 744806 744807 746066 746677 751648 755355 755359 759904 760695 770131 772875 774323 779220 787329 788696 789556 790982 796276 799168 799211 799631 802986 803008 803729 807997 808159 809701 811403 811467 815715 816542 818506 819241 819250 819643 824807 825015 826388 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"зрелую женщину в чулках"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"зрелая женщин чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.