Query Metrics
7
Database Queries
7
Different statements
173.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.76 ms (85.02%) |
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 182238 383464 387279 398651 407633 419303 420788 427753 427843 435503 436765 440486 440805 440836 440895 441603 444370 444939 449523 449545 449998 452754 457871 458371 459986 463471 465501 467119 468996 480508 494096 506741 513975 516537 517121 517519 521030 521170 522196 524358 524678 525301 525911 528561 529233 529455 529976 531216 538172 539790 555905 557567 557797 565676 577272 577865 584768 586121 587134 587342 589931 592203 595244 626245 629569 636046 647547 651373 652784 656636 662823 673670 683066 694142 697196 699447 703603 703960 712185 722934 726194 726815 738631 741700 741702 742642 744360 745605 751898 753633 761650 762756 762817 762843 763896 764044 765269 767236 768387 768880 769291 772035 786632 788827 792587 794071 795244 796919 797349 798361 800799 802842 803371 808186 808531 811960 812290 824501 ] |
||||||||||||||||||||||||||||||
|
16.18 ms (9.31%) |
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 557797 699447 703960 662823 647547 652784 673670 712185 577272 587134 589931 795244 797349 812290 761650 764044 786632 792587 794071 802842 808531 741700 738631 751898 753633 762756 762843 803371 182238 517519 525911 538172 587342 440805 441603 436765 449545 626899 726815 480508 697196 629569 796919 383464 387279 444370 427753 459986 457871 539790 522196 584768 577865 651373 694142 683066 703603 586121 811960 788827 772035 798361 808186 741702 726194 763896 768387 768880 762817 742642 744360 398651 420788 528561 440486 468996 525301 557567 656636 592203 626245 636046 745605 765269 767236 769291 419303 444939 440895 524358 529233 565676 449998 506741 516537 796642 513975 722934 435503 463471 465501 524678 595244 800799 427843 521170 407633 440836 824501 452754 449523 458371 467119 531216 529976 517121 494096 521030 529455 555905 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.50%) |
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 182238 383464 387279 398651 407633 419303 420788 427753 427843 435503 436765 440486 440805 440836 440895 441603 444370 444939 449523 449545 449998 452754 457871 458371 459986 463471 465501 467119 468996 480508 494096 506741 513975 516537 517121 517519 521030 521170 522196 524358 524678 525301 525911 528561 529233 529455 529976 531216 538172 539790 555905 557567 557797 565676 577272 577865 584768 586121 587134 587342 589931 592203 595244 626245 629569 636046 647547 651373 652784 656636 662823 673670 683066 694142 697196 699447 703603 703960 712185 722934 726194 726815 738631 741700 741702 742642 744360 745605 751898 753633 761650 762756 762817 762843 763896 764044 765269 767236 768387 768880 769291 772035 786632 788827 792587 794071 795244 796919 797349 798361 800799 802842 803371 808186 808531 811960 812290 824501 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cowgirl big ass"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cowgirl большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cowgirl большая большие жоп"
]
|
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.