Query Metrics
7
Database Queries
7
Different statements
172.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.88 ms (84.63%) |
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 382255 382289 385334 400481 406990 407554 407769 408381 408558 411710 420439 422512 424466 442829 443184 447308 452034 456610 458327 462290 463157 463842 465524 466102 466976 467034 467435 468537 474008 474634 484362 484519 484582 484696 487340 487928 490204 490623 490920 492208 495317 499482 503967 506511 508375 513696 515134 518549 518909 522771 528851 530690 531413 546113 546372 546375 546622 553700 553720 554321 557175 562894 569421 573342 573889 599496 599835 601381 601952 608354 610588 614518 618784 618889 622410 622794 623982 627726 631968 651887 665444 666780 673608 677125 679810 682199 693967 707539 707597 716220 726981 727667 727924 730735 731775 731777 781733 781812 782232 782253 788879 788881 789998 792529 798681 799262 799585 803091 803093 803297 807543 807976 807991 811826 814235 814931 815940 816371 820173 820330 ] |
||||||||||||||||||||||||||||||
|
16.35 ms (9.48%) |
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 508375 407554 382255 815940 442829 490623 503967 420439 490204 608354 789998 730735 731775 807543 382289 400481 463842 499482 573342 466102 522771 677125 531413 816371 554321 665444 666780 599496 601952 788879 727924 807991 452034 814235 513696 422512 515134 707597 484696 693967 467435 569421 492208 553720 546622 557175 814931 474008 468537 411710 528851 553700 673608 682199 651887 622794 627726 614518 781733 798681 803091 803093 447308 456610 546372 546375 727667 799262 618889 731777 406990 707539 601381 490920 622410 463157 618784 799585 803297 530690 385334 466976 487340 792529 788881 782232 807976 407769 465524 495317 487928 726981 443184 518909 484362 679810 820330 573889 623982 781812 782253 424466 631968 462290 484582 811826 506511 408558 562894 610588 408381 484519 474634 599835 518549 546113 458327 716220 467034 820173 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.58%) |
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 382255 382289 385334 400481 406990 407554 407769 408381 408558 411710 420439 422512 424466 442829 443184 447308 452034 456610 458327 462290 463157 463842 465524 466102 466976 467034 467435 468537 474008 474634 484362 484519 484582 484696 487340 487928 490204 490623 490920 492208 495317 499482 503967 506511 508375 513696 515134 518549 518909 522771 528851 530690 531413 546113 546372 546375 546622 553700 553720 554321 557175 562894 569421 573342 573889 599496 599835 601381 601952 608354 610588 614518 618784 618889 622410 622794 623982 627726 631968 651887 665444 666780 673608 677125 679810 682199 693967 707539 707597 716220 726981 727667 727924 730735 731775 731777 781733 781812 782232 782253 788879 788881 789998 792529 798681 799262 799585 803091 803093 803297 807543 807976 807991 811826 814235 814931 815940 816371 820173 820330 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young рыжая минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young redhead blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young рыжая минет оральн секс"
]
|
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.