Query Metrics
7
Database Queries
7
Different statements
172.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.30 ms (86.22%) |
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 31329 191199 382786 384588 385474 393705 395540 396747 397209 401280 407709 408351 409374 411368 415755 417244 424431 439475 439795 440974 441583 441770 441788 442941 443628 446023 446386 448704 449093 449158 450139 452345 454168 454369 454525 454759 455201 456995 459238 462488 462707 464018 465551 466005 466206 466217 466738 466986 468685 468760 468858 469347 470158 470260 471995 472398 473194 473334 473457 474831 474855 475539 476030 476039 477596 477950 478375 478411 479066 482761 485273 485377 489171 489384 490731 491124 493026 493426 494192 494204 494957 502199 502813 503845 507003 509199 509204 509528 509655 511273 512085 515276 515615 516483 516808 517525 518355 518872 521127 526837 527041 538005 549731 550646 556559 559042 564254 569407 579196 683012 696983 720357 738209 742633 758801 758807 768756 785126 788819 803298 ] |
||||||||||||||||||||||||||||||
|
14.36 ms (8.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 191199 397209 474855 472398 485377 474831 476039 550646 559042 395540 442941 475539 477950 526837 493026 509528 509655 517525 439795 440974 454525 478375 466217 509204 485273 564254 393705 401280 407709 449093 448704 454168 473334 452345 466738 549731 556559 569407 579196 424431 449158 459238 462707 466005 468858 471995 443628 464018 476030 502199 494192 494204 439475 482761 454369 466986 468685 785126 31329 385474 396747 411368 473194 465551 466206 470158 477596 538005 503845 511273 518355 489384 490731 502813 507003 515276 516483 516808 489171 518872 441788 409374 478411 456995 509199 696983 683012 788819 742633 758807 768756 758801 738209 720357 408351 479066 382786 417244 515615 441770 441583 470260 450139 455201 803298 415755 491124 494957 473457 446386 446023 468760 512085 462488 469347 493426 521127 527041 384588 454759 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.64%) |
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 31329 191199 382786 384588 385474 393705 395540 396747 397209 401280 407709 408351 409374 411368 415755 417244 424431 439475 439795 440974 441583 441770 441788 442941 443628 446023 446386 448704 449093 449158 450139 452345 454168 454369 454525 454759 455201 456995 459238 462488 462707 464018 465551 466005 466206 466217 466738 466986 468685 468760 468858 469347 470158 470260 471995 472398 473194 473334 473457 474831 474855 475539 476030 476039 477596 477950 478375 478411 479066 482761 485273 485377 489171 489384 490731 491124 493026 493426 494192 494204 494957 502199 502813 503845 507003 509199 509204 509528 509655 511273 512085 515276 515615 516483 516808 517525 518355 518872 521127 526837 527041 538005 549731 550646 556559 559042 564254 569407 579196 683012 696983 720357 738209 742633 758801 758807 768756 785126 788819 803298 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жирная теща"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"толстая зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.25 ms (0.73%) |
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.