Query Metrics
7
Database Queries
7
Different statements
197.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.52 ms (87.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 28786 67112 123769 153311 172925 191406 232995 246527 325706 381767 382274 382636 383274 383727 384047 384315 385323 385815 385964 388740 389174 389925 390461 393497 394552 401384 401451 405852 407127 407685 411223 411696 413708 419549 437918 446173 450273 457056 457596 457598 457605 457665 457666 460625 469827 473707 485005 491240 495581 507830 511286 511314 511781 524470 524493 525610 529986 535108 537127 540469 544322 546459 550040 550163 550641 551540 552883 557857 558101 560731 563966 566559 568822 570098 576654 590598 590992 591056 591482 601956 610544 621347 625342 629572 642401 648470 675380 712467 731788 774138 783417 786120 794218 794878 807760 816712 817657 817848 818667 819164 819650 819761 820057 820377 820381 822553 822688 823016 823156 823511 823582 824188 824194 824212 824299 824453 824484 824623 825261 ] |
||||||||||||||||||||||||||||||
|
14.07 ms (7.11%) |
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 540469 823016 411223 385323 393497 457665 610544 457598 389925 774138 389174 823582 525610 590992 385964 820381 560731 557857 642401 621347 446173 384315 824453 552883 570098 712467 820377 824623 824212 825261 460625 383274 172925 819650 550641 411696 544322 413708 824484 535108 786120 558101 824188 511286 563966 824194 450273 495581 794218 794878 191406 820057 823511 537127 568822 590598 491240 550163 381767 123769 817657 546459 648470 818667 823156 819164 783417 566559 591056 394552 405852 822553 457056 383727 385815 325706 469827 550040 629572 419549 511314 731788 817848 67112 382636 388740 437918 401451 153311 511781 246527 524470 507830 601956 407685 675380 529986 591482 807760 625342 384047 473707 816712 822688 819761 28786 232995 407127 485005 390461 382274 824299 457596 639224 457666 457605 524493 576654 551540 401384 ] |
||||||||||||||||||||||||||||||
|
3.32 ms (1.68%) |
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 28786 67112 123769 153311 172925 191406 232995 246527 325706 381767 382274 382636 383274 383727 384047 384315 385323 385815 385964 388740 389174 389925 390461 393497 394552 401384 401451 405852 407127 407685 411223 411696 413708 419549 437918 446173 450273 457056 457596 457598 457605 457665 457666 460625 469827 473707 485005 491240 495581 507830 511286 511314 511781 524470 524493 525610 529986 535108 537127 540469 544322 546459 550040 550163 550641 551540 552883 557857 558101 560731 563966 566559 568822 570098 576654 590598 590992 591056 591482 601956 610544 621347 625342 629572 642401 648470 675380 712467 731788 774138 783417 786120 794218 794878 807760 816712 817657 817848 818667 819164 819650 819761 820057 820377 820381 822553 822688 823016 823156 823511 823582 824188 824194 824212 824299 824453 824484 824623 825261 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ кухн"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits kitchen"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.26 ms (0.63%) |
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.