Query Metrics
7
Database Queries
7
Different statements
219.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.00 ms (84.22%) |
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 469 13428 105845 212012 285684 369890 382194 383726 384258 385475 386939 387765 392043 392665 395344 395439 398477 400540 411197 411462 418148 420719 425113 426020 426798 439350 441353 441796 443210 444078 445642 445818 453479 453690 453761 456153 456224 456972 458068 458934 460711 465196 466904 467082 467907 473476 476093 480994 482711 490413 492013 493277 493285 495646 497184 499953 500004 507104 507249 507281 515619 516493 516633 518379 518506 519600 521137 523457 535263 535437 537963 539735 539940 549165 550240 553715 558894 567307 575840 579612 581376 581577 585438 588710 596580 597690 605234 615515 617250 618118 620828 644192 646702 675123 675139 675441 675692 675725 683420 685073 688523 697457 697765 705326 728075 735902 742754 761598 765920 766114 768615 769460 778532 780771 784510 794112 797134 806596 813472 814499 ] |
||||||||||||||||||||||||||||||
|
15.52 ms (7.07%) |
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 523457 516633 617250 766114 453479 495646 769460 675692 558894 535263 644192 392665 476093 480994 575840 768615 395344 507104 439350 675139 392043 465196 742754 398477 597690 444078 518379 445818 411462 105845 456224 539735 697457 443210 453761 515619 426798 780771 685073 735902 605234 441796 458934 467082 383726 369890 384258 697765 705326 794112 778532 813472 765920 728075 385475 646702 458068 675123 467907 675441 473476 585438 615515 453690 500004 507281 521137 518506 441353 411197 482711 507249 539940 460711 567307 456972 456153 519600 493285 499953 581376 382194 806596 784510 445642 549165 212012 285684 581577 420719 596580 516493 618118 425113 620828 426020 493277 400540 814499 797134 469 386939 387765 13428 537963 490413 395439 683420 688523 675725 466904 550240 588710 761598 492013 553715 497184 535437 418148 579612 ] |
||||||||||||||||||||||||||||||
|
11.16 ms (5.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.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 469 13428 105845 212012 285684 369890 382194 383726 384258 385475 386939 387765 392043 392665 395344 395439 398477 400540 411197 411462 418148 420719 425113 426020 426798 439350 441353 441796 443210 444078 445642 445818 453479 453690 453761 456153 456224 456972 458068 458934 460711 465196 466904 467082 467907 473476 476093 480994 482711 490413 492013 493277 493285 495646 497184 499953 500004 507104 507249 507281 515619 516493 516633 518379 518506 519600 521137 523457 535263 535437 537963 539735 539940 549165 550240 553715 558894 567307 575840 579612 581376 581577 585438 588710 596580 597690 605234 615515 617250 618118 620828 644192 646702 675123 675139 675441 675692 675725 683420 685073 688523 697457 697765 705326 728075 735902 742754 761598 765920 766114 768615 769460 778532 780771 784510 794112 797134 806596 813472 814499 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"раком в трус"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.67%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рак в трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.14 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.