Query Metrics
7
Database Queries
7
Different statements
168.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.87 ms (85.30%) |
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 55966 385003 391546 392775 397218 399520 401059 401221 401282 402027 407552 409144 413264 415862 416360 417095 418725 421294 421793 425481 425603 426810 428512 428653 428880 430144 431494 432790 434168 434201 437803 443859 445233 447023 448635 448970 449405 449667 452441 454250 454860 454869 457654 458141 461017 464109 465143 466721 467095 468060 469919 473913 476049 476943 477579 478796 479471 479991 480434 484918 485319 485782 489395 492610 501547 502791 507889 508159 510233 510762 512790 513123 516354 517042 518175 519319 519833 520204 523487 524413 526037 526320 530303 531632 532011 540623 547646 548570 550102 550630 555885 559680 559691 563917 563930 569556 570901 598836 600201 600686 603896 604503 620300 624227 683424 685669 687604 693023 693024 693944 698289 699056 700540 702077 703144 712771 748237 759658 794089 799060 ] |
||||||||||||||||||||||||||||||
|
15.25 ms (9.04%) |
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 417095 531632 519833 532011 476943 510233 464109 559680 604503 416360 448970 385003 489395 526320 517042 540623 699056 570901 794089 391546 479991 402027 458141 454860 502791 523487 526037 397218 421294 428880 485319 449405 524413 510762 461017 550102 685669 693024 683424 550630 559691 598836 624227 700540 418725 413264 445233 421793 457654 476049 479471 484918 401059 434201 548570 425603 520204 437803 428653 703144 563917 600686 748237 401221 407552 432790 473913 409144 478796 428512 512790 518175 693944 469919 477579 430144 443859 434168 485782 452441 513123 555885 569556 693023 698289 563930 620300 799060 448635 425481 426810 431494 468060 399520 480434 401282 447023 507889 492610 501547 519319 516354 55966 415862 466721 530303 467095 547646 702077 712771 687604 603896 600201 759658 392775 454869 449667 454250 465143 508159 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.50%) |
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 55966 385003 391546 392775 397218 399520 401059 401221 401282 402027 407552 409144 413264 415862 416360 417095 418725 421294 421793 425481 425603 426810 428512 428653 428880 430144 431494 432790 434168 434201 437803 443859 445233 447023 448635 448970 449405 449667 452441 454250 454860 454869 457654 458141 461017 464109 465143 466721 467095 468060 469919 473913 476049 476943 477579 478796 479471 479991 480434 484918 485319 485782 489395 492610 501547 502791 507889 508159 510233 510762 512790 513123 516354 517042 518175 519319 519833 520204 523487 524413 526037 526320 530303 531632 532011 540623 547646 548570 550102 550630 555885 559680 559691 563917 563930 569556 570901 598836 600201 600686 603896 604503 620300 624227 683424 685669 687604 693023 693024 693944 698289 699056 700540 702077 703144 712771 748237 759658 794089 799060 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"daughter сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"daughter tits"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"daughter сиськ"
]
|
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.