Query Metrics
7
Database Queries
7
Different statements
147.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.28 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 193666 271496 387121 390954 400850 411401 421147 421819 425131 427335 428059 428089 429049 429542 430219 433609 434608 438031 441910 442426 443227 443328 443415 444773 445324 450213 454040 454498 454518 455677 457253 457868 458841 462291 465793 466129 466258 470427 470931 471437 472020 477224 477357 480381 482450 487020 487260 489062 490899 493145 495442 496279 496504 500844 501459 504682 505258 506209 507499 508586 508784 511023 512913 516241 518978 519491 521008 529504 541688 543988 552338 556634 568171 569278 573755 588942 593037 604644 607275 611307 617423 629849 637543 670005 670935 682107 695373 702306 705549 719746 720003 723021 724289 728502 731670 732670 732708 737037 742254 742685 744172 758319 773454 778127 778143 778292 778369 788469 788674 791112 791710 796110 796549 801463 801868 802313 803595 805714 807404 808447 ] |
||||||||||||||||||||||||||||||
|
13.74 ms (9.30%) |
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 487020 487260 443415 429542 472020 670005 801463 758319 805714 737037 731670 702306 723021 778143 791710 637543 791112 742254 732670 796549 569278 604644 433609 511023 455677 496279 796110 428089 500844 493145 400850 518978 271496 482450 470427 521008 552338 808447 430219 427335 504682 508586 529504 506209 507499 519491 705549 720003 573755 411401 470931 607275 454518 477224 489062 387121 434608 543988 556634 695373 568171 788674 778292 744172 732708 778127 450213 801868 778369 773454 728502 719746 442426 443227 444773 454040 803595 466258 495442 490899 193666 465793 445324 477357 516241 390954 541688 458841 588942 802313 724289 421819 443328 505258 425131 682107 629849 421147 617423 441910 611307 466129 457868 457253 788469 428059 454498 480381 670935 593037 807404 742685 438031 501459 508784 496504 512913 462291 429049 471437 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.65%) |
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 193666 271496 387121 390954 400850 411401 421147 421819 425131 427335 428059 428089 429049 429542 430219 433609 434608 438031 441910 442426 443227 443328 443415 444773 445324 450213 454040 454498 454518 455677 457253 457868 458841 462291 465793 466129 466258 470427 470931 471437 472020 477224 477357 480381 482450 487020 487260 489062 490899 493145 495442 496279 496504 500844 501459 504682 505258 506209 507499 508586 508784 511023 512913 516241 518978 519491 521008 529504 541688 543988 552338 556634 568171 569278 573755 588942 593037 604644 607275 611307 617423 629849 637543 670005 670935 682107 695373 702306 705549 719746 720003 723021 724289 728502 731670 732670 732708 737037 742254 742685 744172 758319 773454 778127 778143 778292 778369 788469 788674 791112 791710 796110 796549 801463 801868 802313 803595 805714 807404 808447 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.57%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс мам женщин друг"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс мам женщин друг"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.39%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.