Query Metrics
7
Database Queries
7
Different statements
225.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
198.67 ms (88.21%) |
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 115206 384522 385483 386623 386846 387235 387281 388591 394853 398177 400139 400550 401673 406946 410753 418923 420275 423376 425957 427202 433718 442299 448755 489973 491768 494085 506550 506552 506580 511392 522888 526429 533547 560210 561047 561113 566558 572202 581394 587226 593839 603571 607168 607202 607376 607403 608038 612812 631927 633815 642832 644270 644301 644306 650780 671279 671759 672122 680657 681271 687271 687544 688325 699596 703051 705663 709624 710412 714864 717034 717862 717880 720925 721187 724111 724133 724182 724328 729819 732029 736141 737549 748432 753248 756083 756869 758617 760825 760837 763624 770196 771821 772804 775473 788936 789647 790026 800162 801944 801974 805585 806777 807949 808112 809421 811072 814255 814353 815056 815080 815982 817457 817768 817917 818457 818471 820743 823622 824996 827903 ] |
||||||||||||||||||||||||||||||
|
17.22 ms (7.64%) |
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 511392 581394 672122 631927 587226 593839 775473 790026 736141 756869 418923 814255 824996 688325 788936 729819 388591 533547 607403 398177 814353 815080 687544 699596 710412 772804 805585 732029 760825 387281 572202 384522 607376 756083 386846 801974 410753 817457 818471 406946 423376 433718 506550 494085 561113 703051 717862 400139 427202 820743 817768 818457 506552 560210 671279 671759 681271 709624 608038 801944 807949 763624 811072 448755 526429 680657 721187 809421 724328 724111 771821 644306 705663 789647 386623 385483 815056 817917 491768 489973 714864 687271 607168 607202 642832 644301 806777 770196 760837 724133 737549 753248 717034 720925 400550 522888 420275 815982 823622 566558 650780 612812 800162 758617 401673 394853 442299 425957 717880 748432 506580 827903 644270 561047 724182 387235 633815 808112 603571 115206 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.21%) |
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 115206 384522 385483 386623 386846 387235 387281 388591 394853 398177 400139 400550 401673 406946 410753 418923 420275 423376 425957 427202 433718 442299 448755 489973 491768 494085 506550 506552 506580 511392 522888 526429 533547 560210 561047 561113 566558 572202 581394 587226 593839 603571 607168 607202 607376 607403 608038 612812 631927 633815 642832 644270 644301 644306 650780 671279 671759 672122 680657 681271 687271 687544 688325 699596 703051 705663 709624 710412 714864 717034 717862 717880 720925 721187 724111 724133 724182 724328 729819 732029 736141 737549 748432 753248 756083 756869 758617 760825 760837 763624 770196 771821 772804 775473 788936 789647 790026 800162 801944 801974 805585 806777 807949 808112 809421 811072 814255 814353 815056 815080 815982 817457 817768 817917 818457 818471 820743 823622 824996 827903 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"threesome with milf"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс втро milf"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс втро milf"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.66%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.