Query Metrics
7
Database Queries
7
Different statements
265.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
240.22 ms (90.41%) |
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 461425 461701 463326 472102 489009 495412 498988 505293 506487 507808 510483 512004 516746 518359 520582 527095 530554 533234 534072 540969 541013 541547 541907 543829 546274 547980 550226 551145 551544 555652 557398 567750 571095 571727 572219 572230 581054 584889 585237 586148 588116 591779 593223 595098 599693 603564 605565 608519 614695 619011 619296 619727 620905 621105 623884 623909 624315 625637 628227 628909 638906 641691 641865 646012 654230 660467 663567 670238 670546 672877 673506 675628 677918 677922 686285 686977 688745 690621 697101 697717 701505 710902 713160 714542 714548 715826 716364 720395 722276 724713 724916 727343 728987 737307 739236 743937 746137 747954 748639 755918 756655 761096 761123 761185 763360 764285 764802 769233 773586 780029 782868 783612 783871 785584 786820 787928 788313 791997 800270 800975 ] |
||||||||||||||||||||||||||||||
|
13.25 ms (4.99%) |
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 520582 527095 498988 505293 506487 507808 512004 518359 530554 533234 534072 461425 472102 540969 546274 547980 567750 581054 541013 572219 584889 541547 541907 550226 551145 555652 646012 670546 673506 688745 697101 714542 715826 660467 677918 697717 713160 722276 663567 670238 672877 675628 677922 690621 701505 714548 716364 720395 571095 571727 572230 588116 593223 595098 603564 619727 628227 628909 641865 585237 599693 608519 619296 623909 624315 638906 586148 591779 619011 620905 623884 641691 780029 783612 791997 800975 782868 727343 769233 785584 800270 748639 761123 724713 746137 764285 728987 743937 761185 763360 724916 737307 755918 756655 764802 773586 614695 621105 710902 783871 786820 787928 788313 461701 489009 495412 510483 516746 463326 543829 557398 551544 654230 686977 686285 605565 739236 747954 761096 625637 ] |
||||||||||||||||||||||||||||||
|
4.64 ms (1.75%) |
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 461425 461701 463326 472102 489009 495412 498988 505293 506487 507808 510483 512004 516746 518359 520582 527095 530554 533234 534072 540969 541013 541547 541907 543829 546274 547980 550226 551145 551544 555652 557398 567750 571095 571727 572219 572230 581054 584889 585237 586148 588116 591779 593223 595098 599693 603564 605565 608519 614695 619011 619296 619727 620905 621105 623884 623909 624315 625637 628227 628909 638906 641691 641865 646012 654230 660467 663567 670238 670546 672877 673506 675628 677918 677922 686285 686977 688745 690621 697101 697717 701505 710902 713160 714542 714548 715826 716364 720395 722276 724713 724916 727343 728987 737307 739236 743937 746137 747954 748639 755918 756655 761096 761123 761185 763360 764285 764802 769233 773586 780029 782868 783612 783871 785584 786820 787928 788313 791997 800270 800975 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая cock вебкамер"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small cock webcam"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая cock вебкамер"
]
|
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.