Query Metrics
7
Database Queries
7
Different statements
391.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
363.06 ms (92.63%) |
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 91473 307458 385245 388313 388347 396971 397802 409150 410695 411310 417921 422336 449091 453465 469693 485069 487351 489848 496144 496460 497381 507550 508696 509163 516064 527207 532509 534207 540530 546222 550195 551662 552589 556625 562992 563684 565510 569580 571130 571437 572360 581284 581345 600718 604937 605527 610484 612622 623479 623656 630671 637789 671871 680300 681307 693563 693795 697197 697217 697220 699538 702280 705054 705332 710431 714553 717697 718694 718820 720521 721219 723565 723965 725398 726110 726276 741891 742702 745475 751661 757751 764097 769726 782428 784003 788226 790815 794394 794403 795038 795998 797347 804116 804466 808044 813002 814127 815321 818760 818763 819290 819447 819702 819729 819855 820039 820525 821293 823255 823257 823862 823977 824895 825892 826634 826882 827518 827541 828825 ] |
||||||||||||||||||||||||||||||
|
18.38 ms (4.69%) |
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 745475 496460 563684 385245 307458 396971 409150 411310 422336 819855 453465 556625 562992 552589 693563 697220 681307 604937 623656 605527 797347 804466 788226 795998 751661 764097 769726 718694 782428 410695 449091 388313 469693 417921 795038 757751 723965 742702 804116 489848 680300 741891 725398 726110 388347 509163 697217 702280 705054 610484 794394 790815 813002 726276 623479 705332 794403 527207 487351 507550 532509 496144 571130 565510 784003 808044 508696 550195 551662 572360 569580 630671 91473 397802 823255 723565 826634 814127 815321 823257 823977 824895 827518 827541 818760 818763 819290 819447 819729 820039 825892 826439 819702 820525 821293 823862 828825 826882 485069 534207 516064 497381 540530 571437 581284 693795 718820 720521 721219 671871 697197 699538 710431 714553 717697 546222 581345 612622 600718 637789 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (0.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 91473 307458 385245 388313 388347 396971 397802 409150 410695 411310 417921 422336 449091 453465 469693 485069 487351 489848 496144 496460 497381 507550 508696 509163 516064 527207 532509 534207 540530 546222 550195 551662 552589 556625 562992 563684 565510 569580 571130 571437 572360 581284 581345 600718 604937 605527 610484 612622 623479 623656 630671 637789 671871 680300 681307 693563 693795 697197 697217 697220 699538 702280 705054 705332 710431 714553 717697 718694 718820 720521 721219 723565 723965 725398 726110 726276 741891 742702 745475 751661 757751 764097 769726 782428 784003 788226 790815 794394 794403 795038 795998 797347 804116 804466 808044 813002 814127 815321 818760 818763 819290 819447 819702 819729 819855 820039 820525 821293 823255 823257 823862 823977 824895 825892 826634 826882 827518 827541 828825 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (0.60%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf pussy sperm"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf pussy сперм"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf pussy сперм"
]
|
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.