Query Metrics
7
Database Queries
7
Different statements
160.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.71 ms (83.47%) |
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 32620 383117 386648 392558 401296 420635 437843 442523 446545 447031 454221 457750 459116 460774 463074 463203 463511 466506 466751 467163 475223 482570 486267 488812 496693 497057 498183 500071 506978 511554 512052 513565 515107 515865 516310 517269 517290 517857 521504 522760 522972 523043 526384 527135 528723 533079 535655 537619 540350 543604 544593 549584 551660 557164 559154 559226 567218 571488 572321 573810 574450 577620 578467 586734 588121 589013 591246 594830 599514 599903 600878 601956 603154 603765 603964 604873 608549 609202 611820 612698 615703 616604 622229 623421 652872 656562 664499 676757 688007 708233 713353 713833 715453 716987 718492 718615 723819 729160 730356 732380 734560 736252 747104 747601 748246 748893 756652 759609 764135 765754 769196 782405 785008 809698 817936 818305 819193 820339 827946 827981 ] |
||||||||||||||||||||||||||||||
|
17.15 ms (10.71%) |
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 577620 603154 589013 457750 515865 511554 523043 475223 459116 466751 460774 498183 446545 517857 818305 517269 463074 572321 600878 482570 467163 567218 466506 442523 500071 513565 497057 574450 586734 522760 516310 827946 437843 515107 557164 447031 488812 463511 559154 549584 522972 527135 535655 521504 573810 392558 817936 544593 656562 765754 526384 543604 688007 533079 540350 769196 756652 747104 718615 591246 764135 730356 32620 383117 454221 528723 599514 608549 827981 571488 708233 604873 664499 785008 718492 723819 736252 517290 537619 748893 588121 622229 420635 612698 713833 616604 734560 512052 578467 601956 611820 623421 603964 615703 594830 603765 820339 551660 713353 599903 716987 506978 609202 809698 463203 486267 401296 559226 676757 732380 729160 819193 748246 652872 386648 496693 747601 715453 782405 759609 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.75%) |
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 32620 383117 386648 392558 401296 420635 437843 442523 446545 447031 454221 457750 459116 460774 463074 463203 463511 466506 466751 467163 475223 482570 486267 488812 496693 497057 498183 500071 506978 511554 512052 513565 515107 515865 516310 517269 517290 517857 521504 522760 522972 523043 526384 527135 528723 533079 535655 537619 540350 543604 544593 549584 551660 557164 559154 559226 567218 571488 572321 573810 574450 577620 578467 586734 588121 589013 591246 594830 599514 599903 600878 601956 603154 603765 603964 604873 608549 609202 611820 612698 615703 616604 622229 623421 652872 656562 664499 676757 688007 708233 713353 713833 715453 716987 718492 718615 723819 729160 730356 732380 734560 736252 747104 747601 748246 748893 756652 759609 764135 765754 769196 782405 785008 809698 817936 818305 819193 820339 827946 827981 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"have sex"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"have секс"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"have секс"
]
|
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.