Query Metrics
7
Database Queries
7
Different statements
141.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.40 ms (84.87%) |
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 31218 396799 398399 412910 418068 433721 446003 448300 453417 453757 456891 458121 468515 471650 472514 472853 475277 477069 482223 489766 490162 490475 491673 491842 497473 498593 512961 521755 526838 531004 532718 532722 545783 548164 550166 557071 557466 580438 583471 593738 608398 616535 623643 626016 626795 629593 635020 636562 648777 667169 678162 678173 678182 678201 679471 682277 701611 701628 707719 710805 710942 710956 711568 711570 716657 717202 718314 724152 724160 724167 725004 725630 726705 727774 729966 730069 730088 733364 738088 744091 744370 748816 749392 752221 752247 752252 752255 752315 752403 752405 752448 752895 756212 756431 758315 761505 761546 776390 778834 779083 784275 793454 793744 797228 798357 799438 801510 802700 803352 806251 807923 810115 811880 813112 818576 819171 819725 825073 825075 825275 ] |
||||||||||||||||||||||||||||||
|
11.90 ms (8.39%) |
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 813112 724167 752315 752895 398399 716657 793454 730088 724152 761546 818576 548164 667169 711570 701611 799438 725004 730069 724160 717202 778834 797228 531004 701628 635020 608398 811880 793744 806251 718314 779083 490162 682277 629593 744091 727774 758315 761505 472514 489766 825075 472853 752405 678173 756431 491673 396799 550166 798357 31218 810115 498593 490475 583471 557071 679471 710956 648777 678182 710805 636562 725630 726705 748816 412910 471650 776390 752252 710942 512961 448300 491842 807923 453757 825073 825275 446003 477069 453417 475277 711568 678201 593738 626795 784275 733364 819171 557466 707719 801510 752221 752255 729966 752247 752403 526838 744370 418068 623643 626016 456891 819725 678162 458121 532718 532722 616535 803352 802700 749392 738088 752448 433721 521755 545783 756212 482223 497473 468515 580438 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (2.12%) |
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 31218 396799 398399 412910 418068 433721 446003 448300 453417 453757 456891 458121 468515 471650 472514 472853 475277 477069 482223 489766 490162 490475 491673 491842 497473 498593 512961 521755 526838 531004 532718 532722 545783 548164 550166 557071 557466 580438 583471 593738 608398 616535 623643 626016 626795 629593 635020 636562 648777 667169 678162 678173 678182 678201 679471 682277 701611 701628 707719 710805 710942 710956 711568 711570 716657 717202 718314 724152 724160 724167 725004 725630 726705 727774 729966 730069 730088 733364 738088 744091 744370 748816 749392 752221 752247 752252 752255 752315 752403 752405 752448 752895 756212 756431 758315 761505 761546 776390 778834 779083 784275 793454 793744 797228 798357 799438 801510 802700 803352 806251 807923 810115 811880 813112 818576 819171 819725 825073 825075 825275 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"compilation latina"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"подборк латинская"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"подборк латинская"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.98%) |
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.