Query Metrics
7
Database Queries
7
Different statements
220.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
196.66 ms (89.06%) |
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 187843 315513 397916 400494 400844 400865 400995 401006 411327 421854 421863 421945 422158 422199 424432 424458 424475 428136 436742 437632 439585 439590 439612 439616 439639 439679 439739 439745 439754 439757 440988 441004 443775 443812 446240 451239 454217 463171 465346 465963 466014 466265 466877 467457 467518 467525 468906 470772 470791 471405 474627 474661 474680 476251 477389 481277 481925 482358 484406 484484 484632 484651 484654 484671 485696 486577 490438 496874 498491 500384 502749 502750 507785 510908 511534 512261 512988 513518 513525 514436 518835 519752 522498 522525 525955 533586 540801 540802 542724 542748 544494 545717 549639 552550 557569 557595 559579 561273 563007 563413 566196 569930 572347 574407 574410 588818 588860 589665 590481 591069 595875 596786 605359 620757 621335 621396 621489 621767 623413 811133 ] |
||||||||||||||||||||||||||||||
|
15.36 ms (6.95%) |
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 439754 474627 421863 465963 507785 620757 595875 484654 446240 514436 482358 533586 542724 549639 563413 574407 542748 544494 545717 566196 557569 559579 561273 588818 588860 590481 591069 400865 428136 443812 470772 400494 439639 440988 467457 471405 424432 439590 439739 466877 467518 397916 401006 421945 439679 439745 466265 470791 481925 443775 451239 500384 502749 513525 490438 512261 512988 525955 485696 519752 522498 540801 484484 486577 498491 484632 484406 605359 421854 436742 466014 424458 411327 474680 484651 522525 563007 621489 596786 441004 623413 481277 187843 315513 468906 511534 572347 569930 574410 552550 557595 589665 621767 621396 811133 621335 400995 422199 437632 476251 439585 454217 463171 400844 422158 439616 439757 467525 474661 477389 424475 439612 465346 518835 496874 502750 513518 540802 484671 510908 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.26%) |
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 187843 315513 397916 400494 400844 400865 400995 401006 411327 421854 421863 421945 422158 422199 424432 424458 424475 428136 436742 437632 439585 439590 439612 439616 439639 439679 439739 439745 439754 439757 440988 441004 443775 443812 446240 451239 454217 463171 465346 465963 466014 466265 466877 467457 467518 467525 468906 470772 470791 471405 474627 474661 474680 476251 477389 481277 481925 482358 484406 484484 484632 484651 484654 484671 485696 486577 490438 496874 498491 500384 502749 502750 507785 510908 511534 512261 512988 513518 513525 514436 518835 519752 522498 522525 525955 533586 540801 540802 542724 542748 544494 545717 549639 552550 557569 557595 559579 561273 563007 563413 566196 569930 572347 574407 574410 588818 588860 589665 590481 591069 595875 596786 605359 620757 621335 621396 621489 621767 623413 811133 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"rus young doggy"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.74%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск young рак"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.64%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.13 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск young рак"
]
|
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.