Query Metrics
7
Database Queries
7
Different statements
184.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.31 ms (88.16%) |
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 22843 131602 212793 346126 383225 397173 397670 468232 488359 491244 517035 520148 530398 531742 533206 533250 536756 537785 539316 540077 540129 543679 547412 548945 553144 553185 554888 555205 555210 555227 555724 558541 558631 560912 561954 567470 567982 568211 574172 574319 575253 575885 576482 579783 581551 582729 583301 584031 584219 592219 593271 594321 599242 606123 609757 609761 611496 619989 627671 628358 633715 636765 637328 641627 643458 647530 649356 650719 651158 651322 652984 659015 661619 663284 664191 664477 666116 666491 667738 669655 669876 678776 682829 690300 696960 701909 702354 702377 706666 714076 726133 740823 744129 749426 750371 750507 751185 753613 753617 772329 774730 777164 779263 781934 784929 790447 802305 805699 807053 807283 811219 812284 813114 824112 825800 826973 827498 827553 827630 827712 ] |
||||||||||||||||||||||||||||||
|
10.56 ms (5.74%) |
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 517035 540077 533206 553185 574172 575885 579783 581551 650719 669655 678776 682829 701909 652984 696960 702377 664191 558541 574319 575253 582729 584219 619989 606123 627671 636765 643458 594321 609757 774730 807283 777164 813114 740823 805699 811219 772329 744129 753617 749426 750507 753613 609761 702354 779263 790447 802305 807053 397670 468232 488359 561954 690300 531742 548945 558631 383225 397173 827630 824112 825800 491244 520148 530398 537785 539316 536756 540129 547412 553144 576482 555205 555210 555724 567470 568211 651158 664477 666116 659015 667738 560912 628358 592219 593271 781934 784929 750371 812284 726133 751185 706666 212793 131602 346126 22843 826973 827498 827553 827712 533250 583301 584031 543679 554888 555227 649356 661619 714076 647530 651322 663284 666491 669876 567982 641627 599242 611496 633715 637328 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (1.84%) |
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 22843 131602 212793 346126 383225 397173 397670 468232 488359 491244 517035 520148 530398 531742 533206 533250 536756 537785 539316 540077 540129 543679 547412 548945 553144 553185 554888 555205 555210 555227 555724 558541 558631 560912 561954 567470 567982 568211 574172 574319 575253 575885 576482 579783 581551 582729 583301 584031 584219 592219 593271 594321 599242 606123 609757 609761 611496 619989 627671 628358 633715 636765 637328 641627 643458 647530 649356 650719 651158 651322 652984 659015 661619 663284 664191 664477 666116 666491 667738 669655 669876 678776 682829 690300 696960 701909 702354 702377 706666 714076 726133 740823 744129 749426 750371 750507 751185 753613 753617 772329 774730 777164 779263 781934 784929 790447 802305 805699 807053 807283 811219 812284 813114 824112 825800 826973 827498 827553 827630 827712 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло девушк shower"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo girl shower"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло девушк shower"
]
|
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.