Query Metrics
7
Database Queries
7
Different statements
359.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.94 ms (58.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
122.00 ms (33.98%) |
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 389458 395556 398394 400185 401953 401978 415567 421821 421822 421824 421847 421865 422166 422200 422282 424093 424118 426015 427177 428890 428892 428898 429564 430313 433341 433380 439457 439616 439698 439699 439704 439744 439774 443801 443942 444468 446297 446313 448024 448707 448955 452772 453260 454423 455337 457465 458009 460177 461374 464329 464446 465838 467662 467663 468091 469391 469442 471627 472176 472679 472701 474781 474786 475224 477104 478678 479059 479177 482554 482563 486894 486896 489380 490702 492366 493173 493193 498491 502812 504104 516481 518160 519735 520811 520861 521758 523070 524486 525233 526454 527158 528708 531934 532044 532114 532127 535446 538970 546111 549824 550221 554897 554903 561594 562517 562985 563151 565659 584765 587915 589682 614424 710588 735908 760425 763225 788318 795048 821760 823803 ] |
||||||||||||||||||||||||||||||
|
16.61 ms (4.63%) |
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 429564 430313 565659 493173 520861 535446 526454 395556 446297 453260 464446 527158 562517 554897 710588 735908 472176 457465 455337 516481 398394 467662 561594 589682 525233 795048 614424 518160 468091 452772 538970 524486 428892 433341 549824 422200 439616 469442 465838 519735 421865 461374 486896 460177 532127 448707 479177 443942 546111 587915 477104 490702 520811 415567 444468 502812 401953 439774 389458 421821 401978 482563 471627 400185 433380 472701 422166 489380 498491 439699 439744 439457 486894 531934 532114 421822 421824 439698 448955 421847 428898 443801 474786 504104 454423 562985 563151 475224 469391 472679 493193 528708 821760 523070 788318 763225 422282 426015 448024 532044 467663 492366 584765 554903 424118 823803 464329 446313 478678 550221 428890 424093 439704 474781 427177 521758 458009 482554 760425 479059 ] |
||||||||||||||||||||||||||||||
|
3.52 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин son секс"
]
|
||||||||||||||||||||||||||||||
|
3.00 ms (0.84%) |
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 389458 395556 398394 400185 401953 401978 415567 421821 421822 421824 421847 421865 422166 422200 422282 424093 424118 426015 427177 428890 428892 428898 429564 430313 433341 433380 439457 439616 439698 439699 439704 439744 439774 443801 443942 444468 446297 446313 448024 448707 448955 452772 453260 454423 455337 457465 458009 460177 461374 464329 464446 465838 467662 467663 468091 469391 469442 471627 472176 472679 472701 474781 474786 475224 477104 478678 479059 479177 482554 482563 486894 486896 489380 490702 492366 493173 493193 498491 502812 504104 516481 518160 519735 520811 520861 521758 523070 524486 525233 526454 527158 528708 531934 532044 532114 532127 535446 538970 546111 549824 550221 554897 554903 561594 562517 562985 563151 565659 584765 587915 589682 614424 710588 735908 760425 763225 788318 795048 821760 823803 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (0.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother son fuck"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.48%) |
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.