Query Metrics
7
Database Queries
7
Different statements
274.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
250.94 ms (91.39%) |
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 329912 362615 397973 401517 401809 415048 419998 421435 427759 429221 432418 432461 433418 437733 450065 451161 456405 457295 459032 461830 465700 466460 472622 488797 489347 492816 493763 496456 497683 497687 498993 503816 508282 508802 509149 517299 518794 519712 519862 521109 532814 534559 535427 538725 540021 540985 540987 545108 545855 547074 547082 554797 555602 562736 571975 572901 574391 577312 584425 584504 584905 585365 587214 587959 588791 590165 591041 591162 593120 595129 595582 595706 601101 604466 605196 608516 610101 613932 634711 643827 657865 659354 663749 666024 669062 675638 680242 686917 690884 713727 714484 732745 732767 735678 737673 739089 739961 751822 757232 757974 762899 766656 769476 770281 776035 784959 786412 787722 789790 793151 796629 796650 796696 797051 799949 803374 808580 812738 812743 821848 ] |
||||||||||||||||||||||||||||||
|
15.08 ms (5.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 492816 489347 591162 789790 796629 803374 797051 812738 419998 465700 509149 519862 538725 554797 608516 532814 595129 643827 508802 585365 732767 362615 675638 577312 587959 401517 401809 540021 690884 584504 429221 713727 796696 808580 786412 769476 737673 757232 601101 415048 496456 535427 547074 584425 547082 574391 610101 587214 739961 751822 776035 437733 517299 432461 457295 534559 799949 787722 732745 735678 488797 590165 666024 450065 657865 571975 329912 397973 451161 518794 669062 634711 796650 784959 793151 757974 766656 739089 432418 461830 456405 508282 497687 659354 686917 714484 595706 604466 588791 663749 427759 545855 562736 812743 762899 821848 472622 613932 503816 572901 605196 593120 521109 498993 540985 584905 680242 519712 497683 540987 459032 433418 493763 555602 545108 591041 770281 421435 466460 595582 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (0.95%) |
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 329912 362615 397973 401517 401809 415048 419998 421435 427759 429221 432418 432461 433418 437733 450065 451161 456405 457295 459032 461830 465700 466460 472622 488797 489347 492816 493763 496456 497683 497687 498993 503816 508282 508802 509149 517299 518794 519712 519862 521109 532814 534559 535427 538725 540021 540985 540987 545108 545855 547074 547082 554797 555602 562736 571975 572901 574391 577312 584425 584504 584905 585365 587214 587959 588791 590165 591041 591162 593120 595129 595582 595706 601101 604466 605196 608516 610101 613932 634711 643827 657865 659354 663749 666024 669062 675638 680242 686917 690884 713727 714484 732745 732767 735678 737673 739089 739961 751822 757232 757974 762899 766656 769476 770281 776035 784959 786412 787722 789790 793151 796629 796650 796696 797051 799949 803374 808580 812738 812743 821848 ] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black girl homemade"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.60%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black девушк домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.51%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.25 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black девушк домашн любительск"
]
|
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.