Query Metrics
7
Database Queries
7
Different statements
181.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.92 ms (83.13%) |
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 400491 406171 413649 416635 417674 420515 421298 421832 422171 422512 424648 425820 428301 428315 435794 436178 438018 442831 445416 447558 450977 451064 452014 454954 459656 464342 465524 465606 465883 466268 469023 469465 470064 472956 474066 478772 484644 484673 484692 486762 494006 499111 499182 499816 503617 505891 508133 508565 514408 514594 515128 515545 516073 516141 516296 516769 518256 520302 520425 521089 521469 522917 526553 528452 529792 530024 530763 531174 532942 532943 532963 533013 533944 536783 537789 541846 542216 543659 550430 556524 558337 560425 577966 584688 599865 599927 599987 601600 603240 606482 606762 615818 630546 631209 632601 632635 633787 634140 636284 637001 640813 642016 643376 644916 646175 646243 646776 649953 650785 658952 666538 676428 676634 679799 699397 751565 757906 802109 802121 817507 ] |
||||||||||||||||||||||||||||||
|
19.85 ms (10.93%) |
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 541846 601600 603240 514408 459656 633787 451064 520425 416635 516073 421832 530763 417674 558337 550430 817507 532942 442831 646243 650785 532943 454954 631209 435794 508133 465606 528452 699397 658952 400491 438018 679799 420515 516141 516296 542216 646776 802109 424648 532963 484644 499182 450977 757906 640813 421298 643376 465883 521469 526553 447558 445416 632601 484673 518256 464342 646175 802121 522917 530024 536783 505891 599987 560425 469023 428301 425820 469465 478772 520302 543659 577966 508565 484692 406171 751565 436178 644916 452014 599927 599865 486762 494006 422171 474066 649953 470064 466268 514594 676428 630546 634140 642016 428315 413649 422512 521089 531174 503617 533944 499111 666538 636284 632635 516769 606482 515545 465524 556524 529792 515128 676634 499816 533013 637001 584688 472956 606762 615818 537789 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.59%) |
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 400491 406171 413649 416635 417674 420515 421298 421832 422171 422512 424648 425820 428301 428315 435794 436178 438018 442831 445416 447558 450977 451064 452014 454954 459656 464342 465524 465606 465883 466268 469023 469465 470064 472956 474066 478772 484644 484673 484692 486762 494006 499111 499182 499816 503617 505891 508133 508565 514408 514594 515128 515545 516073 516141 516296 516769 518256 520302 520425 521089 521469 522917 526553 528452 529792 530024 530763 531174 532942 532943 532963 533013 533944 536783 537789 541846 542216 543659 550430 556524 558337 560425 577966 584688 599865 599927 599987 601600 603240 606482 606762 615818 630546 631209 632601 632635 633787 634140 636284 637001 640813 642016 643376 644916 646175 646243 646776 649953 650785 658952 666538 676428 676634 679799 699397 751565 757906 802109 802121 817507 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд девушк"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд девушк"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo girls"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.