Query Metrics
7
Database Queries
7
Different statements
150.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.84 ms (82.94%) |
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 20948 21500 61536 153364 167756 384492 385448 385476 387018 389475 396922 408047 409878 419850 423129 443046 444773 447853 454953 456862 465076 469366 469549 475448 475938 492413 492646 496441 510595 512182 512197 512199 515606 515702 515734 522123 525192 531222 541598 545628 549308 550616 550643 550996 551963 551966 551971 552040 552896 552913 554432 557505 557509 559889 559923 562847 562900 565979 565980 565985 565998 566000 566011 566015 566016 568552 586542 590934 601081 605848 613163 614529 615767 619412 619458 619487 622266 630492 630521 639310 641663 643383 650933 672251 672258 697354 712154 712884 714848 722187 726647 741631 750816 760674 770665 771792 775584 776189 785024 789760 789999 795539 802671 804465 807641 807915 808775 810813 812975 813226 813507 815219 815454 815674 815893 816360 817920 818371 819082 822721 ] |
||||||||||||||||||||||||||||||
|
15.41 ms (10.24%) |
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 562847 819082 566015 554432 541598 815893 818371 454953 712884 714848 722187 586542 630492 614529 630521 775584 776189 812975 760674 807915 810813 515734 396922 566011 423129 443046 515606 641663 807641 456862 465076 605848 619487 639310 795539 813507 808775 770665 167756 475448 531222 590934 475938 153364 492413 552896 551963 552040 613163 615767 444773 419850 566000 822721 512182 559889 565985 643383 789999 726647 384492 447853 469366 815454 741631 512197 512199 551971 550643 550616 619458 469549 510595 492646 712154 552913 622266 601081 562900 565998 389475 815674 697354 813226 817920 815219 566016 545628 650933 672258 789760 771792 802671 804465 387018 409878 816360 557509 565980 557505 61536 549308 21500 385448 496441 619412 785024 408047 385476 20948 515702 525192 550996 568552 750816 565979 551966 672251 522123 559923 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.98%) |
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 20948 21500 61536 153364 167756 384492 385448 385476 387018 389475 396922 408047 409878 419850 423129 443046 444773 447853 454953 456862 465076 469366 469549 475448 475938 492413 492646 496441 510595 512182 512197 512199 515606 515702 515734 522123 525192 531222 541598 545628 549308 550616 550643 550996 551963 551966 551971 552040 552896 552913 554432 557505 557509 559889 559923 562847 562900 565979 565980 565985 565998 566000 566011 566015 566016 568552 586542 590934 601081 605848 613163 614529 615767 619412 619458 619487 622266 630492 630521 639310 641663 643383 650933 672251 672258 697354 712154 712884 714848 722187 726647 741631 750816 760674 770665 771792 775584 776189 785024 789760 789999 795539 802671 804465 807641 807915 808775 810813 812975 813226 813507 815219 815454 815674 815893 816360 817920 818371 819082 822721 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.33%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian mother"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.98%) |
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.