Query Metrics
7
Database Queries
7
Different statements
185.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.69 ms (86.61%) |
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 73204 181334 183036 291356 382084 382194 387082 395344 395365 398477 398508 398577 400328 411318 411930 418225 432518 433271 433304 435999 437285 439350 439434 441211 442508 443040 444078 445448 445818 447821 447906 451437 452563 453558 455518 456453 456522 456581 459547 470036 470968 472403 473113 474116 476455 477639 478213 483106 483482 488259 489323 493019 497679 499088 500069 501005 502499 503322 506023 507012 509540 509880 511955 512843 514873 515736 515759 518184 518379 520101 520936 522634 523056 541816 542385 553306 555018 555291 556690 562416 563164 563702 564565 565868 566701 567400 573273 579612 583644 599070 599609 602482 603417 604857 607045 609091 612169 617117 618082 619090 619191 620828 625440 627158 630359 672671 675142 712285 725650 733273 745252 747994 754771 764095 764273 785891 788100 792002 801653 ] |
||||||||||||||||||||||||||||||
|
14.80 ms (7.98%) |
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 456453 520936 566701 747994 725650 603417 73204 400328 398577 675142 712285 291356 387082 433271 456581 553306 398477 442508 472403 506023 520101 541816 617117 470968 470036 523056 445448 395365 411318 801653 604857 602482 477639 555291 443040 512843 444078 451437 474116 518379 563164 599070 459547 435999 445818 509540 501005 499088 447906 564565 437285 502499 609091 497679 476455 493019 433304 483482 489323 488259 183036 398508 455518 439350 620828 456522 483106 509880 418225 607045 382084 764095 764273 522634 518184 555018 563702 565868 630359 514873 672671 583644 599609 619191 507012 511955 500069 542385 382194 567400 619090 556690 515736 625440 573273 579612 411930 478213 453558 473113 503322 441211 562416 618082 612169 627158 788100 745252 771687 181334 515759 447821 792002 432518 785891 733273 754771 395344 439434 452563 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (1.70%) |
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 73204 181334 183036 291356 382084 382194 387082 395344 395365 398477 398508 398577 400328 411318 411930 418225 432518 433271 433304 435999 437285 439350 439434 441211 442508 443040 444078 445448 445818 447821 447906 451437 452563 453558 455518 456453 456522 456581 459547 470036 470968 472403 473113 474116 476455 477639 478213 483106 483482 488259 489323 493019 497679 499088 500069 501005 502499 503322 506023 507012 509540 509880 511955 512843 514873 515736 515759 518184 518379 520101 520936 522634 523056 541816 542385 553306 555018 555291 556690 562416 563164 563702 564565 565868 566701 567400 573273 579612 583644 599070 599609 602482 603417 604857 607045 609091 612169 617117 618082 619090 619191 620828 625440 627158 630359 672671 675142 712285 725650 733273 745252 747994 754771 764095 764273 785891 788100 792002 801653 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм в трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"кончать в трусы"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм в трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.80%) |
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.