Query Metrics
7
Database Queries
7
Different statements
384.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.24 ms (54.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian hairy"
]
|
||||||||||||||||||||||||||||||
|
154.79 ms (40.28%) |
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 163368 212138 381963 384092 386068 389525 392439 393129 396451 396602 396989 398105 399018 401509 406907 416143 419056 423139 428960 429341 429534 442620 446893 457979 458545 460962 463729 473751 476153 476162 495155 496114 505352 512033 512200 512204 513802 516452 516853 525069 540213 546086 546428 550732 550750 550775 551979 551993 551999 552000 552297 552911 552928 554320 556408 558369 559854 559880 559895 559968 565470 572746 584681 585825 591836 591911 591955 595705 600544 600583 600830 603213 605069 606487 607532 607845 610365 617493 619413 619420 619429 619435 619463 622122 622601 622639 623542 623555 628909 634756 634760 637740 651667 664267 671839 688677 690771 694468 696125 702609 712169 712188 712219 718955 720678 737125 737132 737136 737144 742475 749518 754784 755312 759315 781122 802266 802831 810016 818351 825405 ] |
||||||||||||||||||||||||||||||
|
12.89 ms (3.36%) |
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 540213 512033 516452 550732 651667 712219 664267 694468 550775 572746 619429 634756 595705 619413 622639 591911 802831 810016 737132 607532 720678 396989 423139 399018 818351 525069 496114 546428 552297 690771 696125 712188 550750 559880 622122 600830 637740 607845 606487 781122 749518 742475 755312 617493 623555 389525 825405 446893 513802 512200 546086 702609 559854 591836 591955 600583 428960 476153 398105 512204 559895 603213 381963 622601 396451 429341 386068 163368 473751 516853 460962 552928 551993 552000 556408 559968 554320 565470 712169 718955 551999 585825 628909 610365 600544 619420 619435 605069 802266 737125 634760 463729 393129 457979 416143 406907 737136 384092 392439 429534 442620 558369 584681 671839 688677 619463 623542 759315 737144 754784 458545 476162 551979 401509 396602 212138 419056 495155 505352 552911 ] |
||||||||||||||||||||||||||||||
|
3.41 ms (0.89%) |
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 163368 212138 381963 384092 386068 389525 392439 393129 396451 396602 396989 398105 399018 401509 406907 416143 419056 423139 428960 429341 429534 442620 446893 457979 458545 460962 463729 473751 476153 476162 495155 496114 505352 512033 512200 512204 513802 516452 516853 525069 540213 546086 546428 550732 550750 550775 551979 551993 551999 552000 552297 552911 552928 554320 556408 558369 559854 559880 559895 559968 565470 572746 584681 585825 591836 591911 591955 595705 600544 600583 600830 603213 605069 606487 607532 607845 610365 617493 619413 619420 619429 619435 619463 622122 622601 622639 623542 623555 628909 634756 634760 637740 651667 664267 671839 688677 690771 694468 696125 702609 712169 712188 712219 718955 720678 737125 737132 737136 737144 742475 749518 754784 755312 759315 781122 802266 802831 810016 818351 825405 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.38%) |
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.