Query Metrics
7
Database Queries
7
Different statements
512.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
271.77 ms (52.98%) |
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 146855 282006 391209 395389 398022 400418 407567 410524 410953 415209 415487 417343 417758 419561 423994 425670 437963 443443 444653 445941 447124 447494 451275 456110 457556 458937 460488 460801 461482 463300 464096 464492 465938 466197 466673 468166 470313 471327 471962 473073 475353 476681 481183 483026 483322 483430 484350 488135 488282 491188 491729 497247 500698 500905 501755 502047 506144 506287 506445 506463 508546 508836 509648 511235 512232 513724 513771 513877 514408 516605 519021 519871 521368 521934 522971 524084 524757 524855 525543 525766 542936 546001 546639 552079 552116 552404 554173 554570 555806 557507 558520 562324 563801 566728 568359 570667 574700 574961 593382 595359 598066 599317 605515 605833 613129 622932 629124 642816 654446 657603 659091 659656 660476 681756 730918 736185 754829 760067 785923 804193 ] |
||||||||||||||||||||||||||||||
|
211.32 ms (41.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие девушк красивая"
]
|
||||||||||||||||||||||||||||||
|
20.89 ms (4.07%) |
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 593382 605833 466673 475353 417343 447494 464096 471327 525543 804193 407567 483322 451275 443443 500698 522971 146855 398022 488135 500905 506144 654446 598066 415487 461482 395389 460801 417758 476681 410953 502047 484350 483026 519021 521368 521934 483430 464492 554570 524084 415209 516605 514408 557507 525766 785923 760067 524855 391209 425670 574700 622932 599317 613129 566728 444653 574961 659656 660476 657603 659091 681756 629124 730918 736185 754829 595359 457556 410524 471962 491188 497247 554173 546001 552404 463300 465938 468166 282006 445941 470313 419561 437963 458937 481183 512232 513877 519871 491729 506287 511235 513724 506463 508546 509648 524757 488282 501755 508836 513771 546639 400418 456110 460488 555806 563801 568359 542936 570667 552079 552116 558520 562324 642816 605515 423994 466197 473073 447124 506445 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (0.58%) |
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 146855 282006 391209 395389 398022 400418 407567 410524 410953 415209 415487 417343 417758 419561 423994 425670 437963 443443 444653 445941 447124 447494 451275 456110 457556 458937 460488 460801 461482 463300 464096 464492 465938 466197 466673 468166 470313 471327 471962 473073 475353 476681 481183 483026 483322 483430 484350 488135 488282 491188 491729 497247 500698 500905 501755 502047 506144 506287 506445 506463 508546 508836 509648 511235 512232 513724 513771 513877 514408 516605 519021 519871 521368 521934 522971 524084 524757 524855 525543 525766 542936 546001 546639 552079 552116 552404 554173 554570 555806 557507 558520 562324 563801 566728 568359 570667 574700 574961 593382 595359 598066 599317 605515 605833 613129 622932 629124 642816 654446 657603 659091 659656 660476 681756 730918 736185 754829 760067 785923 804193 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие девушк красивая"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (0.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big girl beautiful"
]
|
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.