Query Metrics
7
Database Queries
7
Different statements
170.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.64 ms (83.53%) |
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 154707 212864 236378 282038 360303 401035 402631 403227 403901 407423 410305 410310 413131 413641 421038 423673 425251 425359 426470 428267 431794 444428 445083 454195 457581 460598 462369 487013 487275 490692 491862 492246 492440 494540 501703 509643 511670 513022 517693 523759 525822 528871 530635 531390 532390 534665 535543 536518 536523 537319 537857 537871 537872 552989 561887 562506 564759 566669 578433 582794 583199 587183 596133 598044 599566 603358 604921 605184 607599 612265 613163 623338 628343 628633 633120 638183 638477 650449 660375 669239 669786 671541 672740 672754 673719 676118 683664 708517 715460 717797 720434 722519 724527 733708 736437 752094 752147 752766 757221 757667 758483 759117 759139 760114 771008 774908 781826 782007 788255 789528 792572 803373 804234 804445 806301 806983 810704 810839 814294 827290 ] |
||||||||||||||||||||||||||||||
|
17.56 ms (10.28%) |
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 425251 487013 511670 537319 501703 513022 535543 583199 708517 715460 552989 582794 596133 612265 628343 804234 781826 724527 154707 410310 528871 426470 669239 212864 413641 536523 660375 534665 672740 603358 628633 810839 407423 413131 814294 536518 537871 531390 487275 562506 561887 566669 669786 672754 676118 683664 650449 671541 673719 717797 720434 722519 578433 604921 633120 587183 598044 605184 638477 803373 774908 789528 804445 806301 806983 757221 759117 792572 810704 733708 736437 759139 771008 752094 752147 757667 760114 752766 758483 613163 623338 638183 782007 788255 423673 425359 444428 462369 460598 431794 607599 401035 509643 523759 236378 403227 532390 599566 403901 360303 564759 282038 402631 410305 428267 445083 421038 827290 491862 492246 492440 457581 454195 490692 494540 517693 530635 537857 537872 525822 ] |
||||||||||||||||||||||||||||||
|
3.48 ms (2.04%) |
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 154707 212864 236378 282038 360303 401035 402631 403227 403901 407423 410305 410310 413131 413641 421038 423673 425251 425359 426470 428267 431794 444428 445083 454195 457581 460598 462369 487013 487275 490692 491862 492246 492440 494540 501703 509643 511670 513022 517693 523759 525822 528871 530635 531390 532390 534665 535543 536518 536523 537319 537857 537871 537872 552989 561887 562506 564759 566669 578433 582794 583199 587183 596133 598044 599566 603358 604921 605184 607599 612265 613163 623338 628343 628633 633120 638183 638477 650449 660375 669239 669786 671541 672740 672754 673719 676118 683664 708517 715460 717797 720434 722519 724527 733708 736437 752094 752147 752766 757221 757667 758483 759117 759139 760114 771008 774908 781826 782007 788255 789528 792572 803373 804234 804445 806301 806983 810704 810839 814294 827290 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge natural boobs"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные натуральная натуральные boobs"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"огромные натуральная натуральные boobs"
]
|
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.