Query Metrics
7
Database Queries
7
Different statements
589.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
419.82 ms (71.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ukrainian ass"
]
|
||||||||||||||||||||||||||||||
|
144.77 ms (24.55%) |
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 61226 346082 398942 400869 408318 411469 411907 420005 424007 424030 425149 426407 426770 426935 432380 432545 435742 437233 439560 441593 443408 443706 447512 448896 451463 451514 453642 455649 458882 458884 461783 462299 463174 470010 470107 470975 472421 473116 474069 474484 479928 483186 483815 483901 484904 486627 486811 487602 487623 491594 492641 495811 496029 496053 499868 502930 504716 506639 507435 507445 510127 511083 511166 511310 517883 518267 518341 520309 531553 533652 533662 533673 537972 537981 543769 545634 568684 571996 579105 579223 591210 597174 597548 598501 616722 617642 623385 631393 650104 659377 660669 662780 663166 667971 672809 674954 695097 711149 712953 714571 721580 721582 725169 726757 727813 731670 735115 741710 745072 760517 762672 784169 787286 787484 791507 810780 814985 828549 ] |
||||||||||||||||||||||||||||||
|
17.16 ms (2.91%) |
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 674954 537981 584655 662780 597548 616722 617642 424007 432380 408318 447512 667971 533652 502930 531553 533662 537972 660669 672809 711149 787286 784169 760517 735115 470107 425149 453642 426770 461783 458884 420005 426407 579105 435742 455649 517883 507435 439560 695097 458882 398942 511083 543769 631393 437233 484904 650104 483901 496029 499868 533673 474069 579223 598501 725169 727813 810780 443706 451514 463174 506639 486627 510127 483815 491594 511166 511310 518341 495811 504716 507445 520309 411907 568684 721580 712953 591210 791507 741710 726757 745072 762672 764584 731670 623385 714571 721582 545634 479928 814985 659377 571996 448896 462299 400869 411469 443408 472421 470975 518267 496053 492641 451463 828549 441593 663166 474484 787484 432545 426935 470010 483186 487623 486811 487602 61226 424030 473116 597174 346082 ] |
||||||||||||||||||||||||||||||
|
3.77 ms (0.64%) |
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 61226 346082 398942 400869 408318 411469 411907 420005 424007 424030 425149 426407 426770 426935 432380 432545 435742 437233 439560 441593 443408 443706 447512 448896 451463 451514 453642 455649 458882 458884 461783 462299 463174 470010 470107 470975 472421 473116 474069 474484 479928 483186 483815 483901 484904 486627 486811 487602 487623 491594 492641 495811 496029 496053 499868 502930 504716 506639 507435 507445 510127 511083 511166 511310 517883 518267 518341 520309 531553 533652 533662 533673 537972 537981 543769 545634 568684 571996 579105 579223 591210 597174 597548 598501 616722 617642 623385 631393 650104 659377 660669 662780 663166 667971 672809 674954 695097 711149 712953 714571 721580 721582 725169 726757 727813 731670 735115 741710 745072 760517 762672 784169 787286 787484 791507 810780 814985 828549 ] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие русск жоп"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.23%) |
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.