Query Metrics
7
Database Queries
7
Different statements
175.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.14 ms (84.54%) |
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 95982 182118 183074 184359 218768 310295 310758 312264 341546 378046 381883 381903 383188 387293 388492 390378 391592 393067 393091 398773 404192 414313 414360 419517 420190 421228 426394 426511 428113 447086 452263 460168 462751 469373 474872 477878 480073 484721 486768 508679 516320 522596 526082 529897 530703 531117 531249 531877 532746 532789 533594 534129 534536 536212 537220 538925 547477 547856 555130 571194 571213 576981 583730 588507 589761 592384 595761 603273 606405 606514 610540 628110 630552 647602 660427 665973 666579 671714 673357 673613 676088 682250 690809 692188 699385 703062 705278 711997 712891 717839 717880 720207 721715 723497 724109 724309 724996 728215 736226 742356 742804 744389 748475 756383 760240 761781 770823 772714 788294 790389 790842 807196 815210 815866 817156 817537 817866 818290 820678 820765 ] |
||||||||||||||||||||||||||||||
|
16.75 ms (9.56%) |
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 724109 772714 807196 728215 398773 460168 526082 756383 721715 404192 676088 712891 182118 420190 484721 95982 817537 820765 815866 583730 547856 647602 705278 711997 666579 673613 717839 671714 692188 744389 760240 742804 703062 388492 387293 390378 421228 414360 474872 341546 183074 393067 531877 533594 529897 508679 486768 576981 660427 665973 720207 723497 682250 588507 610540 606405 761781 770823 790842 571213 595761 462751 184359 452263 447086 532789 530703 531117 419517 414313 393091 469373 532746 699385 603273 312264 571194 630552 428113 480073 673357 477878 522596 555130 391592 378046 426511 589761 531249 592384 628110 724996 736226 516320 310758 820678 537220 547477 788294 790389 724309 742356 748475 606514 381903 383188 218768 310295 381883 426394 817156 818290 815210 817866 534129 534536 538925 536212 690809 717880 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.53%) |
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 95982 182118 183074 184359 218768 310295 310758 312264 341546 378046 381883 381903 383188 387293 388492 390378 391592 393067 393091 398773 404192 414313 414360 419517 420190 421228 426394 426511 428113 447086 452263 460168 462751 469373 474872 477878 480073 484721 486768 508679 516320 522596 526082 529897 530703 531117 531249 531877 532746 532789 533594 534129 534536 536212 537220 538925 547477 547856 555130 571194 571213 576981 583730 588507 589761 592384 595761 603273 606405 606514 610540 628110 630552 647602 660427 665973 666579 671714 673357 673613 676088 682250 690809 692188 699385 703062 705278 711997 712891 717839 717880 720207 721715 723497 724109 724309 724996 728215 736226 742356 742804 744389 748475 756383 760240 761781 770823 772714 788294 790389 790842 807196 815210 815866 817156 817537 817866 818290 820678 820765 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин double анал"
]
|
||||||||||||||||||||||||||||||
|
2.15 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother double anal"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин double анал"
]
|
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.