Query Metrics
7
Database Queries
7
Different statements
203.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.36 ms (85.73%) |
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 145646 154535 304698 388312 391678 392597 393833 409936 413947 424179 425988 426316 427631 429839 431082 432563 437123 440992 451483 451970 455620 455885 456453 459022 459319 465058 465906 466904 467155 467240 468105 468912 469386 469565 475296 478225 482565 485174 486493 488603 489495 491362 492057 493159 493968 494247 494353 498876 499412 499467 499806 500059 500434 502737 504823 509261 513431 514016 514129 516924 519591 519668 520819 522159 522332 523280 523976 524254 525142 525298 527362 527928 528157 529516 530011 531524 532512 534017 546599 547880 548164 553290 558216 561359 567198 569138 579547 581882 582997 585539 585809 591004 592762 594522 600763 600777 600786 603792 604222 613932 613977 615146 620154 623132 626247 630288 639755 689338 691259 702246 705054 716946 734362 740175 747972 753251 756458 758026 770168 808668 ] |
||||||||||||||||||||||||||||||
|
18.63 ms (9.16%) |
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 585809 623132 734362 498876 478225 494353 519668 524254 469386 547880 459022 689338 489495 459319 504823 493159 388312 534017 758026 426316 469565 455620 488603 466904 465906 456453 468105 548164 639755 753251 770168 615146 702246 516924 558216 392597 523976 492057 630288 522159 500059 409936 740175 499412 523280 561359 546599 451483 482565 432563 531524 520819 304698 437123 494247 620154 391678 592762 513431 553290 600763 413947 530011 393833 145646 429839 467240 491362 440992 613977 468912 567198 600777 431082 525298 475296 514016 569138 585539 756458 486493 613932 581882 493968 528157 427631 502737 499806 522332 455885 527362 425988 509261 600786 154535 705054 747972 716946 467155 594522 525142 529516 519591 514129 500434 485174 465058 808668 591004 532512 499467 582997 626247 424179 451970 527928 579547 691259 604222 603792 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (1.58%) |
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 145646 154535 304698 388312 391678 392597 393833 409936 413947 424179 425988 426316 427631 429839 431082 432563 437123 440992 451483 451970 455620 455885 456453 459022 459319 465058 465906 466904 467155 467240 468105 468912 469386 469565 475296 478225 482565 485174 486493 488603 489495 491362 492057 493159 493968 494247 494353 498876 499412 499467 499806 500059 500434 502737 504823 509261 513431 514016 514129 516924 519591 519668 520819 522159 522332 523280 523976 524254 525142 525298 527362 527928 528157 529516 530011 531524 532512 534017 546599 547880 548164 553290 558216 561359 567198 569138 579547 581882 582997 585539 585809 591004 592762 594522 600763 600777 600786 603792 604222 613932 613977 615146 620154 623132 626247 630288 639755 689338 691259 702246 705054 716946 734362 740175 747972 753251 756458 758026 770168 808668 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big vagina stockings"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие вагин чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.74%) |
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.