Query Metrics
7
Database Queries
7
Different statements
162.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.61 ms (86.67%) |
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 384015 386949 398831 403900 409258 412311 413908 414946 417339 420540 420767 427536 437835 438219 446022 447550 451086 463701 476905 479019 485462 489102 489971 500578 512531 515031 517278 517280 525557 531568 531935 532051 532114 532133 533469 538329 546649 550976 554522 561990 563182 563433 567430 567855 571494 573749 573990 575241 579284 591155 591281 598225 599703 599716 616049 617195 617677 619775 628075 628653 646525 667660 674743 680846 688100 693256 695760 702904 710578 712285 712707 713065 713262 714216 715416 715475 715536 716090 716262 725350 725639 726371 726620 727637 728150 731464 736770 736776 742086 742427 744194 744201 751007 756920 757071 772322 775640 779264 785104 788161 789750 790017 797023 797957 804071 805700 805945 806741 807366 807409 807499 808552 812446 815995 818802 821628 823976 824247 824585 826663 ] |
||||||||||||||||||||||||||||||
|
12.90 ms (7.95%) |
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 398831 824247 420540 489971 567855 538329 713065 616049 805945 736770 403900 599703 826663 573749 571494 628653 713262 804071 417339 438219 818802 512531 561990 567430 693256 591281 807499 757071 789750 726620 751007 715536 532051 546649 617677 807409 726371 725639 797023 532114 573990 579284 413908 409258 414946 550976 437835 517280 563182 716262 710578 714216 775640 725350 736776 744194 744201 788161 808552 728150 412311 476905 598225 500578 531935 619775 517278 420767 485462 731464 446022 427536 451086 479019 515031 821628 824585 489102 533469 525557 531568 532133 646525 702904 715416 667660 695760 674743 680846 712285 712707 716090 554522 563433 628075 599716 785104 807366 812446 797957 727637 742086 756920 805700 742427 772322 715475 779264 790017 447550 617195 384015 591155 386949 823976 688100 806741 575241 815995 463701 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.43%) |
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 384015 386949 398831 403900 409258 412311 413908 414946 417339 420540 420767 427536 437835 438219 446022 447550 451086 463701 476905 479019 485462 489102 489971 500578 512531 515031 517278 517280 525557 531568 531935 532051 532114 532133 533469 538329 546649 550976 554522 561990 563182 563433 567430 567855 571494 573749 573990 575241 579284 591155 591281 598225 599703 599716 616049 617195 617677 619775 628075 628653 646525 667660 674743 680846 688100 693256 695760 702904 710578 712285 712707 713065 713262 714216 715416 715475 715536 716090 716262 725350 725639 726371 726620 727637 728150 731464 736770 736776 742086 742427 744194 744201 751007 756920 757071 772322 775640 779264 785104 788161 789750 790017 797023 797957 804071 805700 805945 806741 807366 807409 807499 808552 812446 815995 818802 821628 823976 824247 824585 826663 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck step mom"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс step mom"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс step mom"
]
|
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.