Query Metrics
7
Database Queries
7
Different statements
436.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.30 ms (47.54%) |
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 21323 31708 163762 326944 382018 384268 385105 388718 390569 391186 391208 396780 397867 399738 401816 404278 409878 410724 411009 411182 415554 415847 420218 428728 428801 430468 439174 440646 450399 463748 464676 465536 469536 471628 475448 475938 477407 482330 495666 496107 496441 512205 512215 515749 516816 518949 519291 525197 531222 532109 535110 535617 539524 541175 545484 545532 546219 551005 551953 551994 552043 552927 554788 556363 556397 556428 557814 557823 558429 559162 559852 559881 559886 562849 565468 565986 565993 566488 566605 572734 579347 580266 585388 586590 590934 591836 595785 598289 599820 600539 600626 601154 619411 619412 621034 623599 628167 636658 642793 653415 706373 706610 720306 740804 768164 771807 771823 771936 774690 776911 785024 786454 807641 817300 818148 818335 820741 820780 823515 823636 ] |
||||||||||||||||||||||||||||||
|
206.95 ms (47.45%) |
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 21323 31708 163762 326944 382018 384268 385105 388718 390569 391186 391208 396780 397867 399738 401816 404278 409878 410724 411009 411182 415554 415847 420218 428728 428801 430468 439174 440646 450399 463748 464676 465536 469536 471628 475448 475938 477407 482330 495666 496107 496441 512205 512215 515749 516816 518949 519291 525197 531222 532109 535110 535617 539524 541175 545484 545532 546219 551005 551953 551994 552043 552927 554788 556363 556397 556428 557814 557823 558429 559162 559852 559881 559886 562849 565468 565986 565993 566488 566605 572734 579347 580266 585388 586590 590934 591836 595785 598289 599820 600539 600626 601154 619411 619412 621034 623599 628167 636658 642793 653415 706373 706610 720306 740804 768164 771807 771823 771936 774690 776911 785024 786454 807641 817300 818148 818335 820741 820780 823515 823636 ] |
||||||||||||||||||||||||||||||
|
14.31 ms (3.28%) |
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 163762 382018 21323 391186 397867 399738 440646 439174 475448 495666 531222 539524 496441 551994 580266 558429 579347 546219 706373 720306 545484 557814 557823 566488 590934 585388 599820 600539 619412 623599 636658 774690 807641 771823 771807 776911 785024 464676 388718 404278 401816 475938 519291 535110 559162 420218 515749 823636 409878 818335 551005 384268 556363 559852 565993 566605 541175 768164 391208 410724 512205 512215 565468 552043 619411 496107 518949 471628 621034 463748 586590 598289 411182 385105 411009 820741 817300 823515 516816 551953 552927 559881 554788 572734 562849 591836 600626 601154 706610 465536 818148 535617 31708 396780 430468 415554 428728 415847 428801 477407 565986 545532 556428 653415 595785 786454 771936 740804 482330 450399 525197 469536 556397 559886 628167 326944 532109 642793 390569 820780 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf asian"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf азиатк"
]
|
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.