Query Metrics
7
Database Queries
7
Different statements
172.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.14 ms (85.99%) |
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 249630 355294 382057 382110 391506 396690 422267 427975 433441 434420 451095 453705 455459 456000 456457 459042 468969 472669 474669 477171 481315 483356 483361 489703 489838 492329 503501 505447 508239 508812 509235 509656 512416 514160 514268 517011 518605 522868 522882 523829 524495 531979 540207 542793 544321 549131 555288 565785 585539 586806 589739 590499 609422 615640 617019 620780 628709 670415 677511 695128 695188 696350 698259 699594 704522 707497 714496 716535 717949 724280 725459 727381 730991 739925 741044 743817 746453 747129 754158 755056 758149 761375 766878 769566 772525 773073 774364 774394 774406 777371 778289 779248 786195 786197 786269 790859 792773 793498 795935 795939 795970 796875 797379 797703 799054 801436 803062 805978 806201 806341 807016 811480 816938 817004 823179 823720 824294 824883 826761 828439 ] |
||||||||||||||||||||||||||||||
|
15.45 ms (8.97%) |
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 555288 714496 786195 786197 806201 477171 509235 586806 826761 544321 797703 807016 725459 773073 774364 724280 549131 727381 459042 509656 524495 523829 774406 799054 396690 778289 754158 481315 422267 590499 456000 514160 518605 468969 433441 427975 542793 670415 503501 489703 483356 772525 730991 755056 746453 769566 758149 617019 522868 704522 382057 774394 792773 355294 777371 489838 453705 508812 585539 382110 531979 522882 699594 620780 790859 766878 472669 474669 505447 823179 828439 512416 492329 565785 455459 434420 451095 456457 508239 483361 514268 391506 823720 824883 779248 795970 805978 786269 795935 795939 797379 739925 793498 517011 816938 677511 695188 696350 698259 717949 615640 628709 589739 609422 741044 796875 747129 743817 707497 716535 806341 811480 817004 540207 803062 761375 249630 824294 695128 801436 ] |
||||||||||||||||||||||||||||||
|
2.63 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 249630 355294 382057 382110 391506 396690 422267 427975 433441 434420 451095 453705 455459 456000 456457 459042 468969 472669 474669 477171 481315 483356 483361 489703 489838 492329 503501 505447 508239 508812 509235 509656 512416 514160 514268 517011 518605 522868 522882 523829 524495 531979 540207 542793 544321 549131 555288 565785 585539 586806 589739 590499 609422 615640 617019 620780 628709 670415 677511 695128 695188 696350 698259 699594 704522 707497 714496 716535 717949 724280 725459 727381 730991 739925 741044 743817 746453 747129 754158 755056 758149 761375 766878 769566 772525 773073 774364 774394 774406 777371 778289 779248 786195 786197 786269 790859 792773 793498 795935 795939 795970 796875 797379 797703 799054 801436 803062 805978 806201 806341 807016 811480 816938 817004 823179 823720 824294 824883 826761 828439 ] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"handjob mother"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк член мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.80%) |
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.