Query Metrics
7
Database Queries
7
Different statements
474.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
227.17 ms (47.91%) |
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 154133 385021 387480 390713 392015 392019 398221 398684 398741 402626 402632 410676 413641 414090 416000 416593 416609 416632 419648 424195 426475 428045 428956 429703 429888 432283 441495 443198 443239 443243 444544 445351 445974 448257 448802 449073 451336 455901 460813 461937 466564 468680 468835 469131 471681 478257 480206 480493 484809 487414 493334 493691 495758 497950 498641 499869 500333 508885 512447 512749 517797 518191 519365 519369 520419 522340 526232 529116 530110 530429 530700 531647 534586 535429 536783 538977 540680 541278 541851 541867 546005 547423 548157 555992 556044 556426 565174 572640 575178 583665 592187 592362 593275 595454 598760 600540 602249 618780 628397 629333 634067 636948 643681 670357 673254 696111 740118 755930 770022 782351 788193 790133 796370 802248 805784 810294 813646 816596 824883 ] |
||||||||||||||||||||||||||||||
|
209.00 ms (44.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anus gape"
]
|
||||||||||||||||||||||||||||||
|
27.95 ms (5.89%) |
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 634067 805784 410676 398221 628397 519369 546005 565174 495758 493334 519365 443239 443243 413641 449073 484809 471695 508885 520419 530110 530700 535429 518191 522340 529116 469131 541278 555992 575178 419648 428045 455901 154133 392019 387480 416593 432283 414090 416632 443198 487414 493691 540680 499869 530429 534586 500333 538977 531647 461937 471681 480206 541867 548157 583665 592362 600540 643681 424195 392015 402632 445351 451336 460813 498641 670357 696111 782351 802248 755930 398741 497950 813646 416000 444544 448257 517797 536783 512447 740118 480493 816596 426475 636948 602249 441495 429703 398684 445974 448802 512749 526232 556044 556426 541851 572640 629333 593275 618780 466564 429888 468680 478257 385021 673254 788193 796370 592187 428956 824883 790133 770022 810294 547423 598760 468835 595454 390713 402626 416609 ] |
||||||||||||||||||||||||||||||
|
4.16 ms (0.88%) |
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 154133 385021 387480 390713 392015 392019 398221 398684 398741 402626 402632 410676 413641 414090 416000 416593 416609 416632 419648 424195 426475 428045 428956 429703 429888 432283 441495 443198 443239 443243 444544 445351 445974 448257 448802 449073 451336 455901 460813 461937 466564 468680 468835 469131 471681 478257 480206 480493 484809 487414 493334 493691 495758 497950 498641 499869 500333 508885 512447 512749 517797 518191 519365 519369 520419 522340 526232 529116 530110 530429 530700 531647 534586 535429 536783 538977 540680 541278 541851 541867 546005 547423 548157 555992 556044 556426 565174 572640 575178 583665 592187 592362 593275 595454 598760 600540 602249 618780 628397 629333 634067 636948 643681 670357 673254 696111 740118 755930 770022 782351 788193 790133 796370 802248 805784 810294 813646 816596 824883 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анус большая большие дырк"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анус большая большие дырк"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.39%) |
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.