Query Metrics
7
Database Queries
7
Different statements
148.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.54 ms (80.77%) |
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 395624 441427 441510 441577 441587 446950 449582 451007 456993 458070 460715 462304 467833 469495 470720 480339 482894 483175 485039 487188 489022 491588 492754 495129 496510 497615 500152 506696 509933 510725 511182 521019 521179 524118 525435 525458 528616 528892 540724 540729 542330 546865 549477 557380 560461 561013 563294 564300 567523 567828 571772 580491 580519 588125 588844 590807 591420 599481 602430 602872 604583 605030 605928 617706 622465 625134 625259 645663 649094 650280 651794 653778 674954 675890 685051 693246 693278 695790 695873 699197 699444 700941 703021 724378 729905 731060 733706 734794 736554 736928 740129 740225 743991 751725 759955 761273 762169 763850 775148 776007 784015 784513 784564 786420 788007 791025 791507 794818 797072 799414 800365 803509 807464 809979 810157 810365 811405 817151 825564 ] |
||||||||||||||||||||||||||||||
|
17.90 ms (12.10%) |
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 784564 740129 733706 736554 762169 724378 743991 759955 736928 776007 786420 480339 446950 460715 525435 649094 693246 693278 511182 604583 496510 441510 441587 817151 825564 458070 449582 483175 588125 591420 791507 800365 803509 784513 799414 810365 761273 703021 784015 791025 797072 807464 811405 395624 469495 467833 510725 462304 542330 695790 651794 653778 546865 625259 602872 625134 588844 599481 605030 622465 528892 492754 489022 456993 441577 675890 699197 685051 580491 605928 699444 470720 441427 487188 451007 482894 485039 521019 525458 561013 567523 571772 580519 602430 590807 788007 775148 784828 794818 734794 763850 731060 729905 751725 810157 540724 500152 521179 495129 528616 740225 617706 809979 491588 497615 540729 524118 506696 509933 567828 549477 560461 564300 563294 674954 700941 645663 695873 650280 557380 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.90%) |
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 395624 441427 441510 441577 441587 446950 449582 451007 456993 458070 460715 462304 467833 469495 470720 480339 482894 483175 485039 487188 489022 491588 492754 495129 496510 497615 500152 506696 509933 510725 511182 521019 521179 524118 525435 525458 528616 528892 540724 540729 542330 546865 549477 557380 560461 561013 563294 564300 567523 567828 571772 580491 580519 588125 588844 590807 591420 599481 602430 602872 604583 605030 605928 617706 622465 625134 625259 645663 649094 650280 651794 653778 674954 675890 685051 693246 693278 695790 695873 699197 699444 700941 703021 724378 729905 731060 733706 734794 736554 736928 740129 740225 743991 751725 759955 761273 762169 763850 775148 776007 784015 784513 784564 786420 788007 791025 791507 794818 797072 799414 800365 803509 807464 809979 810157 810365 811405 817151 825564 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"student homemade"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"student домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"student домашн любительск"
]
|
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.