Query Metrics
7
Database Queries
7
Different statements
228.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
196.03 ms (85.69%) |
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 5565 263868 349193 384859 392785 395784 396336 401498 402866 408940 411663 412517 413439 416967 417921 421584 421635 425457 432464 435366 437255 438335 441259 441368 443848 446215 446716 449707 453269 453528 455115 455382 456919 458045 458754 459743 460501 461123 461544 461555 461831 462571 462802 463334 464208 464962 466957 467168 467682 467796 469218 469412 469418 469899 469925 472400 473277 474203 476534 476630 479288 479392 480624 483472 484175 484446 486467 489945 490750 491238 492058 496006 498287 499993 502046 504251 506818 506886 507186 509527 510034 511088 511172 516175 517500 520125 524058 524280 528107 529148 538558 540381 551191 552072 554983 557936 558868 560807 561895 564358 569436 569954 570593 570760 571044 573596 615041 619259 624015 723344 725229 726000 726497 759609 767380 781739 789031 790011 799237 803695 ] |
||||||||||||||||||||||||||||||
|
21.53 ms (9.41%) |
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 619259 615041 624015 781739 790011 789031 803695 725229 726497 799237 759609 767380 726000 723344 349193 384859 412517 432464 455115 458754 473277 392785 408940 416967 435366 446215 464962 467796 480624 5565 263868 395784 401498 425457 443848 461555 469218 474203 476534 479288 413439 455382 459743 461123 461544 469925 417921 421635 438335 464208 499993 502046 484446 489945 504251 511172 517500 491238 506818 510034 524280 486467 492058 509527 511088 516175 520125 524058 528107 396336 402866 441368 411663 437255 421584 441259 446716 449707 453269 460501 462571 463334 469412 469418 458045 462802 466957 467168 469899 476630 479392 484175 490750 453528 456919 472400 498287 507186 529148 538558 496006 506886 540381 461831 467682 483472 551191 557936 558868 561895 569436 570760 571044 573596 552072 554983 560807 564358 569954 570593 ] |
||||||||||||||||||||||||||||||
|
3.75 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 5565 263868 349193 384859 392785 395784 396336 401498 402866 408940 411663 412517 413439 416967 417921 421584 421635 425457 432464 435366 437255 438335 441259 441368 443848 446215 446716 449707 453269 453528 455115 455382 456919 458045 458754 459743 460501 461123 461544 461555 461831 462571 462802 463334 464208 464962 466957 467168 467682 467796 469218 469412 469418 469899 469925 472400 473277 474203 476534 476630 479288 479392 480624 483472 484175 484446 486467 489945 490750 491238 492058 496006 498287 499993 502046 504251 506818 506886 507186 509527 510034 511088 511172 516175 517500 520125 524058 524280 528107 529148 538558 540381 551191 552072 554983 557936 558868 560807 561895 564358 569436 569954 570593 570760 571044 573596 615041 619259 624015 723344 725229 726000 726497 759609 767380 781739 789031 790011 799237 803695 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ряд"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ряд"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.76%) |
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.