Query Metrics
7
Database Queries
7
Different statements
378.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.24 ms (55.86%) |
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 13066 29242 94529 388812 396540 396677 401946 412362 413292 419882 421539 426044 438877 445759 445781 451515 451552 454645 455855 456288 456366 457257 461211 461903 466968 469024 470339 472481 473284 473851 474072 474563 475272 479283 479710 483962 484084 485675 491268 491521 496307 497553 501637 506531 510040 510758 513087 514631 518232 522266 523979 524947 527556 533798 534702 538856 541919 543943 546828 548849 550650 551570 553957 563399 563530 568306 569764 570595 572126 572142 572545 572598 573972 575915 580756 581035 584691 596120 596438 598099 599904 605654 610607 615605 621412 624189 634771 650800 668479 670763 672145 672355 683738 685034 691851 691897 693051 697971 705173 717856 718520 738909 780517 793219 797541 805383 805838 806119 811930 817266 817458 819260 819490 822027 823269 823295 823791 824443 ] |
||||||||||||||||||||||||||||||
|
145.38 ms (38.45%) |
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 13066 29242 94529 388812 396540 396677 401946 412362 413292 419882 421539 426044 438877 445759 445781 451515 451552 454645 455855 456288 456366 457257 461211 461903 466968 469024 470339 472481 473284 473851 474072 474563 475272 479283 479710 483962 484084 485675 491268 491521 496307 497553 501637 506531 510040 510758 513087 514631 518232 522266 523979 524947 527556 533798 534702 538856 541919 543943 546828 548849 550650 551570 553957 563399 563530 568306 569764 570595 572126 572142 572545 572598 573972 575915 580756 581035 584691 596120 596438 598099 599904 605654 610607 615605 621412 624189 634771 650800 668479 670763 672145 672355 683738 685034 691851 691897 693051 697971 705173 717856 718520 738909 780517 793219 797541 805383 805838 806119 811930 817266 817458 819260 819490 822027 823269 823295 823791 824443 ] |
||||||||||||||||||||||||||||||
|
15.51 ms (4.10%) |
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 581035 670763 650800 580756 596120 599904 805383 811930 634771 780517 805838 438877 426044 469024 524947 491268 518232 534702 484084 510758 94529 570595 685034 569764 572598 793219 479283 563399 598099 454645 513087 553957 573972 572126 572142 615605 456288 506531 514631 473284 455855 473851 522266 466968 472481 475272 533798 461903 568306 563530 621412 610607 797541 445759 412362 421539 461211 474563 451552 470339 456366 445781 497553 548849 541919 575915 419882 485675 546828 501637 396677 401946 413292 457257 483962 527556 479710 551570 550650 718520 672355 717856 588719 624189 596438 806119 738909 605654 705173 451515 474072 396540 491521 29242 13066 388812 817458 823295 823791 824443 819260 822027 819490 823269 817266 510040 523979 538856 496307 543943 572545 573937 584691 668479 691851 691897 693051 672145 683738 697971 ] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"lick public"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.35%) |
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.