Query Metrics
7
Database Queries
7
Different statements
189.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.23 ms (86.24%) |
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 61243 74135 386531 391327 401810 408911 410682 412180 414090 415966 416035 416523 416527 416531 416649 416690 416703 418862 419167 423435 424195 428728 430103 432408 432501 432944 441413 450357 451336 452744 453208 456190 459849 466639 468943 470471 471455 474596 480206 483742 487414 487649 491877 492287 493626 496730 504003 511866 513830 516611 522359 524675 529296 540005 541377 541421 545404 545453 550916 568501 582741 589042 594411 598638 601208 612243 616843 618231 636907 642149 656173 657232 658802 658816 662049 662856 678732 682755 695875 696593 698912 703619 709542 711957 720101 723589 725713 728377 738515 738822 742363 744021 744938 749215 749221 752603 752652 752675 752681 752712 752755 755821 766941 767793 770254 770258 770262 770456 774672 782836 783702 784217 786793 792706 799759 804939 806924 811700 814487 814546 ] |
||||||||||||||||||||||||||||||
|
14.26 ms (7.53%) |
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 814546 452744 493626 529296 540005 656173 698912 720101 636907 642149 594411 774672 783702 784217 786793 799759 806924 749215 804939 766941 767793 770258 728377 744938 770456 725713 738515 792706 432408 415966 410682 545404 471455 391327 414090 428728 416649 419167 432944 487414 453208 470471 491877 474596 480206 582741 424195 456190 468943 386531 466639 416523 423435 451336 522359 412180 416703 430103 598638 483742 74135 61243 401810 416035 432501 418862 441413 459849 511866 513830 516611 524675 550916 541377 657232 662049 711957 658802 662856 695875 709542 616843 589042 601208 612243 782836 811700 752603 752681 755821 749221 752652 752675 752712 770262 738822 742363 752755 744021 770254 618231 450357 416527 416531 408911 416690 723589 814487 496730 504003 487649 492287 545453 541421 568501 682755 703619 678732 696593 658816 ] |
||||||||||||||||||||||||||||||
|
4.29 ms (2.27%) |
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 61243 74135 386531 391327 401810 408911 410682 412180 414090 415966 416035 416523 416527 416531 416649 416690 416703 418862 419167 423435 424195 428728 430103 432408 432501 432944 441413 450357 451336 452744 453208 456190 459849 466639 468943 470471 471455 474596 480206 483742 487414 487649 491877 492287 493626 496730 504003 511866 513830 516611 522359 524675 529296 540005 541377 541421 545404 545453 550916 568501 582741 589042 594411 598638 601208 612243 616843 618231 636907 642149 656173 657232 658802 658816 662049 662856 678732 682755 695875 696593 698912 703619 709542 711957 720101 723589 725713 728377 738515 738822 742363 744021 744938 749215 749221 752603 752652 752675 752681 752712 752755 755821 766941 767793 770254 770258 770262 770456 774672 782836 783702 784217 786793 792706 799759 804939 806924 811700 814487 814546 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam teen huge"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер teen огромные"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер teen огромные"
]
|
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.