Query Metrics
7
Database Queries
7
Different statements
139.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
109.49 ms (78.67%) |
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 414946 430204 430621 430635 442332 442726 448034 451928 451929 451940 451951 451957 451974 451983 452014 452018 452034 452048 452053 452082 452084 452092 452093 452097 452109 452131 452519 464329 472237 486938 492322 492565 497452 497865 510443 510557 511733 512058 516029 518248 519318 522035 522191 522975 524324 524613 527000 529290 530478 530726 531481 532164 532499 533426 534288 534316 534334 537251 540441 541630 541632 541634 541638 541646 541647 541651 541656 541712 541721 541728 541740 541748 541749 541751 541773 541774 541780 542189 542192 542193 554568 555798 556415 560195 565277 583533 584481 584703 586594 586674 588283 606748 609783 621858 624502 628398 632565 633130 633158 633166 633176 640710 643113 650155 662020 696233 801907 ] |
||||||||||||||||||||||||||||||
|
19.19 ms (13.78%) |
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 696233 556415 624502 588283 586674 609783 632565 633130 633176 640710 448034 452093 464329 510443 511733 518248 541728 541749 430204 565277 541751 442726 442332 452092 452131 452519 472237 492322 534316 534334 540441 519318 532164 541712 555798 541634 541656 541773 560195 633158 633166 643113 527000 524613 492565 584481 414946 537251 662020 452018 452082 451983 452097 451929 451940 452053 534288 530726 541748 584703 583533 606748 628398 516029 541651 452109 510557 530478 452034 452048 451951 451974 522191 532499 554568 801907 524324 497865 486938 512058 586594 522035 452084 451957 452014 533426 541638 541780 541630 542193 541740 541774 650155 451928 430621 430635 531481 522975 529290 542189 542192 621858 497452 541632 541647 541721 541646 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (2.08%) |
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 414946 430204 430621 430635 442332 442726 448034 451928 451929 451940 451951 451957 451974 451983 452014 452018 452034 452048 452053 452082 452084 452092 452093 452097 452109 452131 452519 464329 472237 486938 492322 492565 497452 497865 510443 510557 511733 512058 516029 518248 519318 522035 522191 522975 524324 524613 527000 529290 530478 530726 531481 532164 532499 533426 534288 534316 534334 537251 540441 541630 541632 541634 541638 541646 541647 541651 541656 541712 541721 541728 541740 541748 541749 541751 541773 541774 541780 542189 542192 542193 554568 555798 556415 560195 565277 583533 584481 584703 586594 586674 588283 606748 609783 621858 624502 628398 632565 633130 633158 633166 633176 640710 643113 650155 662020 696233 801907 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.55%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"full татуированные"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"full tattoo"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"full татуированные"
]
|
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.