Query Metrics
7
Database Queries
7
Different statements
151.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.33 ms (82.80%) |
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 188420 241603 386813 414339 419130 423368 425588 428116 431681 445836 446644 453415 458203 462466 462849 466233 467627 467957 474776 476128 480402 480406 480517 481910 486868 498092 505843 518479 521798 523640 530527 531656 534961 536346 538473 540457 554296 555573 556328 560008 561015 561021 562830 563050 563463 563834 564385 564561 565165 566354 569871 569941 570405 570429 570753 570852 577431 578492 581475 585281 587310 587689 589651 590190 590211 590241 592675 593146 598169 599565 600017 600302 600344 601536 601558 601653 601938 605919 606199 606587 606608 606749 607071 608373 616217 617186 618550 624849 638074 644244 646152 660359 660405 660416 662846 668645 669074 695870 702288 712130 724795 725036 725382 729262 737392 738694 751554 757308 770188 775848 785400 790574 793603 797385 801302 808055 809241 811667 819463 826163 ] |
||||||||||||||||||||||||||||||
|
16.61 ms (10.97%) |
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 188420 425588 570852 569871 590211 590190 624849 616217 797385 480402 638074 793603 505843 386813 498092 534961 561015 725036 446644 467627 481910 476128 445836 486868 662846 808055 423368 606199 770188 564385 589651 601938 480406 453415 570405 563050 566354 599565 725382 431681 523640 428116 538473 531656 775848 462466 606749 530527 785400 414339 241603 474776 564561 560008 660405 660359 569941 577431 578492 581475 601536 570429 712130 593146 809241 751554 585281 419130 462849 518479 554296 617186 570753 607071 644244 826163 819463 563463 587310 801302 811667 737392 729262 466233 458203 702288 587689 618550 790574 724795 738694 757308 608373 521798 556328 563834 467957 565165 646152 561021 480517 540457 536346 605919 601558 555573 562830 590241 606587 592675 598169 601653 606608 600302 600344 600017 668645 669074 695870 660416 ] |
||||||||||||||||||||||||||||||
|
2.47 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 188420 241603 386813 414339 419130 423368 425588 428116 431681 445836 446644 453415 458203 462466 462849 466233 467627 467957 474776 476128 480402 480406 480517 481910 486868 498092 505843 518479 521798 523640 530527 531656 534961 536346 538473 540457 554296 555573 556328 560008 561015 561021 562830 563050 563463 563834 564385 564561 565165 566354 569871 569941 570405 570429 570753 570852 577431 578492 581475 585281 587310 587689 589651 590190 590211 590241 592675 593146 598169 599565 600017 600302 600344 601536 601558 601653 601938 605919 606199 606587 606608 606749 607071 608373 616217 617186 618550 624849 638074 644244 646152 660359 660405 660416 662846 668645 669074 695870 702288 712130 724795 725036 725382 729262 737392 738694 751554 757308 770188 775848 785400 790574 793603 797385 801302 808055 809241 811667 819463 826163 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big butt mother"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие butt мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие butt мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.05%) |
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.