Query Metrics
7
Database Queries
7
Different statements
209.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.48 ms (85.51%) |
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 114557 387326 388762 390653 390888 396330 397361 407208 412362 414126 420886 426065 428090 430477 430835 431365 433686 437013 441943 445841 449859 453599 453694 453992 454302 456292 456750 456883 458610 460576 466494 467957 468939 469061 469195 469475 471809 475235 475658 476269 476593 477989 478092 478564 481554 482539 483189 484506 484664 487517 490411 491988 493299 494290 496599 497675 498857 500089 501701 502341 502861 505390 505973 506350 517008 518585 519748 519929 522447 522458 522919 525524 526523 527656 528232 528614 529366 531510 532101 535010 541167 541550 542925 543592 544523 545489 546744 551577 552356 552945 555433 558230 561313 563625 563820 565011 565861 565863 568596 569487 573338 577966 578545 593376 599953 603424 606617 614097 645898 681093 681129 759865 777813 791961 793620 803760 805564 805687 807477 808701 ] |
||||||||||||||||||||||||||||||
|
19.55 ms (9.31%) |
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 387326 441943 437013 453694 456883 469195 478092 453992 484506 445841 476593 478564 565863 545489 558230 561313 542925 544523 565861 552356 552945 563820 565011 593376 805687 456750 475235 428090 433686 458610 114557 454302 456292 481554 453599 502341 527656 528232 494290 522458 541550 493299 496599 498857 501701 502861 505973 522447 645898 532101 397361 430477 407208 467957 475658 449859 469475 487517 518585 529366 471809 482539 546744 573338 543592 614097 599953 759865 603424 390888 396330 476269 412362 469061 414126 426065 466494 420886 430835 431365 519929 522919 526523 483189 506350 484664 490411 491988 497675 525524 535010 505390 519748 531510 577966 551577 390653 388762 477989 568596 517008 468939 460576 500089 528614 569487 541167 555433 578545 681129 681093 563625 606617 777813 791961 793620 803760 805564 807477 808701 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (1.47%) |
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 114557 387326 388762 390653 390888 396330 397361 407208 412362 414126 420886 426065 428090 430477 430835 431365 433686 437013 441943 445841 449859 453599 453694 453992 454302 456292 456750 456883 458610 460576 466494 467957 468939 469061 469195 469475 471809 475235 475658 476269 476593 477989 478092 478564 481554 482539 483189 484506 484664 487517 490411 491988 493299 494290 496599 497675 498857 500089 501701 502341 502861 505390 505973 506350 517008 518585 519748 519929 522447 522458 522919 525524 526523 527656 528232 528614 529366 531510 532101 535010 541167 541550 542925 543592 544523 545489 546744 551577 552356 552945 555433 558230 561313 563625 563820 565011 565861 565863 568596 569487 573338 577966 578545 593376 599953 603424 606617 614097 645898 681093 681129 759865 777813 791961 793620 803760 805564 805687 807477 808701 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"порно мама с подругой"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"порн мам женщин подружк"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.70%) |
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.