Query Metrics
7
Database Queries
7
Different statements
362.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
205.68 ms (56.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian big ass"
]
|
||||||||||||||||||||||||||||||
|
134.26 ms (37.04%) |
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 122846 178567 212138 382176 384092 387143 388522 390804 394754 396922 401122 410606 411186 412930 415950 417265 420218 420808 423703 428870 429764 433152 435635 435658 443598 444117 445766 448315 456400 457097 465076 473060 475250 475804 478454 492178 508962 510579 510669 512180 512205 512220 512683 513087 514341 516430 517685 520151 520629 529436 531051 533117 533136 533145 545532 550748 551028 551941 551992 552024 552638 554298 554789 557199 557543 557823 560127 566003 572737 590924 590966 600629 601081 605848 609992 611208 611314 619411 619433 619441 619445 619487 622622 622656 623601 630015 632605 634755 634760 637115 639310 640685 641452 654451 658208 662069 671837 672031 672261 706373 712154 717298 717898 717921 720889 743436 754812 755341 762296 766566 767286 774294 774690 776554 786472 795539 802533 808775 820757 825468 ] |
||||||||||||||||||||||||||||||
|
14.39 ms (3.97%) |
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 776554 634755 634760 178567 475250 712154 619487 671837 658208 619445 456400 572737 560127 533136 566003 475804 122846 428870 412930 443598 445766 473060 512220 516430 512180 551028 551992 619433 640685 394754 420808 529436 387143 672031 766566 706373 552024 557823 384092 382176 390804 401122 478454 512683 514341 531051 533117 662069 717921 720889 552638 611208 630015 641452 786472 754812 802533 762296 774294 743436 755341 623601 717298 423703 590966 212138 508962 557199 545532 512205 533145 415950 435658 417265 590924 609992 622622 774690 767286 517685 637115 632605 433152 429764 388522 554789 551941 550748 554298 619411 420218 396922 444117 435635 448315 465076 520629 510669 492178 672261 654451 557543 611314 619441 601081 605848 622656 639310 795539 808775 457097 510579 820757 825468 600629 513087 717898 411186 520151 410606 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (0.87%) |
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 122846 178567 212138 382176 384092 387143 388522 390804 394754 396922 401122 410606 411186 412930 415950 417265 420218 420808 423703 428870 429764 433152 435635 435658 443598 444117 445766 448315 456400 457097 465076 473060 475250 475804 478454 492178 508962 510579 510669 512180 512205 512220 512683 513087 514341 516430 517685 520151 520629 529436 531051 533117 533136 533145 545532 550748 551028 551941 551992 552024 552638 554298 554789 557199 557543 557823 560127 566003 572737 590924 590966 600629 601081 605848 609992 611208 611314 619411 619433 619441 619445 619487 622622 622656 623601 630015 632605 634755 634760 637115 639310 640685 641452 654451 658208 662069 671837 672031 672261 706373 712154 717298 717898 717921 720889 743436 754812 755341 762296 766566 767286 774294 774690 776554 786472 795539 802533 808775 820757 825468 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"азиатк большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.