Query Metrics
7
Database Queries
7
Different statements
154.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.74 ms (80.60%) |
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 390382 400808 407566 421827 421850 421878 421879 421900 422155 422189 422195 422203 422208 426765 426766 426987 426991 426994 428533 430313 439457 439544 439564 439565 439616 439677 439680 439726 439731 439767 440548 440614 444703 447163 452977 454141 455206 455337 457465 461018 463215 463614 466133 468941 469030 470774 471046 474784 474785 474800 475266 477890 479040 485172 485276 485462 489330 489379 489382 489979 493167 493173 494315 494329 495224 497104 498491 500797 502814 502816 509042 512541 514110 516484 518155 518834 518852 518858 518965 520253 520861 520878 521127 521130 521134 521359 521758 521763 521796 523830 523833 523840 523846 523901 524109 526450 526454 526455 526512 526515 526520 526524 526729 528343 528708 529143 532095 535109 539739 539744 549742 549829 559173 560396 563450 575241 598225 621724 630475 646199 ] |
||||||||||||||||||||||||||||||
|
20.79 ms (13.44%) |
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 524109 485172 498491 518834 521130 523833 523846 526450 528708 421827 526520 526455 521127 466133 521763 521796 439726 407566 430313 447163 474785 521359 539744 502816 512541 518965 520253 526729 497104 532095 520878 489330 549742 560396 559173 646199 549829 621724 421850 426765 426766 452977 457465 475266 440614 444703 474800 400808 439457 439616 439677 439731 421878 421900 422189 454141 455337 479040 509042 514110 489379 495224 502814 521758 523830 489382 493167 493173 494315 500797 520861 523840 526524 494329 521134 526454 528343 575241 439544 523901 428533 485462 489979 526515 539739 529143 563450 598225 630475 390382 422195 439564 421879 426987 426994 439680 440548 469030 422155 422203 422208 463614 468941 471046 516484 526512 485276 518852 463215 439767 518155 455206 461018 477890 518858 535109 470774 474784 426991 439565 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.63%) |
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 390382 400808 407566 421827 421850 421878 421879 421900 422155 422189 422195 422203 422208 426765 426766 426987 426991 426994 428533 430313 439457 439544 439564 439565 439616 439677 439680 439726 439731 439767 440548 440614 444703 447163 452977 454141 455206 455337 457465 461018 463215 463614 466133 468941 469030 470774 471046 474784 474785 474800 475266 477890 479040 485172 485276 485462 489330 489379 489382 489979 493167 493173 494315 494329 495224 497104 498491 500797 502814 502816 509042 512541 514110 516484 518155 518834 518852 518858 518965 520253 520861 520878 521127 521130 521134 521359 521758 521763 521796 523830 523833 523840 523846 523901 524109 526450 526454 526455 526512 526515 526520 526524 526729 528343 528708 529143 532095 535109 539739 539744 549742 549829 559173 560396 563450 575241 598225 621724 630475 646199 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom son natural"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom son натуральная натуральные"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom son натуральная натуральные"
]
|
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.