Query Metrics
7
Database Queries
7
Different statements
155.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.23 ms (81.89%) |
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 122425 385755 395715 396283 397128 398053 405367 405846 407156 410841 411182 419900 419912 420893 422500 422595 422712 422844 422953 422960 423022 423199 423412 423418 425300 427447 433229 433279 434759 443225 443322 443550 443600 443602 446258 446648 447797 456005 456622 456642 456730 458327 458911 459232 459832 463748 469542 473763 475443 483708 485576 486620 486759 492622 499034 499035 500570 504065 508485 510622 511425 511489 512181 512207 512680 515891 518011 519769 521177 523326 523540 523712 525644 527011 527101 527117 529182 529854 530663 531156 532015 532252 533313 534776 534985 535072 535200 535434 537201 539299 539519 539886 539903 539938 539945 540251 540608 542294 542585 542587 542692 555950 565481 593405 598247 641492 652125 709919 711668 713642 720943 733891 737326 738245 769710 772037 792554 799721 816360 818335 ] |
||||||||||||||||||||||||||||||
|
17.66 ms (11.36%) |
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 499035 510622 512181 527117 531156 532015 533313 535434 523540 523712 525644 537201 499034 527101 532252 534776 529182 539945 469542 542294 555950 542692 542587 598247 792554 733891 799721 423022 446258 395715 423412 456642 475443 443322 385755 422844 433279 419900 423418 425300 422960 427447 458327 515891 122425 396283 398053 405367 405846 434759 443225 443602 422953 420893 816360 818335 492622 456005 459832 473763 486620 459232 521177 500570 539299 512207 709919 593405 641492 738245 720943 397128 423199 458911 456622 446648 447797 410841 483708 504065 523326 711668 737326 772037 769710 433229 527011 422595 422712 422500 529854 530663 512680 539938 540608 534985 511489 518011 463748 486759 652125 565481 456730 407156 411182 443550 443600 419912 519769 485576 508485 535072 535200 539519 539886 539903 540251 511425 542585 713642 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.88%) |
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 122425 385755 395715 396283 397128 398053 405367 405846 407156 410841 411182 419900 419912 420893 422500 422595 422712 422844 422953 422960 423022 423199 423412 423418 425300 427447 433229 433279 434759 443225 443322 443550 443600 443602 446258 446648 447797 456005 456622 456642 456730 458327 458911 459232 459832 463748 469542 473763 475443 483708 485576 486620 486759 492622 499034 499035 500570 504065 508485 510622 511425 511489 512181 512207 512680 515891 518011 519769 521177 523326 523540 523712 525644 527011 527101 527117 529182 529854 530663 531156 532015 532252 533313 534776 534985 535072 535200 535434 537201 539299 539519 539886 539903 539938 539945 540251 540608 542294 542585 542587 542692 555950 565481 593405 598247 641492 652125 709919 711668 713642 720943 733891 737326 738245 769710 772037 792554 799721 816360 818335 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian and white"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк white"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"азиатк white"
]
|
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.