Query Metrics
7
Database Queries
7
Different statements
201.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.90 ms (85.28%) |
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 394297 398881 412627 420157 423809 426252 427149 428684 429549 437325 437343 437985 438446 438634 440685 440917 440928 441415 441933 444331 445864 445866 445989 447821 448109 453976 454394 454536 454873 455995 456624 457600 459043 463612 465878 472258 472624 473065 473424 475014 479752 488331 490660 492355 494901 499198 500197 506755 507340 511847 513060 516900 517678 517707 521507 522320 523607 524369 535763 537264 539006 542385 542514 544980 551787 552062 554408 554707 554998 555358 555784 556096 556155 558103 558160 558827 560684 565755 565756 566236 567604 570957 571801 571802 572220 574768 577445 583131 584120 585050 588186 588461 589677 593230 596637 602255 604646 605074 609077 617686 618141 619327 620059 621880 628193 628199 629673 629976 631569 634345 635587 636374 644192 654599 661000 689147 742923 766487 797144 814280 ] |
||||||||||||||||||||||||||||||
|
20.89 ms (10.37%) |
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 604646 635587 516900 634345 475014 445866 447821 423809 609077 628193 555784 554998 631569 605074 574768 420157 453976 523607 454536 488331 437343 454394 584120 440928 427149 441933 441415 448109 412627 689147 654599 428684 472624 429549 537264 544980 558103 542514 445864 628199 440917 426252 472258 463612 539006 499198 494901 513060 535763 552062 565756 572220 551787 560684 571802 554408 555358 556155 570957 571801 583131 588186 588461 593230 619327 621880 620059 596637 629673 602255 617686 438446 437325 440685 454873 506755 511847 444331 500197 814280 554707 661000 742923 766487 394297 517678 438634 473065 490660 524369 507340 517707 556096 589677 636374 629976 459043 437985 456624 492355 565755 797144 585050 558160 567604 445989 457600 558827 644192 455995 577445 618141 465878 479752 398881 473424 521507 542385 566236 522320 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.23%) |
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 394297 398881 412627 420157 423809 426252 427149 428684 429549 437325 437343 437985 438446 438634 440685 440917 440928 441415 441933 444331 445864 445866 445989 447821 448109 453976 454394 454536 454873 455995 456624 457600 459043 463612 465878 472258 472624 473065 473424 475014 479752 488331 490660 492355 494901 499198 500197 506755 507340 511847 513060 516900 517678 517707 521507 522320 523607 524369 535763 537264 539006 542385 542514 544980 551787 552062 554408 554707 554998 555358 555784 556096 556155 558103 558160 558827 560684 565755 565756 566236 567604 570957 571801 571802 572220 574768 577445 583131 584120 585050 588186 588461 589677 593230 596637 602255 604646 605074 609077 617686 618141 619327 620059 621880 628193 628199 629673 629976 631569 634345 635587 636374 644192 654599 661000 689147 742923 766487 797144 814280 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"снима трусик нижн бел жен"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"Ðüð¢ð©ð╝ð░ðÁÐé ÐéÐÇÐâÐüð©ð║ð© Ðâ ðÂðÁð¢ÔÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.69%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.