Query Metrics
7
Database Queries
7
Different statements
142.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.41 ms (82.32%) |
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 392754 397880 397916 400511 400808 401953 421813 421822 421825 421845 421847 421850 421869 421892 421931 422155 422157 422168 422179 422235 424093 426701 426865 426987 426994 428890 428898 433347 433364 433380 437583 439565 439569 439571 439648 439652 439666 439677 439687 439695 439698 439768 439774 440614 443801 443946 444044 444298 444703 445459 452629 454257 454411 460601 460728 462489 464189 466762 470774 472679 472701 473248 474783 475174 475266 475898 476256 479040 488118 489380 489382 490180 490412 490702 491988 493167 494315 494329 495224 495225 498491 502814 505973 506863 509479 516787 518160 519436 520204 520811 520916 521134 523829 523830 523839 523845 524339 524486 526010 526454 526524 527181 528343 528355 529157 535446 538001 538002 538008 538009 538970 546111 563151 601297 613319 624003 716915 735908 777217 811919 ] |
||||||||||||||||||||||||||||||
|
15.43 ms (10.82%) |
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 495224 490180 433364 422168 473248 426865 437583 490412 491988 509479 538009 421850 439677 439695 462489 460601 439569 735908 422179 452629 518160 460728 421869 421931 433347 439648 397880 421825 421845 538970 520204 523845 538002 495225 524486 526010 474783 426987 444298 445459 439666 523829 535446 546111 464189 490702 488118 505973 520811 392754 397916 426701 475174 466762 529157 527181 716915 601297 777217 811919 422235 520916 475266 439768 440614 444703 528355 493167 494315 526524 521134 526454 421813 421892 439687 538008 624003 613319 422155 400808 479040 506863 502814 523830 489382 494329 528343 519436 401953 428890 439774 421822 439698 421847 424093 444044 428898 443801 439565 400511 516787 470774 439652 443946 476256 454257 524339 426994 563151 433380 472701 475898 454411 472679 489380 498491 523839 538001 422157 439571 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (2.05%) |
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 392754 397880 397916 400511 400808 401953 421813 421822 421825 421845 421847 421850 421869 421892 421931 422155 422157 422168 422179 422235 424093 426701 426865 426987 426994 428890 428898 433347 433364 433380 437583 439565 439569 439571 439648 439652 439666 439677 439687 439695 439698 439768 439774 440614 443801 443946 444044 444298 444703 445459 452629 454257 454411 460601 460728 462489 464189 466762 470774 472679 472701 473248 474783 475174 475266 475898 476256 479040 488118 489380 489382 490180 490412 490702 491988 493167 494315 494329 495224 495225 498491 502814 505973 506863 509479 516787 518160 519436 520204 520811 520916 521134 523829 523830 523839 523845 524339 524486 526010 526454 526524 527181 528343 528355 529157 535446 538001 538002 538008 538009 538970 546111 563151 601297 613319 624003 716915 735908 777217 811919 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother son russian"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин son русск"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин son русск"
]
|
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.