Query Metrics
7
Database Queries
7
Different statements
385.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
362.93 ms (94.21%) |
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 154535 155198 182135 352189 382670 382993 383869 384917 385713 388183 395252 400571 401353 412852 416164 416568 420295 421369 423781 424765 429600 429601 441354 444531 445727 448082 452824 453223 465143 469096 469125 470470 477090 477760 487287 494535 508891 508895 511014 518505 519379 526189 531347 533988 537138 541377 541451 542163 543993 544912 548834 549496 550916 550952 552709 554405 556425 559783 576533 583694 586995 595145 595591 601460 605208 609887 615921 622720 625778 634108 644386 656935 658802 664149 664189 665958 669046 669054 669080 670210 671044 672938 680252 682739 696595 697473 712097 713501 713507 717520 723877 726454 745114 746085 748287 748290 752627 752713 756841 758789 761276 770849 778808 785606 786261 787510 788113 788521 788529 791184 796988 798431 803122 803509 804682 814229 816094 820884 827290 827393 ] |
||||||||||||||||||||||||||||||
|
13.83 ms (3.59%) |
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 448082 424765 671044 664149 669080 615921 820884 477090 533988 550916 541377 548834 552709 664189 658802 669054 697473 665958 672938 680252 682739 713501 713507 605208 601460 786261 803509 804682 770849 622720 778808 788521 182135 756841 352189 382670 814229 549496 712097 696595 544912 595591 791184 723877 788529 796988 726454 745114 746085 748290 761276 625778 827393 477760 487287 669046 556425 384917 400571 429601 827290 453223 452824 519379 511014 537138 550952 554405 583694 541451 559783 586995 595145 787510 469125 388183 518505 429600 441354 470470 526189 543993 788113 758789 785606 803122 420295 508891 508895 421369 816094 469096 656935 416568 465143 382993 383869 155198 445727 385713 401353 423781 542163 576533 717520 670210 644386 609887 752713 748287 752627 154535 395252 798431 416164 531347 634108 412852 494535 444531 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo dildo gape"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.51%) |
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 154535 155198 182135 352189 382670 382993 383869 384917 385713 388183 395252 400571 401353 412852 416164 416568 420295 421369 423781 424765 429600 429601 441354 444531 445727 448082 452824 453223 465143 469096 469125 470470 477090 477760 487287 494535 508891 508895 511014 518505 519379 526189 531347 533988 537138 541377 541451 542163 543993 544912 548834 549496 550916 550952 552709 554405 556425 559783 576533 583694 586995 595145 595591 601460 605208 609887 615921 622720 625778 634108 644386 656935 658802 664149 664189 665958 669046 669054 669080 670210 671044 672938 680252 682739 696595 697473 712097 713501 713507 717520 723877 726454 745114 746085 748287 748290 752627 752713 756841 758789 761276 770849 778808 785606 786261 787510 788113 788521 788529 791184 796988 798431 803122 803509 804682 814229 816094 820884 827290 827393 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло дилд большая большие дырк"
]
|
||||||||||||||||||||||||||||||
|
1.24 ms (0.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло дилд большая большие дырк"
]
|
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.