Query Metrics
7
Database Queries
7
Different statements
188.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.83 ms (83.85%) |
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 326017 398464 420111 421825 423571 425712 427738 434673 436063 441449 441505 447883 448468 449566 449752 451050 453476 453889 455498 457970 458061 458995 459745 460349 460375 461417 474029 475881 481389 481747 482489 483687 488408 489181 489226 490194 490768 493170 495449 500498 501696 502457 502476 503277 503488 507101 508224 509046 509097 510028 510248 511361 511636 513131 514086 514655 516480 517279 517711 517852 519297 522025 524146 526642 526859 527356 528495 528815 530446 534815 535672 544050 546414 549858 551447 552411 554294 555742 559030 560405 560427 562055 563757 564010 566939 575827 579166 579175 579192 588600 592989 593495 594023 599412 600667 603893 612864 623135 624905 625325 625648 626321 637444 638360 650034 650624 670183 682639 684261 708232 722934 723542 728499 782911 790957 792594 794055 813029 813185 814501 ] |
||||||||||||||||||||||||||||||
|
19.43 ms (10.32%) |
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 535672 509046 526859 441449 449752 460349 517852 501696 551447 552411 549858 555742 559030 708232 722934 579192 600667 612864 594023 637444 603893 794055 792594 425712 455498 420111 427738 475881 524146 489181 511636 514655 490768 509097 441505 448468 500498 514086 527356 575827 544050 650034 682639 562055 579166 593495 638360 592989 813029 728499 626321 458061 458995 451050 489226 516480 483687 482489 684261 790957 398464 502476 461417 623135 421825 814501 723542 453476 459745 508224 530446 436063 481747 502457 517279 460375 449566 517711 528495 554294 560427 560405 625648 782911 474029 495449 488408 434673 510248 534815 563757 564010 670183 599412 326017 457970 526642 503488 519297 423571 481389 546414 566939 650624 447883 511361 490194 493170 503277 507101 510028 453889 513131 522025 528815 579175 588600 625325 624905 813185 ] |
||||||||||||||||||||||||||||||
|
3.33 ms (1.77%) |
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 326017 398464 420111 421825 423571 425712 427738 434673 436063 441449 441505 447883 448468 449566 449752 451050 453476 453889 455498 457970 458061 458995 459745 460349 460375 461417 474029 475881 481389 481747 482489 483687 488408 489181 489226 490194 490768 493170 495449 500498 501696 502457 502476 503277 503488 507101 508224 509046 509097 510028 510248 511361 511636 513131 514086 514655 516480 517279 517711 517852 519297 522025 524146 526642 526859 527356 528495 528815 530446 534815 535672 544050 546414 549858 551447 552411 554294 555742 559030 560405 560427 562055 563757 564010 566939 575827 579166 579175 579192 588600 592989 593495 594023 599412 600667 603893 612864 623135 624905 625325 625648 626321 637444 638360 650034 650624 670183 682639 684261 708232 722934 723542 728499 782911 790957 792594 794055 813029 813185 814501 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"made sex"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"made секс"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"made секс"
]
|
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.