Query Metrics
7
Database Queries
7
Different statements
590.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
416.47 ms (70.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot черноволосая"
]
|
||||||||||||||||||||||||||||||
|
149.03 ms (25.25%) |
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 395170 409894 415388 422464 423332 423535 431812 435716 444337 445738 448216 448354 449048 449358 451108 452650 452916 452928 456226 461221 465827 469475 471316 472536 476761 476981 477232 478905 479457 483564 485249 487534 489906 490458 490931 493269 494419 500789 501841 502508 502587 506315 513431 514570 516601 517363 518216 519227 519354 522647 523890 524027 524504 526659 534106 542097 543445 552411 561113 561451 565462 566758 569495 571062 573473 578774 580288 584431 584451 584463 591073 592440 593935 597042 598921 599080 602636 603783 603786 604093 604803 607432 615672 615979 621742 623402 623416 644065 665110 667644 673126 684383 685613 692859 698386 719228 723848 731821 734481 752112 756016 761133 762638 773257 777057 787101 787586 790213 790490 790930 797106 798039 800533 805429 811449 814878 816459 821745 825335 826459 ] |
||||||||||||||||||||||||||||||
|
15.97 ms (2.71%) |
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 821745 452650 487534 502508 500789 472536 584431 584463 552411 561451 685613 684383 580288 602636 623416 777057 790930 800533 762638 761133 621742 623402 790213 465827 477232 490931 523890 490458 667644 603783 607432 452928 395170 506315 489906 542097 569495 571062 561113 573473 431812 423535 514570 543445 826459 814878 451108 517363 692859 604093 604803 805429 734481 773257 476981 449358 476761 519354 422464 485249 501841 526659 665110 479457 483564 493269 524504 565462 591073 456226 478905 502587 524027 534106 423332 469475 566758 599080 603786 787586 516601 415388 409894 445738 522647 578774 592440 615979 644065 435716 494419 449048 518216 519227 471316 444337 448216 752112 756016 448354 461221 598921 513431 584451 593935 816459 452916 719228 673126 811449 723848 825335 787101 798039 731821 698386 790490 797106 597042 615672 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (0.52%) |
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 395170 409894 415388 422464 423332 423535 431812 435716 444337 445738 448216 448354 449048 449358 451108 452650 452916 452928 456226 461221 465827 469475 471316 472536 476761 476981 477232 478905 479457 483564 485249 487534 489906 490458 490931 493269 494419 500789 501841 502508 502587 506315 513431 514570 516601 517363 518216 519227 519354 522647 523890 524027 524504 526659 534106 542097 543445 552411 561113 561451 565462 566758 569495 571062 573473 578774 580288 584431 584451 584463 591073 592440 593935 597042 598921 599080 602636 603783 603786 604093 604803 607432 615672 615979 621742 623402 623416 644065 665110 667644 673126 684383 685613 692859 698386 719228 723848 731821 734481 752112 756016 761133 762638 773257 777057 787101 787586 790213 790490 790930 797106 798039 800533 805429 811449 814878 816459 821745 825335 826459 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot brunette"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot черноволосая"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.