Query Metrics
7
Database Queries
7
Different statements
151.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.26 ms (83.39%) |
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 24034 198365 233147 233622 365948 382937 390720 390875 400691 401393 402404 403323 411329 411333 411336 411340 420005 420702 422380 426407 428839 432494 432503 433617 433775 437444 438972 443692 444130 444137 444670 453604 455643 456716 457847 461464 462047 462658 463104 463203 464928 466334 466895 467024 467704 470143 472012 472409 473849 475557 477129 477995 479995 480672 483439 485408 485622 485986 486437 486508 489376 492197 498165 498206 502366 506561 508657 509179 509966 510655 512321 516387 526053 537987 539366 547205 549724 554237 558123 576117 579608 579957 582477 600114 601409 650030 653273 654532 656089 657104 657421 657634 657955 658036 658047 659558 660526 673541 675046 683257 696328 701527 703438 713369 730345 741713 745744 755891 758185 783291 790280 791329 791723 804908 818090 819355 820196 820382 824547 825570 ] |
||||||||||||||||||||||||||||||
|
16.30 ms (10.76%) |
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 400691 233147 444130 475557 453604 485986 486508 510655 411340 457847 526053 537987 509179 783291 403323 428839 479995 432494 472409 411329 443692 472012 477995 492197 485622 486437 502366 516387 701527 730345 600114 438972 506561 467704 657104 390875 444137 390720 467024 470143 420005 426407 233622 432503 437444 462658 512321 509966 650030 804908 755891 462047 745744 24034 818090 825570 489376 422380 198365 401393 420702 402404 461464 485408 820196 824547 539366 382937 444670 576117 579957 579608 582477 549724 411333 464928 411336 466895 473849 480672 455643 466334 433617 433775 463104 456716 498165 498206 477129 558123 683257 713369 790280 791329 791723 741713 758185 463203 365948 483439 508657 819355 820382 653273 656089 657955 703438 654532 657421 657634 658036 660526 673541 696328 658047 659558 675046 547205 554237 601409 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.58%) |
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 24034 198365 233147 233622 365948 382937 390720 390875 400691 401393 402404 403323 411329 411333 411336 411340 420005 420702 422380 426407 428839 432494 432503 433617 433775 437444 438972 443692 444130 444137 444670 453604 455643 456716 457847 461464 462047 462658 463104 463203 464928 466334 466895 467024 467704 470143 472012 472409 473849 475557 477129 477995 479995 480672 483439 485408 485622 485986 486437 486508 489376 492197 498165 498206 502366 506561 508657 509179 509966 510655 512321 516387 526053 537987 539366 547205 549724 554237 558123 576117 579608 579957 582477 600114 601409 650030 653273 654532 656089 657104 657421 657634 657955 658036 658047 659558 660526 673541 675046 683257 696328 701527 703438 713369 730345 741713 745744 755891 758185 783291 790280 791329 791723 804908 818090 819355 820196 820382 824547 825570 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big natural russian"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие натуральная натуральные русск"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.35 ms (0.89%) |
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.