Query Metrics
7
Database Queries
7
Different statements
142.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.71 ms (84.16%) |
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 20429 82217 273921 383549 383730 399036 401513 411009 414048 423464 429341 431603 443497 443602 443611 445811 448734 452441 454685 456005 456623 456639 457812 460938 460950 473746 473751 475250 476055 488379 500570 511263 512218 528696 530345 532927 535095 539860 545473 546039 547102 547518 547663 551957 551960 552019 552827 552933 558364 559889 559898 564595 566067 572727 572736 572739 575505 576858 580182 582201 593431 595056 595269 596689 596785 600629 605380 606681 608009 614024 616578 618712 619491 622622 634760 640922 642221 642787 651530 653838 676542 686082 691050 711994 712182 712720 717845 720333 722438 727656 729857 730868 730872 735622 737144 742467 743739 744885 747987 749532 754954 755341 758879 761580 765559 771928 779545 783995 785708 786454 787884 793633 793657 795691 795708 799721 800797 812154 816856 822535 ] |
||||||||||||||||||||||||||||||
|
12.89 ms (9.06%) |
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 595056 642787 795708 742467 795691 20429 722438 720333 729857 787884 460950 82217 552019 816856 431603 456639 473751 448734 401513 595269 691050 793657 618712 545473 383730 600629 755341 532927 634760 383549 608009 712720 564595 761580 822535 530345 443497 546039 619491 460938 572727 730868 552933 475250 730872 547102 552827 717845 473746 593431 535095 642221 411009 547663 622622 749532 457812 445811 429341 273921 614024 596689 712182 735622 765559 580182 566067 456623 686082 454685 576858 512218 783995 754954 452441 651530 800797 414048 575505 488379 786454 547518 743739 653838 744885 443602 456005 500570 605380 616578 758879 539860 476055 793633 799721 785708 711994 443611 606681 727656 559898 640922 558364 551957 572739 779545 737144 423464 528696 676542 551960 596785 511263 812154 747987 582201 559889 771928 399036 572736 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (2.14%) |
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 20429 82217 273921 383549 383730 399036 401513 411009 414048 423464 429341 431603 443497 443602 443611 445811 448734 452441 454685 456005 456623 456639 457812 460938 460950 473746 473751 475250 476055 488379 500570 511263 512218 528696 530345 532927 535095 539860 545473 546039 547102 547518 547663 551957 551960 552019 552827 552933 558364 559889 559898 564595 566067 572727 572736 572739 575505 576858 580182 582201 593431 595056 595269 596689 596785 600629 605380 606681 608009 614024 616578 618712 619491 622622 634760 640922 642221 642787 651530 653838 676542 686082 691050 711994 712182 712720 717845 720333 722438 727656 729857 730868 730872 735622 737144 742467 743739 744885 747987 749532 754954 755341 758879 761580 765559 771928 779545 783995 785708 786454 787884 793633 793657 795691 795708 799721 800797 812154 816856 822535 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian fucking girl"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк fucking девушк"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"азиатк fucking девушк"
]
|
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.