Query Metrics
7
Database Queries
7
Different statements
146.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.60 ms (84.81%) |
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 543979 544116 545094 549762 550224 551020 561615 563137 563142 563222 563423 563462 566405 567406 567407 567423 574191 574558 583872 584104 588208 589204 590421 592452 595842 598058 599011 605333 605342 615167 619482 620145 620147 621319 621999 622374 624357 627746 627748 628301 643007 644285 644288 644291 644296 644327 644330 645233 645283 646228 648208 649093 649151 649152 649153 649560 650494 650781 651199 651630 652187 659270 669567 669570 670097 670102 670103 670108 670110 671721 671724 671730 671751 672138 672151 672181 672767 677705 677706 683256 683567 687116 687119 690841 690870 691496 692198 692263 694072 694201 695246 695249 695276 696355 697263 697369 698557 699567 699584 699606 700281 703091 703093 703436 703525 703537 703538 703553 705537 706611 708422 708433 712722 716409 719873 727828 742971 748551 789844 790394 ] |
||||||||||||||||||||||||||||||
|
12.14 ms (8.26%) |
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 584104 543979 544116 549762 561615 563142 566405 567406 567407 574191 645283 646228 648208 649152 649153 649560 650494 652187 670102 670110 672767 683567 690841 690870 692198 694201 695276 703537 712722 716409 645233 649151 650781 651199 651630 670097 670108 671721 672138 672151 672181 677705 677706 687116 691496 694072 696355 697369 698557 699584 699606 700281 703093 703525 706611 719873 649093 659270 669567 669570 670103 671724 671730 671751 683256 687119 692263 695246 695249 697263 699567 703538 703553 705537 708422 708433 545094 550224 551020 563137 563222 563423 563462 567423 574558 583872 588208 589204 598058 620145 620147 621999 644285 644288 644291 590421 605342 621319 622374 592452 595842 599011 615167 627746 627748 643007 619482 644327 790394 748551 789844 727828 742971 605333 624357 628301 644296 644330 703091 703436 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (2.00%) |
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 543979 544116 545094 549762 550224 551020 561615 563137 563142 563222 563423 563462 566405 567406 567407 567423 574191 574558 583872 584104 588208 589204 590421 592452 595842 598058 599011 605333 605342 615167 619482 620145 620147 621319 621999 622374 624357 627746 627748 628301 643007 644285 644288 644291 644296 644327 644330 645233 645283 646228 648208 649093 649151 649152 649153 649560 650494 650781 651199 651630 652187 659270 669567 669570 670097 670102 670103 670108 670110 671721 671724 671730 671751 672138 672151 672181 672767 677705 677706 683256 683567 687116 687119 690841 690870 691496 692198 692263 694072 694201 695246 695249 695276 696355 697263 697369 698557 699567 699584 699606 700281 703091 703093 703436 703525 703537 703538 703553 705537 706611 708422 708433 712722 716409 719873 727828 742971 748551 789844 790394 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"vintage sperm"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"vintage сперм"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"vintage сперм"
]
|
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.