Query Metrics
7
Database Queries
7
Different statements
148.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.93 ms (84.25%) |
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 10006 10229 53396 390994 391561 420241 427555 438597 447517 448366 453130 453484 453825 454085 454633 454835 458299 461469 462794 464212 465808 468695 471787 472339 473324 476054 476075 477253 483461 484278 485165 490794 497421 505905 510680 515471 528282 533660 533696 533760 534685 535038 536601 537881 545153 551265 570705 589749 596198 597951 600485 601643 607136 609804 609883 624282 630160 633813 634510 636983 637043 637063 638985 640537 642362 649585 671350 672686 673364 673969 673996 677951 678125 680161 680172 681505 691225 691226 692090 694324 707330 712717 713076 717708 717756 719002 720029 720332 720365 722522 722609 726608 727632 728283 728432 730728 731846 731862 735968 739789 740585 740604 741187 742362 742424 743383 746421 747375 747450 747523 748661 748973 753545 756331 758991 758997 761174 785324 799266 811946 ] |
||||||||||||||||||||||||||||||
|
13.87 ms (9.35%) |
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 448366 453484 461469 490794 678125 533760 535038 637063 637043 634510 638985 533660 533696 680161 680172 672686 720332 720365 722522 717708 536601 692090 649585 673996 677951 712717 717756 707330 609804 607136 642362 727632 747450 731846 748973 758991 728432 746421 728283 731862 740604 747375 747523 742424 636983 640537 720029 799266 391561 528282 497421 53396 10006 464212 551265 453130 420241 471787 485165 515471 454085 570705 633813 454633 545153 468695 462794 691225 740585 483461 458299 476075 597951 601643 743383 730728 741187 476054 447517 484278 427555 390994 534685 673364 473324 756331 742362 10229 671350 719002 722609 694324 713076 596198 630160 735968 811946 739789 753545 758997 726608 748661 761174 453825 537881 681505 609883 600485 589749 624282 465808 454835 472339 438597 505905 510680 477253 673969 691226 785324 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.81%) |
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 10006 10229 53396 390994 391561 420241 427555 438597 447517 448366 453130 453484 453825 454085 454633 454835 458299 461469 462794 464212 465808 468695 471787 472339 473324 476054 476075 477253 483461 484278 485165 490794 497421 505905 510680 515471 528282 533660 533696 533760 534685 535038 536601 537881 545153 551265 570705 589749 596198 597951 600485 601643 607136 609804 609883 624282 630160 633813 634510 636983 637043 637063 638985 640537 642362 649585 671350 672686 673364 673969 673996 677951 678125 680161 680172 681505 691225 691226 692090 694324 707330 712717 713076 717708 717756 719002 720029 720332 720365 722522 722609 726608 727632 728283 728432 730728 731846 731862 735968 739789 740585 740604 741187 742362 742424 743383 746421 747375 747450 747523 748661 748973 753545 756331 758991 758997 761174 785324 799266 811946 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal casting teen"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал кастинг teen"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал кастинг teen"
]
|
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.