Query Metrics
7
Database Queries
7
Different statements
186.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.53 ms (84.47%) |
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 13229 157194 193761 387285 388113 388329 389440 392603 396300 400195 400602 401225 407018 407191 409144 411394 413100 413478 420227 425603 426154 428512 430486 439660 443695 443731 444044 446291 450195 454178 460918 462574 465372 474795 476331 477993 481734 482328 484586 486345 487338 490138 490910 502306 502681 514757 515022 518312 520916 521276 526745 527148 532126 532825 534244 535365 561587 585728 590533 611560 612922 641082 650136 651186 663396 669219 680745 682552 683579 687524 689291 710604 716503 719005 721167 721480 722714 736053 737085 741047 745691 746107 746445 746459 756021 757201 759555 781647 781673 781736 788274 788431 788585 789575 789682 789979 789988 791555 795495 797912 801368 801817 801835 801908 807624 811923 813956 815340 815359 815392 815446 815506 815758 815892 816543 816951 818054 818810 823526 824354 ] |
||||||||||||||||||||||||||||||
|
19.09 ms (10.23%) |
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 476331 477993 411394 420227 443695 443731 465372 474795 400195 407018 413478 425603 426154 444044 460918 462574 400602 409144 413100 439660 450195 430486 521276 490910 526745 487338 484586 486345 490138 520916 534244 388113 396300 401225 407191 815340 815392 815446 824354 815758 815892 818054 815506 818810 815359 816543 816951 823526 515022 532126 532825 527148 535365 561587 669219 680745 689291 722714 651186 682552 721167 721480 650136 663396 683579 687524 710604 716503 719005 585728 611560 590533 641082 781736 788431 789682 801908 807624 781647 788274 788585 789575 797912 741047 757201 789988 791555 795495 801368 736053 745691 746445 746107 756021 759555 737085 746459 612922 781673 789979 801817 801835 811923 388329 392603 481734 193761 482328 13229 387285 502681 428512 813956 157194 389440 446291 454178 514757 502306 518312 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.23%) |
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 13229 157194 193761 387285 388113 388329 389440 392603 396300 400195 400602 401225 407018 407191 409144 411394 413100 413478 420227 425603 426154 428512 430486 439660 443695 443731 444044 446291 450195 454178 460918 462574 465372 474795 476331 477993 481734 482328 484586 486345 487338 490138 490910 502306 502681 514757 515022 518312 520916 521276 526745 527148 532126 532825 534244 535365 561587 585728 590533 611560 612922 641082 650136 651186 663396 669219 680745 682552 683579 687524 689291 710604 716503 719005 721167 721480 722714 736053 737085 741047 745691 746107 746445 746459 756021 757201 759555 781647 781673 781736 788274 788431 788585 789575 789682 789979 789988 791555 795495 797912 801368 801817 801835 801908 807624 811923 813956 815340 815359 815392 815446 815506 815758 815892 816543 816951 818054 818810 823526 824354 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young mom парен"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young mom boy"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young mom парен"
]
|
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.