Query Metrics
7
Database Queries
7
Different statements
179.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.40 ms (86.38%) |
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 185353 213509 381775 386662 395445 398713 400696 417945 419238 428929 435962 439285 439341 443439 443443 445948 447515 447762 449626 452890 454754 456319 458738 459496 461150 461256 461582 462523 462724 463169 465794 466022 466237 469725 469845 470141 470266 471169 473994 474005 475216 475577 475608 477198 477254 477386 477908 480651 481158 481218 482736 486361 487548 487845 489596 492807 497071 500698 505035 509446 513885 514785 521872 523978 527586 533675 547726 547982 549794 552211 555955 558045 558856 560642 561896 562072 562236 563359 563694 567186 570374 570513 571594 572160 572765 576728 579219 582398 594164 595373 595506 595888 596673 598027 598818 603679 603712 610891 617096 642111 655066 656079 658360 659277 660910 675048 699515 716591 721264 722924 723725 742131 754577 757774 763746 773638 778622 783206 799844 808412 ] |
||||||||||||||||||||||||||||||
|
13.23 ms (7.35%) |
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 552211 561896 570374 562236 571594 570513 576728 395445 400696 447762 469725 461150 439285 477908 465794 445948 456319 458738 523978 489596 486361 603712 480651 481158 481218 514785 419238 558856 447515 475577 470141 462724 521872 497071 505035 513885 563359 598818 475216 435962 449626 509446 492807 783206 533675 716591 595373 773638 757774 547982 482736 555955 763746 617096 675048 658360 799844 723725 699515 778622 185353 386662 642111 549794 428929 462523 463169 473994 477386 558045 563694 721264 722924 659277 655066 656079 660910 603679 610891 808412 742131 754577 527586 443443 475608 500698 567186 572160 560642 579219 459496 398713 461582 572765 595888 466237 439341 443439 474005 461256 477198 477254 417945 466022 470266 487845 487548 469845 562072 582398 547726 594164 598027 596673 595506 213509 471169 381775 452890 454754 ] |
||||||||||||||||||||||||||||||
|
4.01 ms (2.23%) |
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 185353 213509 381775 386662 395445 398713 400696 417945 419238 428929 435962 439285 439341 443439 443443 445948 447515 447762 449626 452890 454754 456319 458738 459496 461150 461256 461582 462523 462724 463169 465794 466022 466237 469725 469845 470141 470266 471169 473994 474005 475216 475577 475608 477198 477254 477386 477908 480651 481158 481218 482736 486361 487548 487845 489596 492807 497071 500698 505035 509446 513885 514785 521872 523978 527586 533675 547726 547982 549794 552211 555955 558045 558856 560642 561896 562072 562236 563359 563694 567186 570374 570513 571594 572160 572765 576728 579219 582398 594164 595373 595506 595888 596673 598027 598818 603679 603712 610891 617096 642111 655066 656079 658360 659277 660910 675048 699515 716591 721264 722924 723725 742131 754577 757774 763746 773638 778622 783206 799844 808412 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian beautiful girl"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск красивая девушк"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.