Query Metrics
7
Database Queries
7
Different statements
210.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.97 ms (84.60%) |
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 7169 366011 382562 382610 383377 384193 385469 389629 392775 393765 395699 396344 398932 401196 404318 411508 417692 418867 419051 425541 428456 428539 429543 430300 435275 435315 443119 443130 444668 446269 447257 453006 454250 455708 456966 458601 463225 468781 470733 471518 471524 472439 473924 477327 477440 481799 482330 484426 484439 487718 495148 504669 511018 514789 515109 515269 517369 518865 519981 519996 521056 526390 526483 526768 534025 540256 544305 545526 546906 550630 559066 562961 563887 565743 566307 567009 569962 574216 574282 584524 586789 598731 607193 620025 620983 622197 645011 663417 667013 686082 687270 687271 687374 709311 709428 712625 714183 721454 724840 728359 741605 742812 743381 744319 745055 746155 771180 773547 781694 781709 781748 790501 790877 807805 808012 809899 810062 810069 818161 826645 ] |
||||||||||||||||||||||||||||||
|
20.49 ms (9.74%) |
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 383377 435315 366011 563887 518865 395699 382610 411508 428539 428456 443119 385469 425541 435275 398932 468781 470733 472439 526390 404318 517369 526483 540256 574282 781709 808012 745055 773547 7169 562961 417692 419051 446269 447257 458601 463225 456966 487718 511018 519981 504669 521056 534025 514789 526768 544305 567009 569962 687270 667013 709428 645011 686082 687271 545526 550630 566307 574216 584524 586789 620025 620983 598731 607193 622197 790877 809899 790501 810069 746155 771180 728359 741605 743381 744319 714183 473924 384193 392775 418867 471524 393765 401196 429543 454250 471518 430300 455708 477440 515109 519996 515269 484426 484439 818161 481799 781748 781694 807805 724840 742812 810062 389629 477327 495148 546906 559066 443130 482330 396344 444668 453006 565743 382562 826645 663417 712625 687374 709311 721454 ] |
||||||||||||||||||||||||||||||
|
4.03 ms (1.92%) |
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 7169 366011 382562 382610 383377 384193 385469 389629 392775 393765 395699 396344 398932 401196 404318 411508 417692 418867 419051 425541 428456 428539 429543 430300 435275 435315 443119 443130 444668 446269 447257 453006 454250 455708 456966 458601 463225 468781 470733 471518 471524 472439 473924 477327 477440 481799 482330 484426 484439 487718 495148 504669 511018 514789 515109 515269 517369 518865 519981 519996 521056 526390 526483 526768 534025 540256 544305 545526 546906 550630 559066 562961 563887 565743 566307 567009 569962 574216 574282 584524 586789 598731 607193 620025 620983 622197 645011 663417 667013 686082 687270 687271 687374 709311 709428 712625 714183 721454 724840 728359 741605 742812 743381 744319 745055 746155 771180 773547 781694 781709 781748 790501 790877 807805 808012 809899 810062 810069 818161 826645 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sleep young"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"спящ young"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"спящ young"
]
|
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.