Query Metrics
7
Database Queries
7
Different statements
153.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.96 ms (84.71%) |
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 2571 11718 32678 46580 61536 388233 395664 396280 396547 404384 412756 415298 416128 419904 420621 422603 428786 429411 430444 433200 443990 445345 450702 451259 451867 456167 458100 463721 466652 475915 492124 497447 497670 499065 504729 506610 510365 511378 512174 512203 517855 522354 530017 536340 537113 539170 542207 542565 542579 543874 545602 546805 556030 556407 561960 565728 579389 586668 588619 593590 595480 595921 600535 601352 606210 620197 622403 624510 630729 633511 634193 634195 635991 637188 645595 647619 651010 651559 651611 658198 658920 658994 665762 675410 694487 699775 704156 709735 715177 721711 755377 761466 761467 761490 770424 771832 771961 772075 773441 776935 777902 780066 784973 793436 793628 800504 801273 806804 808325 810944 815270 815454 815674 816242 816935 818382 818442 821418 827971 ] |
||||||||||||||||||||||||||||||
|
12.76 ms (8.32%) |
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 451259 517855 412756 396547 415298 815454 715177 651010 556407 622403 593590 606210 777902 497447 579389 475915 433200 388233 537113 542565 810944 510365 645595 511378 634195 595480 800504 543874 522354 770424 429411 815674 699775 546805 512203 395664 61536 827971 512174 658920 545602 458100 456167 637188 771832 772075 801273 419904 492124 816242 651559 658198 595921 596803 630729 704156 530017 556030 634193 2571 588619 463721 46580 504729 773441 443990 647619 665762 755377 396280 536340 635991 784973 542579 11718 721711 404384 428786 818382 422603 815270 499065 651611 586668 761467 624510 420621 497670 506610 542207 761466 771961 416128 818442 776935 808325 761490 32678 445345 600535 816935 821418 466652 539170 565728 675410 694487 658994 709735 561960 601352 620197 633511 793436 780066 793628 451867 806804 430444 450702 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"глубокийминет минет оральн секс азиатк"
]
|
||||||||||||||||||||||||||||||
|
2.39 ms (1.56%) |
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 2571 11718 32678 46580 61536 388233 395664 396280 396547 404384 412756 415298 416128 419904 420621 422603 428786 429411 430444 433200 443990 445345 450702 451259 451867 456167 458100 463721 466652 475915 492124 497447 497670 499065 504729 506610 510365 511378 512174 512203 517855 522354 530017 536340 537113 539170 542207 542565 542579 543874 545602 546805 556030 556407 561960 565728 579389 586668 588619 593590 595480 595921 600535 601352 606210 620197 622403 624510 630729 633511 634193 634195 635991 637188 645595 647619 651010 651559 651611 658198 658920 658994 665762 675410 694487 699775 704156 709735 715177 721711 755377 761466 761467 761490 770424 771832 771961 772075 773441 776935 777902 780066 784973 793436 793628 800504 801273 806804 808325 810944 815270 815454 815674 816242 816935 818382 818442 821418 827971 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"deep throat asian"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"глубокийминет минет оральн секс азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.03%) |
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.