Query Metrics
7
Database Queries
7
Different statements
181.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.93 ms (82.11%) |
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 3971 17250 56233 106970 114360 167923 191265 206144 213604 233670 233889 312831 357915 365881 365924 383094 383234 384070 384940 385314 385412 386037 386172 387433 387946 388568 390875 391042 391517 391952 392952 393580 396301 397182 397999 398119 398938 399848 399923 400470 401108 401224 401766 401956 401978 404150 404261 404314 404493 405409 406969 407396 407500 407727 407786 408249 408365 409117 409408 409709 411710 411715 411794 411929 411944 412273 413089 413456 414019 416273 417989 418032 418454 419078 420156 420245 423961 429175 429406 434573 434612 437779 439569 442896 445801 447950 449332 450296 454887 455092 458088 458425 460913 477739 479119 482563 484654 491438 517377 524702 525912 542780 547915 560383 563153 565684 575757 587558 589687 712332 718559 728314 730687 740872 746099 756737 761125 774187 792639 802441 ] |
||||||||||||||||||||||||||||||
|
20.70 ms (11.42%) |
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 575757 547915 542780 560383 563153 565684 712332 587558 589687 792639 802441 728314 774187 746099 756737 761125 718559 388568 396301 398119 404261 404493 409408 167923 387433 390875 391042 391952 398938 399848 407396 442896 460913 479119 391517 420156 423961 437779 233670 233889 312831 365881 365924 409117 411929 414019 417989 434573 447950 455092 406969 491438 524702 517377 525912 740872 730687 386172 385412 386037 383094 384070 384940 385314 383234 206144 106970 114360 213604 191265 393580 392952 357915 56233 3971 17250 387946 397182 397999 399923 400470 401956 401108 401224 401766 401978 404314 405409 404150 407500 408249 419078 429175 439569 411794 412273 413089 416273 434612 407727 407786 408365 413456 409709 411710 420245 411715 411944 418032 418454 429406 482563 445801 449332 454887 458088 458425 477739 484654 450296 ] |
||||||||||||||||||||||||||||||
|
3.75 ms (2.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"паренек"
]
|
||||||||||||||||||||||||||||||
|
2.66 ms (1.46%) |
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 3971 17250 56233 106970 114360 167923 191265 206144 213604 233670 233889 312831 357915 365881 365924 383094 383234 384070 384940 385314 385412 386037 386172 387433 387946 388568 390875 391042 391517 391952 392952 393580 396301 397182 397999 398119 398938 399848 399923 400470 401108 401224 401766 401956 401978 404150 404261 404314 404493 405409 406969 407396 407500 407727 407786 408249 408365 409117 409408 409709 411710 411715 411794 411929 411944 412273 413089 413456 414019 416273 417989 418032 418454 419078 420156 420245 423961 429175 429406 434573 434612 437779 439569 442896 445801 447950 449332 450296 454887 455092 458088 458425 460913 477739 479119 482563 484654 491438 517377 524702 525912 542780 547915 560383 563153 565684 575757 587558 589687 712332 718559 728314 730687 740872 746099 756737 761125 774187 792639 802441 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парен"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"парен"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.