Query Metrics
7
Database Queries
7
Different statements
162.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.16 ms (75.87%) |
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 33756 118262 287347 382173 382507 394130 395732 395803 396449 396657 398433 400664 402526 404230 409730 412066 415714 417609 438816 454900 454907 457989 467168 470314 471386 484787 488127 491443 494378 497609 498377 511207 513309 515540 515895 523304 524367 524644 525630 531779 538870 539538 542243 547352 549331 549347 549999 550042 556328 556432 560164 561124 563700 564247 565062 568314 568902 570406 570796 571268 573385 575844 576055 576289 576363 577382 577847 579607 581437 582780 584723 586883 589112 589928 590401 591276 592535 595161 597241 600138 601629 610034 618747 620051 621653 622043 627155 627648 627656 630250 630479 635703 647627 649983 667051 668625 671725 672161 698031 702517 714761 723073 726429 752093 771859 777151 778141 786836 788540 808409 810349 811999 814513 818374 818912 821152 821419 823330 825630 ] |
||||||||||||||||||||||||||||||
|
20.17 ms (12.42%) |
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 525630 523304 402526 818374 821419 825630 515895 498377 484787 549331 576055 556432 571268 573937 581437 584723 547352 564247 668625 672161 647627 667051 723073 549347 600138 621653 622043 635703 590401 627648 589928 627656 808409 771859 601629 702517 778141 409730 33756 618747 818912 823330 538870 542243 568314 573385 556328 560164 671725 561124 592535 586883 610034 630479 591276 627155 786836 810349 777151 811999 577847 471386 491443 570406 497609 395732 417609 467168 620051 438816 382173 752093 398433 396657 549999 563700 576363 582780 565062 550042 589112 597241 494378 524367 287347 400664 531779 649983 382507 570796 396449 404230 412066 511207 488127 457989 576289 395803 698031 454900 454907 568902 714761 726429 118262 814513 595161 788540 515540 579607 577382 575844 630250 470314 524644 394130 415714 821152 513309 539538 ] |
||||||||||||||||||||||||||||||
|
9.10 ms (5.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sport girl"
]
|
||||||||||||||||||||||||||||||
|
4.15 ms (2.56%) |
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 33756 118262 287347 382173 382507 394130 395732 395803 396449 396657 398433 400664 402526 404230 409730 412066 415714 417609 438816 454900 454907 457989 467168 470314 471386 484787 488127 491443 494378 497609 498377 511207 513309 515540 515895 523304 524367 524644 525630 531779 538870 539538 542243 547352 549331 549347 549999 550042 556328 556432 560164 561124 563700 564247 565062 568314 568902 570406 570796 571268 573385 575844 576055 576289 576363 577382 577847 579607 581437 582780 584723 586883 589112 589928 590401 591276 592535 595161 597241 600138 601629 610034 618747 620051 621653 622043 627155 627648 627656 630250 630479 635703 647627 649983 667051 668625 671725 672161 698031 702517 714761 723073 726429 752093 771859 777151 778141 786836 788540 808409 810349 811999 814513 818374 818912 821152 821419 823330 825630 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"спортивная девушк"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.16%) |
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.