Query Metrics
7
Database Queries
7
Different statements
144.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.74 ms (83.55%) |
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 7615 54378 74588 88246 103649 197941 233364 308886 381432 382043 382472 382807 386558 386761 387221 388274 389596 390355 391683 392452 395263 395456 396099 396864 397648 398568 400424 401103 401139 401562 401590 402859 403151 405125 405551 408998 409076 409134 415896 417616 417770 421006 421030 431139 446351 447816 460824 464872 466339 468225 469733 470852 471338 474657 489478 492027 492147 494305 499979 504444 524480 526361 526510 535609 547205 566031 570436 571264 576111 589508 593111 596184 596438 599979 603972 605930 618887 630567 635932 640816 645829 662794 669295 670399 690480 693523 693541 698910 699514 701131 702636 704232 706541 708974 719274 734681 742234 744139 746148 750565 752587 753024 753595 754405 758924 758982 765285 770712 778264 780408 782127 783093 786024 786795 794001 800663 801179 803482 805939 813776 ] |
||||||||||||||||||||||||||||||
|
13.21 ms (9.14%) |
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 7615 387221 469733 103649 395263 381432 405551 504444 690480 605930 794001 389596 401562 88246 74588 401103 233364 388274 400424 599979 470852 526361 813776 499979 571264 698910 704232 752587 783093 750565 765285 702636 778264 308886 390355 447816 417770 396864 405125 398568 401139 464872 431139 468225 526510 489478 382043 693523 596184 734681 786795 753595 753024 742234 782127 391683 382472 402859 409076 417616 446351 570436 669295 576111 635932 630567 701131 392452 401590 471338 395456 386761 397648 403151 54378 566031 618887 408998 460824 466339 421006 415896 421030 492027 409134 535609 693541 708974 719274 662794 670399 645829 547205 589508 603972 640816 780408 786024 801179 805939 754405 758924 758982 744139 746148 770712 699514 800663 803482 197941 386558 382807 396099 492147 494305 524480 474657 706541 593111 596438 ] |
||||||||||||||||||||||||||||||
|
3.49 ms (2.42%) |
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 7615 54378 74588 88246 103649 197941 233364 308886 381432 382043 382472 382807 386558 386761 387221 388274 389596 390355 391683 392452 395263 395456 396099 396864 397648 398568 400424 401103 401139 401562 401590 402859 403151 405125 405551 408998 409076 409134 415896 417616 417770 421006 421030 431139 446351 447816 460824 464872 466339 468225 469733 470852 471338 474657 489478 492027 492147 494305 499979 504444 524480 526361 526510 535609 547205 566031 570436 571264 576111 589508 593111 596184 596438 599979 603972 605930 618887 630567 635932 640816 645829 662794 669295 670399 690480 693523 693541 698910 699514 701131 702636 704232 706541 708974 719274 734681 742234 744139 746148 750565 752587 753024 753595 754405 758924 758982 765285 770712 778264 780408 782127 783093 786024 786795 794001 800663 801179 803482 805939 813776 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"беловолосая красивая"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая красивая"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (1.04%) |
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.