Query Metrics
7
Database Queries
7
Different statements
192.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.83 ms (86.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 29610 30841 46656 145603 157046 385783 386761 386938 391266 397249 401574 403501 403872 403890 404532 408678 417599 420432 422103 424026 430546 430607 431439 438957 440642 442651 444516 450450 452995 454789 454817 454899 466308 466468 466654 475761 477436 478029 479871 491187 492218 492814 513582 514217 519361 522006 524658 532493 533121 533128 534714 541504 548026 550030 552552 553587 553604 556744 558893 560860 565801 566589 570890 573173 574076 580998 581774 582014 593184 593897 599343 599407 604793 608296 610126 610748 611410 613294 618550 630963 631395 634855 635208 643522 668706 671189 672229 672310 673499 677428 692701 709844 719647 720527 732918 751203 751361 751553 753951 754546 755502 768607 775519 776868 781920 786977 790128 790616 790647 795021 799892 800745 802551 804407 804408 807877 812472 812528 819186 827699 ] |
||||||||||||||||||||||||||||||
|
15.50 ms (8.06%) |
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 534714 560860 692701 553587 593184 634855 635208 643522 613294 630963 812472 775519 800745 804408 768607 732918 751203 751553 608296 46656 442651 29610 403872 819186 454899 454789 533121 566589 550030 558893 790647 799892 475761 466308 477436 408678 466468 479871 514217 524658 533128 570890 541504 671189 677428 719647 553604 565801 599343 755502 754546 751361 574076 420432 385783 145603 491187 548026 672310 709844 672229 556744 580998 599407 610748 604793 753951 802551 424026 466654 404532 492218 430546 532493 478029 450450 492814 522006 386938 438957 519361 513582 386761 422103 581774 631395 401574 430607 431439 157046 391266 403501 827699 573173 582014 552552 673499 668706 720527 618550 611410 610126 781920 776868 790128 790616 786977 795021 804407 807877 812528 397249 417599 593897 454817 444516 30841 403890 440642 452995 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.42%) |
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 29610 30841 46656 145603 157046 385783 386761 386938 391266 397249 401574 403501 403872 403890 404532 408678 417599 420432 422103 424026 430546 430607 431439 438957 440642 442651 444516 450450 452995 454789 454817 454899 466308 466468 466654 475761 477436 478029 479871 491187 492218 492814 513582 514217 519361 522006 524658 532493 533121 533128 534714 541504 548026 550030 552552 553587 553604 556744 558893 560860 565801 566589 570890 573173 574076 580998 581774 582014 593184 593897 599343 599407 604793 608296 610126 610748 611410 613294 618550 630963 631395 634855 635208 643522 668706 671189 672229 672310 673499 677428 692701 709844 719647 720527 732918 751203 751361 751553 753951 754546 755502 768607 775519 776868 781920 786977 790128 790616 790647 795021 799892 800745 802551 804407 804408 807877 812472 812528 819186 827699 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"naked girls solo"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"голые девушк соло"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.81%) |
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.