Query Metrics
8
Database Queries
8
Different statements
171.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.12 ms (85.35%) |
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 385577 386698 387364 400210 402419 425396 426393 429198 429514 431811 437093 451670 453613 454319 461672 465160 467133 478976 481180 504075 510315 510628 514625 524767 532354 533841 535490 539064 541123 545863 551029 552263 561809 563989 565816 568729 569878 570836 572630 574033 576583 577070 580133 588669 588944 595739 599219 606038 607182 617587 617796 620780 621442 632059 632153 641465 664318 665854 677340 679051 679354 679687 680030 688520 694732 697614 697834 705405 710292 710452 712175 733022 733091 739530 740313 740449 744877 744979 747401 747407 749067 756493 759791 761779 762225 762262 765234 766729 770818 772746 781509 785139 785961 786873 787560 788270 790042 790399 791279 792551 795072 795510 796873 797269 797863 798177 800697 802635 803024 803191 805643 806958 807050 808385 810763 811323 813291 815848 819903 ] |
||||||||||||||||||||||||||||||
|
13.51 ms (7.89%) |
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 632059 425396 461672 535490 533841 569878 580133 712175 680030 697834 595739 621442 590909 785961 795072 796873 797863 733022 733091 772746 740313 740449 747401 747407 617796 710292 514625 429514 815848 504075 539064 532354 478976 576583 677340 679051 694732 679354 568729 588944 599219 606038 795510 802635 786873 791279 797269 800697 761779 762225 765234 770818 803191 749067 744979 790042 805643 387364 524767 679687 386698 402419 465160 545863 577070 563989 697614 607182 632153 790399 811323 787560 759791 813291 467133 510628 453613 641465 561809 810763 762262 788270 429198 431811 385577 426393 819903 451670 454319 510315 541123 551029 552263 665854 688520 664318 705405 710452 565816 570836 572630 574033 588669 620780 785139 798177 781509 803024 806958 807050 739530 766729 744877 756493 617587 792551 808385 400210 437093 481180 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.65%) |
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 385577 386698 387364 400210 402419 425396 426393 429198 429514 431811 437093 451670 453613 454319 461672 465160 467133 478976 481180 504075 510315 510628 514625 524767 532354 533841 535490 539064 541123 545863 551029 552263 561809 563989 565816 568729 569878 570836 572630 574033 576583 577070 580133 588669 588944 595739 599219 606038 607182 617587 617796 620780 621442 632059 632153 641465 664318 665854 677340 679051 679354 679687 680030 688520 694732 697614 697834 705405 710292 710452 712175 733022 733091 739530 740313 740449 744877 744979 747401 747407 749067 756493 759791 761779 762225 762262 765234 766729 770818 772746 781509 785139 785961 786873 787560 788270 790042 790399 791279 792551 795072 795510 796873 797269 797863 798177 800697 802635 803024 803191 805643 806958 807050 808385 810763 811323 813291 815848 819903 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex game"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.09%) |
1 |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01”¶xЈq£§\x16Ò;x%\f"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс игр"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.88%) |
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.