Query Metrics
7
Database Queries
7
Different statements
154.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.56 ms (85.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 154410 270135 328609 378309 379330 386650 396558 396578 396586 396594 397988 404217 405799 445740 445751 463906 468525 516750 516770 516775 518975 530028 530397 530612 530911 531114 531126 531225 531242 532852 532902 534986 534993 534995 544833 553282 562491 563457 568543 590312 590850 597197 599631 599971 604079 604661 609452 617418 617429 617437 631247 632645 632655 639027 640723 641359 641678 643406 644961 650012 666819 668145 673580 674978 676808 678127 681687 684213 689374 692069 716745 716878 717318 720900 721983 725058 726193 727888 732336 741288 741480 741571 746980 746994 746999 756398 759865 766847 770314 771482 771622 771649 773852 785291 788283 789419 805303 805308 809302 810839 811485 814733 817078 818252 818385 818587 819122 821695 821729 821905 822262 822578 822728 822922 823129 823289 823421 823794 825142 ] |
||||||||||||||||||||||||||||||
|
12.95 ms (8.40%) |
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 721983 386650 666819 532902 534986 516750 445751 404217 463906 823794 531114 518975 716745 746980 746994 640723 599971 785291 809302 553282 617429 632655 692069 771649 821695 405799 597197 770314 766847 154410 741288 771482 681687 756398 562491 821905 684213 814733 678127 717318 822993 811485 531126 644961 531242 532852 674978 396578 650012 643406 805308 822728 822922 531225 639027 788283 396586 676808 810839 822578 396558 468525 818252 617418 725058 818587 818385 822262 741571 516770 590312 544833 328609 590850 534995 720900 771622 746999 604079 617437 632645 821729 789419 819122 668145 673580 609452 641359 379330 530028 641678 823289 716878 631247 599631 397988 823421 563457 726193 773852 270135 530397 825142 823129 530612 689374 741480 534993 759865 727888 516775 445740 732336 530911 568543 604661 817078 805303 378309 396594 ] |
||||||||||||||||||||||||||||||
|
3.26 ms (2.11%) |
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 154410 270135 328609 378309 379330 386650 396558 396578 396586 396594 397988 404217 405799 445740 445751 463906 468525 516750 516770 516775 518975 530028 530397 530612 530911 531114 531126 531225 531242 532852 532902 534986 534993 534995 544833 553282 562491 563457 568543 590312 590850 597197 599631 599971 604079 604661 609452 617418 617429 617437 631247 632645 632655 639027 640723 641359 641678 643406 644961 650012 666819 668145 673580 674978 676808 678127 681687 684213 689374 692069 716745 716878 717318 720900 721983 725058 726193 727888 732336 741288 741480 741571 746980 746994 746999 756398 759865 766847 770314 771482 771622 771649 773852 785291 788283 789419 805303 805308 809302 810839 811485 814733 817078 818252 818385 818587 819122 821695 821729 821905 822262 822578 822728 822922 823129 823289 823421 823794 825142 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black cock blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black cock минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black 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.