Query Metrics
7
Database Queries
7
Different statements
374.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.51 ms (56.69%) |
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 387265 387522 388378 404354 409952 417137 431594 448623 452332 454346 458665 467197 469873 471610 472797 478251 489767 498171 503906 509431 513184 514405 518299 523893 533770 534111 535849 536740 537748 538194 538200 538208 538209 538213 538240 538370 538409 542404 542797 543532 549337 552103 552958 561443 562785 564599 565142 573605 573828 573848 573853 574524 576975 596238 609240 610421 613444 613985 617348 628985 633708 634827 636266 645825 645832 645847 645956 646188 659241 661130 661579 661788 669195 670725 671894 679399 679533 691444 692032 695758 695789 695984 696271 696277 698976 707287 709804 716812 717013 719546 721102 723990 724519 728350 735342 735430 736288 739292 739329 740219 741617 742515 746055 746778 748058 753736 760515 761888 762275 762964 763057 774381 778411 778424 789939 799808 804596 807203 810687 813337 ] |
||||||||||||||||||||||||||||||
|
142.71 ms (38.07%) |
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 387265 387522 388378 404354 409952 417137 431594 448623 452332 454346 458665 467197 469873 471610 472797 478251 489767 498171 503906 509431 513184 514405 518299 523893 533770 534111 535849 536740 537748 538194 538200 538208 538209 538213 538240 538370 538409 542404 542797 543532 549337 552103 552958 561443 562785 564599 565142 573605 573828 573848 573853 574524 576975 596238 609240 610421 613444 613985 617348 628985 633708 634827 636266 645825 645832 645847 645956 646188 659241 661130 661579 661788 669195 670725 671894 679399 679533 691444 692032 695758 695789 695984 696271 696277 698976 707287 709804 716812 717013 719546 721102 723990 724519 728350 735342 735430 736288 739292 739329 740219 741617 742515 746055 746778 748058 753736 760515 761888 762275 762964 763057 774381 778411 778424 789939 799808 804596 807203 810687 813337 ] |
||||||||||||||||||||||||||||||
|
13.10 ms (3.49%) |
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 807203 538409 778411 538208 633708 538213 471610 509431 761888 417137 538370 576975 717013 691444 724519 813337 617348 535849 610421 804596 753736 469873 536740 543532 549337 561443 552103 573605 573828 645825 679533 695758 696277 707287 719546 645956 661130 695984 645847 659241 661579 661788 670725 671894 679399 692032 695789 696271 574524 613444 636266 596238 628985 810687 723990 741617 746778 748058 762275 799808 736288 728350 763057 742515 746055 760515 721102 778424 789939 669195 498171 716812 452332 503906 533770 537748 534111 514405 467197 542797 573848 698976 709804 431594 478251 472797 538240 538194 538200 538209 513184 542404 646188 645832 573853 609240 735342 739329 740219 762964 735430 739292 634827 774381 489767 564599 613985 388378 448623 552958 409952 458665 562785 404354 565142 387265 387522 454346 523893 518299 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"porn большой большие член"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"porn big dick"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.28 ms (0.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"porn большой большие член"
]
|
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.