Query Metrics
7
Database Queries
7
Different statements
163.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.58 ms (83.97%) |
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 14323 96100 328534 395489 396565 397293 399414 400932 401119 402546 404459 407290 411637 417441 419595 419808 420760 422328 422785 426390 427254 429770 430088 436030 447314 447735 451565 455156 457078 460328 462742 465468 468008 468439 468490 472429 472448 478110 478973 481047 491364 493795 505135 508426 511775 512329 512826 516590 518490 522132 523201 526073 530022 530497 530636 530850 531657 532950 533743 536001 536227 536394 536613 536785 543850 549106 550198 559986 560184 563988 565277 568190 583593 586941 605003 607091 615832 630284 630533 634135 634211 637694 640521 641660 643046 645322 646846 648862 649137 651068 651666 661942 662197 663167 663168 666875 673797 674702 676073 676095 680202 704233 704715 709198 710425 712886 718931 720033 720340 722548 724139 732681 741196 744647 761208 767165 776941 814822 815430 ] |
||||||||||||||||||||||||||||||
|
16.88 ms (10.30%) |
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 666875 651666 395489 96100 422328 426390 427254 419808 430088 815430 814822 468439 472429 468490 536001 530850 531657 536613 465468 543850 568190 645322 662197 676073 680202 712886 720340 722548 649137 676095 704715 720033 646846 651068 663167 673797 641660 634135 615832 643046 607091 776941 732681 741196 761208 724139 767165 744647 637694 640521 704233 709198 710425 7615 396565 397293 407290 447735 14323 436030 411637 512826 630533 550198 481047 718931 565277 518490 400932 402546 419595 417441 455156 460328 468008 478110 472448 493795 516590 522132 530497 536394 530636 532950 533743 536227 536785 505135 462742 549106 559986 674702 648862 661942 663168 560184 563988 583593 605003 630284 586941 634211 401119 457078 399414 422785 447314 451565 512329 491364 511775 526073 508426 523201 420760 478973 328534 404459 429770 530022 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.90%) |
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 14323 96100 328534 395489 396565 397293 399414 400932 401119 402546 404459 407290 411637 417441 419595 419808 420760 422328 422785 426390 427254 429770 430088 436030 447314 447735 451565 455156 457078 460328 462742 465468 468008 468439 468490 472429 472448 478110 478973 481047 491364 493795 505135 508426 511775 512329 512826 516590 518490 522132 523201 526073 530022 530497 530636 530850 531657 532950 533743 536001 536227 536394 536613 536785 543850 549106 550198 559986 560184 563988 565277 568190 583593 586941 605003 607091 615832 630284 630533 634135 634211 637694 640521 641660 643046 645322 646846 648862 649137 651068 651666 661942 662197 663167 663168 666875 673797 674702 676073 676095 680202 704233 704715 709198 710425 712886 718931 720033 720340 722548 724139 732681 741196 744647 761208 767165 776941 814822 815430 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal teen bbc"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал teen bbc"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал teen bbc"
]
|
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.