Query Metrics
7
Database Queries
7
Different statements
194.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.06 ms (85.34%) |
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 6813 20431 25646 25650 79781 110772 116623 152762 186592 207824 210355 233330 325228 332778 382193 382743 382947 383267 383493 383671 384430 385267 385751 385933 388555 389829 392107 394521 397173 397771 400034 400820 401007 406307 414349 444917 452651 454440 472119 472665 473391 474087 476230 486024 489922 491765 492972 501724 507056 507096 509261 512125 519143 520664 520667 520698 526051 527424 528710 551111 556604 561890 564398 567758 569298 570759 571828 582433 582444 589730 591626 593047 601096 602210 604396 608153 609083 627147 629600 629956 631610 634839 635501 644849 667250 667869 697496 701212 715275 733037 744218 763546 772119 774440 793950 794188 794226 795976 796799 797241 800925 800932 803738 807784 818692 819327 819348 823777 823978 824088 825062 825398 826017 826217 826283 826388 826481 826497 826602 826603 ] |
||||||||||||||||||||||||||||||
|
17.82 ms (9.16%) |
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 629956 635501 793950 794226 796799 800925 800932 803738 807784 233330 414349 210355 382947 6813 385933 400034 385267 406307 644849 589730 491765 454440 509261 512125 520698 526051 528710 507096 520664 520667 474087 476230 567758 582444 561890 569298 570759 571828 582433 551111 564398 667250 667869 608153 604396 627147 593047 609083 797241 389829 452651 383671 401007 400820 472119 444917 472665 507056 486024 519143 492972 527424 385751 207824 394521 25646 823777 489922 397771 501724 556604 715275 602210 629600 591626 601096 631610 795976 772119 733037 794188 110772 186592 697496 701212 634839 744218 763546 473391 383267 383493 382743 384430 116623 152762 392107 325228 332778 382193 20431 25650 79781 388555 397173 819327 819348 823978 824088 825062 826017 826217 826283 774440 826481 826497 826388 826602 826603 825398 818692 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.52%) |
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 6813 20431 25646 25650 79781 110772 116623 152762 186592 207824 210355 233330 325228 332778 382193 382743 382947 383267 383493 383671 384430 385267 385751 385933 388555 389829 392107 394521 397173 397771 400034 400820 401007 406307 414349 444917 452651 454440 472119 472665 473391 474087 476230 486024 489922 491765 492972 501724 507056 507096 509261 512125 519143 520664 520667 520698 526051 527424 528710 551111 556604 561890 564398 567758 569298 570759 571828 582433 582444 589730 591626 593047 601096 602210 604396 608153 609083 627147 629600 629956 631610 634839 635501 644849 667250 667869 697496 701212 715275 733037 744218 763546 772119 774440 793950 794188 794226 795976 796799 797241 800925 800932 803738 807784 818692 819327 819348 823777 823978 824088 825062 825398 826017 826217 826283 826388 826481 826497 826602 826603 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"chubby natural"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"chubby натуральная натуральные"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"chubby натуральная натуральные"
]
|
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.