Query Metrics
7
Database Queries
7
Different statements
260.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
235.11 ms (90.23%) |
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 327170 368335 397912 400489 401531 404590 405760 410563 422171 422198 428124 432704 439695 446022 446706 449760 457440 476559 504091 505843 515031 522622 529202 530465 530546 534636 536299 555066 562881 563945 570722 578478 585724 591615 592428 600351 602959 604832 612188 614347 637430 639755 642659 645912 649859 661657 671599 672105 675525 686035 691228 707307 707310 707318 713486 715524 716090 720171 720621 731247 733454 736770 737522 742804 744651 748935 755391 757312 759931 760841 761597 765478 769887 769894 770304 770949 776184 777580 779119 781824 786594 790958 795141 796957 799650 800329 800426 801807 802450 802514 802519 803046 805925 807912 809128 811474 811989 812014 814218 815151 815168 815180 815890 815905 815910 815939 816063 816886 816970 816991 817299 817318 818198 818438 820888 821238 821521 821551 822421 823466 ] |
||||||||||||||||||||||||||||||
|
15.82 ms (6.07%) |
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 563945 686035 713486 649859 671599 672105 691228 716090 600351 639755 637430 799650 809128 802450 759931 765478 731247 769887 770949 755391 748935 770304 707307 707310 720171 776184 800329 801807 736770 446022 449760 515031 428124 585724 602959 457440 815180 815890 816063 816991 816886 821238 822421 815910 821521 530465 715524 592428 795141 811989 760841 802514 811474 534636 803046 410563 400489 733454 786594 432704 818198 555066 675525 720621 614347 777580 796957 757312 807912 404590 476559 327170 439695 446706 529202 578478 812014 761597 522622 422171 422198 504091 505843 530546 814218 707318 562881 604832 781824 802519 737522 742804 744651 779119 805925 397912 816970 817318 820888 815905 815939 815151 815168 817299 818438 821551 823466 536299 661657 645912 591615 612188 642659 790958 800426 769894 401531 368335 405760 570722 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.06%) |
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 327170 368335 397912 400489 401531 404590 405760 410563 422171 422198 428124 432704 439695 446022 446706 449760 457440 476559 504091 505843 515031 522622 529202 530465 530546 534636 536299 555066 562881 563945 570722 578478 585724 591615 592428 600351 602959 604832 612188 614347 637430 639755 642659 645912 649859 661657 671599 672105 675525 686035 691228 707307 707310 707318 713486 715524 716090 720171 720621 731247 733454 736770 737522 742804 744651 748935 755391 757312 759931 760841 761597 765478 769887 769894 770304 770949 776184 777580 779119 781824 786594 790958 795141 796957 799650 800329 800426 801807 802450 802514 802519 803046 805925 807912 809128 811474 811989 812014 814218 815151 815168 815180 815890 815905 815910 815939 816063 816886 816970 816991 817299 817318 818198 818438 820888 821238 821521 821551 822421 823466 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf anal mom"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.67%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.66%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf анал mom"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf анал mom"
]
|
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.