Query Metrics
7
Database Queries
7
Different statements
143.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.12 ms (83.24%) |
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 61322 151014 233365 247381 370794 382268 383367 386544 386686 389044 389351 389567 389612 390403 390427 390918 391913 392031 394206 395422 395601 395933 396952 396956 397911 398955 399633 400999 407365 411360 411372 411757 411897 424422 424468 424478 424483 424485 428463 428843 443119 443673 443677 443705 443706 443834 455872 464436 464545 490902 491412 491994 495886 500422 523031 527753 552325 552582 562976 565530 586582 589687 608049 609962 630215 682532 688554 717645 721421 721500 724476 724702 726692 726831 728291 729655 735829 736834 737070 737152 740101 741906 743834 745382 752876 758608 770111 770478 772117 774176 779224 781446 781704 782287 786277 788601 788812 788885 789740 789954 790023 792507 792636 792639 801350 801375 801864 802453 803017 803088 807376 807596 807636 808496 811002 815263 815841 816326 821922 825143 ] |
||||||||||||||||||||||||||||||
|
14.56 ms (10.18%) |
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 770478 788601 807636 808496 724476 741906 729655 743834 745382 758608 774176 737152 752876 608049 779224 786277 788812 788885 792636 390403 390427 395933 397911 400999 411897 424468 428463 443119 443706 247381 386544 389351 389567 389612 398955 411757 424422 370794 392031 395601 411360 411372 424485 443834 464436 464545 233365 386686 391913 394206 443677 443705 424478 424483 443673 490902 495886 500422 523031 491412 491994 527753 770111 740101 383367 151014 395422 382268 61322 389044 390918 396952 396956 399633 428843 407365 815263 816326 825143 815841 821922 455872 552325 562976 565530 552582 688554 721500 717645 721421 682532 630215 589687 586582 609962 781446 781704 790023 801350 801375 801864 807596 789954 792507 802453 807376 772117 782287 789740 792639 803017 803088 811002 724702 726831 728291 735829 736834 726692 737070 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.76%) |
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 61322 151014 233365 247381 370794 382268 383367 386544 386686 389044 389351 389567 389612 390403 390427 390918 391913 392031 394206 395422 395601 395933 396952 396956 397911 398955 399633 400999 407365 411360 411372 411757 411897 424422 424468 424478 424483 424485 428463 428843 443119 443673 443677 443705 443706 443834 455872 464436 464545 490902 491412 491994 495886 500422 523031 527753 552325 552582 562976 565530 586582 589687 608049 609962 630215 682532 688554 717645 721421 721500 724476 724702 726692 726831 728291 729655 735829 736834 737070 737152 740101 741906 743834 745382 752876 758608 770111 770478 772117 774176 779224 781446 781704 782287 786277 788601 788812 788885 789740 789954 790023 792507 792636 792639 801350 801375 801864 802453 803017 803088 807376 807596 807636 808496 811002 815263 815841 816326 821922 825143 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"лижет у старой"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза старая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (1.03%) |
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.