Query Metrics
7
Database Queries
7
Different statements
158.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.45 ms (81.93%) |
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 386218 387039 398041 401620 403879 410561 420190 421040 421234 424551 425520 425749 425809 426220 428309 428397 429386 437686 439682 442352 442678 442726 442735 443513 444003 445513 445971 448669 458523 459804 460743 460750 465335 465391 465394 466207 466273 466494 466603 467034 467626 468232 470483 474635 474680 474685 475892 476360 477974 478525 481339 484362 484461 484556 484601 484639 484739 486345 486355 486897 487206 487343 488246 489299 490262 492322 493127 496835 504787 508718 510254 510622 511816 512071 512215 512217 512516 513059 513660 514650 514820 520729 522768 524029 530500 531405 545944 549234 550615 552029 554132 554358 554425 554790 556834 557207 559124 559918 560507 561107 564595 572592 572653 575715 576720 578257 583640 584550 586623 595284 598154 600449 605467 618449 621087 624451 631972 646786 672954 730352 ] |
||||||||||||||||||||||||||||||
|
19.06 ms (12.07%) |
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 484362 484639 486345 443513 621087 583640 421040 513059 466603 426220 442678 510622 560507 572592 618449 484461 481339 584550 564595 575715 425749 504787 487206 468232 530500 513660 554132 572653 401620 437686 460743 474685 442735 512215 512217 672954 559918 600449 595284 439682 445513 508718 442352 514650 549234 730352 475892 466207 474635 478525 466494 477974 489299 484601 486355 496835 425809 476360 559124 470483 387039 424551 425520 512071 557207 511816 554358 561107 598154 467034 493127 420190 484739 531405 465391 467626 465335 460750 466273 512516 484556 490262 459804 605467 624451 492322 428309 429386 445971 631972 386218 578257 403879 410561 442726 524029 486897 522768 556834 646786 474680 487343 520729 458523 576720 514820 398041 545944 552029 554425 448669 554790 428397 421234 488246 444003 510254 550615 465394 586623 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.68%) |
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 386218 387039 398041 401620 403879 410561 420190 421040 421234 424551 425520 425749 425809 426220 428309 428397 429386 437686 439682 442352 442678 442726 442735 443513 444003 445513 445971 448669 458523 459804 460743 460750 465335 465391 465394 466207 466273 466494 466603 467034 467626 468232 470483 474635 474680 474685 475892 476360 477974 478525 481339 484362 484461 484556 484601 484639 484739 486345 486355 486897 487206 487343 488246 489299 490262 492322 493127 496835 504787 508718 510254 510622 511816 512071 512215 512217 512516 513059 513660 514650 514820 520729 522768 524029 530500 531405 545944 549234 550615 552029 554132 554358 554425 554790 556834 557207 559124 559918 560507 561107 564595 572592 572653 575715 576720 578257 583640 584550 586623 595284 598154 600449 605467 618449 621087 624451 631972 646786 672954 730352 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy girls"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая девушк"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая девушк"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.97%) |
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.