Query Metrics
7
Database Queries
7
Different statements
151.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.52 ms (82.23%) |
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 32551 38857 59488 95700 185412 187699 326017 359441 382898 385014 389965 394941 396958 401000 405650 406391 406976 407378 409188 409324 409933 411073 411415 411684 412627 413100 418563 422189 424749 425947 437044 437587 439431 439446 439720 442443 449126 449884 454967 455298 459246 460908 464056 464068 464262 464408 465713 465727 466204 466796 468114 468180 468839 470668 470882 470966 472701 473376 475028 475851 478412 479889 482795 483055 489126 491906 491975 499839 502196 508431 511700 514015 514103 516561 516633 516718 517178 519600 520920 530448 532300 535315 541078 541204 542925 549829 558711 563144 563785 564121 570957 576628 580425 581578 583062 583164 583581 586644 586862 589140 590783 600786 605480 605514 605902 606355 609999 615431 657768 663378 709533 712307 724157 755510 759900 767458 770128 785299 803734 812093 ] |
||||||||||||||||||||||||||||||
|
16.56 ms (10.93%) |
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 32551 439720 663378 437587 389965 439431 605480 59488 468114 464056 466796 442443 475851 412627 483055 382898 558711 394941 439446 455298 449126 502196 516561 563785 519600 424749 409933 583581 413100 185412 724157 755510 770128 516633 449884 385014 470668 491975 418563 411073 489126 767458 38857 464068 396958 508431 479889 465713 542925 514015 541078 564121 615431 581578 785299 359441 499839 759900 472701 459246 709533 532300 514103 563144 464408 405650 409188 454967 473376 517178 511700 491906 605902 576628 516718 470966 466204 583062 549829 407378 411684 401000 422189 586644 437044 583164 606355 409324 465727 470882 530448 570957 580425 590783 586862 475028 609999 464262 482795 520920 406976 468180 411415 803734 468839 326017 478412 600786 541204 605514 812093 589140 535315 712307 425947 95700 406391 460908 657768 187699 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"скачать женщин в трус%…"
]
|
||||||||||||||||||||||||||||||
|
2.47 ms (1.63%) |
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 32551 38857 59488 95700 185412 187699 326017 359441 382898 385014 389965 394941 396958 401000 405650 406391 406976 407378 409188 409324 409933 411073 411415 411684 412627 413100 418563 422189 424749 425947 437044 437587 439431 439446 439720 442443 449126 449884 454967 455298 459246 460908 464056 464068 464262 464408 465713 465727 466204 466796 468114 468180 468839 470668 470882 470966 472701 473376 475028 475851 478412 479889 482795 483055 489126 491906 491975 499839 502196 508431 511700 514015 514103 516561 516633 516718 517178 519600 520920 530448 532300 535315 541078 541204 542925 549829 558711 563144 563785 564121 570957 576628 580425 581578 583062 583164 583581 586644 586862 589140 590783 600786 605480 605514 605902 606355 609999 615431 657768 663378 709533 712307 724157 755510 759900 767458 770128 785299 803734 812093 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скача женщин в трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.11%) |
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.