Query Metrics
7
Database Queries
7
Different statements
264.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
240.39 ms (90.77%) |
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 74434 382724 385486 386211 390747 390923 391915 405100 407761 412756 413499 419715 420003 422576 422584 422589 422656 422881 423412 424720 426104 428319 441251 443043 444859 445373 451324 453248 456625 468715 468772 472150 473928 475222 483963 485174 499817 504765 516450 522586 531075 535333 543376 543960 550433 557993 561100 567539 567915 570716 598745 601161 604048 610341 614467 614731 615575 615718 619147 636277 636546 663458 665132 665490 665830 669593 670955 673048 674356 677955 694075 699697 705915 709407 709621 723674 730931 740471 740582 742443 744309 744628 746081 748252 752910 755794 757896 767217 767510 779341 782235 789316 790983 796699 799366 799651 799785 801587 803091 804773 805059 805191 807927 808145 808732 809153 811439 814082 815033 816921 817057 817305 817861 818369 819598 821433 822639 822725 822905 827523 ] |
||||||||||||||||||||||||||||||
|
15.83 ms (5.98%) |
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 407761 557993 604048 385486 615575 740471 740582 805191 744309 663458 472150 382724 456625 391915 811439 522586 822725 817861 821433 822905 709621 789316 742443 670955 405100 390747 441251 390923 815033 665490 757896 598745 817305 816921 665830 730931 767510 752910 567539 615718 424720 426104 567915 444859 504765 677955 699697 804773 807927 809153 799366 782235 790983 803091 561100 428319 723674 413499 422576 422584 443043 423412 779341 543960 570716 709407 601161 535333 543376 550433 422589 636277 801587 799785 74434 422656 453248 473928 412756 422881 796699 614467 499817 485174 814082 817057 818369 610341 636546 614731 808732 744628 746081 767217 468772 694075 468715 451324 445373 475222 665132 386211 419715 483963 516450 827523 748252 420003 673048 531075 819598 822639 705915 669593 674356 619147 799651 808145 805059 755794 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (0.95%) |
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 74434 382724 385486 386211 390747 390923 391915 405100 407761 412756 413499 419715 420003 422576 422584 422589 422656 422881 423412 424720 426104 428319 441251 443043 444859 445373 451324 453248 456625 468715 468772 472150 473928 475222 483963 485174 499817 504765 516450 522586 531075 535333 543376 543960 550433 557993 561100 567539 567915 570716 598745 601161 604048 610341 614467 614731 615575 615718 619147 636277 636546 663458 665132 665490 665830 669593 670955 673048 674356 677955 694075 699697 705915 709407 709621 723674 730931 740471 740582 742443 744309 744628 746081 748252 752910 755794 757896 767217 767510 779341 782235 789316 790983 796699 799366 799651 799785 801587 803091 804773 805059 805191 807927 808145 808732 809153 811439 814082 815033 816921 817057 817305 817861 818369 819598 821433 822639 822725 822905 827523 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young girl stockings"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.67%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young девушк чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.25 ms (0.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.22 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young девушк чулк нижн бел"
]
|
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.