Query Metrics
7
Database Queries
7
Different statements
144.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.50 ms (81.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 12792 235834 282006 382017 382456 384856 393127 393731 393732 394197 396891 398390 399194 399223 399332 400422 400438 401142 401306 401343 402245 403060 404264 405567 411958 413197 417429 429249 445039 462500 462579 463141 467364 468013 470703 476155 485308 485489 491646 492392 495372 509965 512679 513036 514386 515285 521854 525671 526038 528344 529206 542972 543547 546001 549296 550620 562119 564440 565332 567002 567151 567159 568573 569678 571188 571214 572197 575723 578481 581697 581703 596585 600793 627818 629293 634545 637692 649996 656739 658413 659608 665027 667323 670081 670175 676453 677056 679385 682022 683538 683825 686040 689757 697307 700663 707329 714455 715323 720435 722654 722662 722665 723406 728350 729890 735800 741999 743144 744298 755746 778550 789210 792722 795286 804113 809053 812361 814065 825563 ] |
||||||||||||||||||||||||||||||
|
17.71 ms (12.27%) |
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 707329 384856 399194 417429 513036 677056 637692 741999 722662 670175 543547 600793 467364 445039 812361 722665 393732 413197 526038 667323 700663 800948 399332 401142 485489 581703 542972 572197 679385 562119 462500 400438 462579 495372 512679 521854 528344 529206 659608 686040 689757 656739 658413 629293 404264 578481 401343 569678 567151 509965 665027 729890 755746 735800 792722 396891 401306 470703 575723 567002 571188 581697 715323 596585 627818 778550 393731 394197 429249 468013 235834 393127 398390 405567 476155 515285 485308 568573 565332 567159 514386 492392 491646 382017 720435 743144 403060 714455 546001 634545 282006 697307 814065 550620 683538 682022 683825 722654 723406 649996 670081 789210 795286 728350 744298 804113 809053 402245 525671 382456 564440 676453 571214 463141 400422 12792 399223 411958 825563 549296 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.60%) |
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 12792 235834 282006 382017 382456 384856 393127 393731 393732 394197 396891 398390 399194 399223 399332 400422 400438 401142 401306 401343 402245 403060 404264 405567 411958 413197 417429 429249 445039 462500 462579 463141 467364 468013 470703 476155 485308 485489 491646 492392 495372 509965 512679 513036 514386 515285 521854 525671 526038 528344 529206 542972 543547 546001 549296 550620 562119 564440 565332 567002 567151 567159 568573 569678 571188 571214 572197 575723 578481 581697 581703 596585 600793 627818 629293 634545 637692 649996 656739 658413 659608 665027 667323 670081 670175 676453 677056 679385 682022 683538 683825 686040 689757 697307 700663 707329 714455 715323 720435 722654 722662 722665 723406 728350 729890 735800 741999 743144 744298 755746 778550 789210 792722 795286 804113 809053 812361 814065 825563 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful young girl"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая young девушк"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.98%) |
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.