Query Metrics
7
Database Queries
7
Different statements
177.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.91 ms (82.19%) |
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 382313 391546 392775 399520 401221 401235 401282 404471 406041 407552 408774 409144 409585 410003 412132 413890 415862 418963 421793 425609 426683 426810 428512 428653 430144 431494 432790 433703 434168 437803 441626 445233 447023 448635 448640 449667 452441 454250 454860 454869 457654 457685 461017 461353 464324 466721 466943 467095 468060 469919 473980 477579 478186 478796 479471 479991 480434 483392 485782 489390 489395 492610 494797 500928 501547 503936 505976 507889 508159 509332 510762 512790 513123 514263 516354 518115 518175 518927 519319 522528 522946 523487 524413 526037 527088 528106 528363 528817 530303 544495 547646 550630 555885 559678 559691 563917 563930 569556 600201 600686 603896 610660 615015 620300 683424 687604 693023 693024 693944 698289 700540 702077 703144 712771 721646 748237 759658 794089 799060 ] |
||||||||||||||||||||||||||||||
|
20.65 ms (11.63%) |
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 523487 432790 510762 461017 559691 445233 421793 457654 479471 563917 600686 401221 478796 437803 428653 703144 748237 409144 512790 469919 477579 518115 428512 693944 527088 426683 489395 794089 391546 479991 454860 526037 55966 448635 516354 407552 522528 524413 693024 683424 550630 700540 415862 530303 467095 508159 434168 698289 518175 413890 610660 466721 702077 687604 392775 489390 426810 431494 447023 418963 461353 441626 457685 514263 404471 483392 409585 408774 425609 401235 712771 759658 449667 522946 528106 528817 430144 485782 452441 513123 563930 468060 399520 480434 401282 507889 492610 501547 519319 494797 505976 473980 433703 528363 559678 478186 721646 412132 466943 410003 382313 406041 448640 500928 544495 615015 518927 547646 603896 600201 454869 454250 503936 555885 569556 693023 620300 799060 509332 464324 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (1.82%) |
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 382313 391546 392775 399520 401221 401235 401282 404471 406041 407552 408774 409144 409585 410003 412132 413890 415862 418963 421793 425609 426683 426810 428512 428653 430144 431494 432790 433703 434168 437803 441626 445233 447023 448635 448640 449667 452441 454250 454860 454869 457654 457685 461017 461353 464324 466721 466943 467095 468060 469919 473980 477579 478186 478796 479471 479991 480434 483392 485782 489390 489395 492610 494797 500928 501547 503936 505976 507889 508159 509332 510762 512790 513123 514263 516354 518115 518175 518927 519319 522528 522946 523487 524413 526037 527088 528106 528363 528817 530303 544495 547646 550630 555885 559678 559691 563917 563930 569556 600201 600686 603896 610660 615015 620300 683424 687604 693023 693024 693944 698289 700540 702077 703144 712771 721646 748237 759658 794089 799060 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits daughter"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ daughter"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.01%) |
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.