Query Metrics
7
Database Queries
7
Different statements
166.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.05 ms (81.56%) |
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 386142 388341 391386 396253 397392 404415 404584 404778 405028 406698 411681 415160 419956 422192 423332 425523 426294 428224 434309 434376 436942 439801 440632 441853 442128 444831 444916 444918 445408 447276 452293 453568 455126 456293 456516 460040 460673 460804 463976 464328 469357 470015 473391 475684 475869 479422 482527 483373 483978 484681 487746 490262 490511 491802 491823 494833 495051 504474 505526 505548 506081 508180 513025 513135 513141 513775 513949 514070 515964 517604 518493 523537 529485 531804 537970 538794 540511 541055 543852 549239 555317 558490 566374 567336 573754 574258 577392 583757 584352 596925 604429 605521 605586 609794 610606 614766 614770 614827 614831 614835 615382 618185 622675 630063 634071 660144 688116 689424 689436 714346 714479 724305 731158 807852 ] |
||||||||||||||||||||||||||||||
|
19.74 ms (11.83%) |
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 460040 724305 505526 731158 484681 483373 404415 538794 614770 614766 807852 479422 508180 513949 574258 537970 428224 634071 513775 396253 541055 411681 447276 714479 386142 469357 513135 610606 660144 614835 404778 405028 558490 419956 523537 482527 605586 388341 444831 515964 504474 456516 573754 404584 517604 475869 444918 456293 543852 406698 470015 495051 540511 518493 422192 566374 714346 618185 630063 622675 436942 460673 689424 605521 513025 391386 425523 426294 475684 614831 491823 445408 513141 490511 442128 455126 434309 441853 494833 531804 583757 555317 689436 596925 549239 491802 615382 487746 397392 444916 439801 440632 567336 483978 453568 505548 614827 460804 464328 473391 415160 688116 423332 584352 609794 434376 490262 506081 514070 529485 452293 577392 463976 604429 ] |
||||||||||||||||||||||||||||||
|
3.62 ms (2.17%) |
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 386142 388341 391386 396253 397392 404415 404584 404778 405028 406698 411681 415160 419956 422192 423332 425523 426294 428224 434309 434376 436942 439801 440632 441853 442128 444831 444916 444918 445408 447276 452293 453568 455126 456293 456516 460040 460673 460804 463976 464328 469357 470015 473391 475684 475869 479422 482527 483373 483978 484681 487746 490262 490511 491802 491823 494833 495051 504474 505526 505548 506081 508180 513025 513135 513141 513775 513949 514070 515964 517604 518493 523537 529485 531804 537970 538794 540511 541055 543852 549239 555317 558490 566374 567336 573754 574258 577392 583757 584352 596925 604429 605521 605586 609794 610606 614766 614770 614827 614831 614835 615382 618185 622675 630063 634071 660144 688116 689424 689436 714346 714479 724305 731158 807852 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая анал жен"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy anal wife"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.98%) |
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.