Query Metrics
7
Database Queries
7
Different statements
247.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
217.71 ms (88.09%) |
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 191485 382542 383751 384522 388365 388440 389360 392748 393188 394243 395258 395679 395707 398253 398984 400126 401673 402245 406992 408767 409346 416029 419731 425163 427498 428450 428988 428996 433808 435734 436427 440257 442656 443664 449436 456857 458149 458712 460183 460439 460863 461444 461445 461490 462620 464757 466060 467161 467303 468899 470522 470915 475622 476095 477964 482030 484104 486112 486846 487074 490365 491513 500843 501735 501776 504351 504715 506531 506714 507385 507827 507856 509498 511183 511428 511755 512921 513278 514448 516440 517276 520277 521936 522305 522513 522796 525214 526496 527366 528820 538196 541994 542434 544199 544395 551612 551752 553642 554478 556494 557027 559617 560627 560654 565570 568990 571830 571987 575092 576038 576366 576681 579879 583728 588962 589784 596978 598062 652969 690088 ] |
||||||||||||||||||||||||||||||
|
19.68 ms (7.96%) |
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 462620 467303 393188 409346 461444 466060 467161 468899 395707 398253 408767 449436 458149 461445 482030 428996 442656 476095 501735 486112 486846 514448 516440 522305 526496 506714 507856 520277 522796 484104 491513 507385 538196 384522 191485 394243 395258 382542 388365 398984 400126 433808 443664 458712 456857 470522 507827 509498 500843 490365 560627 544395 553642 554478 575092 576038 576366 583728 652969 690088 565570 571830 579879 598062 589784 588962 596978 383751 388440 428988 436427 440257 461490 477964 389360 401673 460183 460439 464757 470915 419731 425163 435734 460863 475622 487074 504351 513278 521936 527366 528820 504715 506531 511428 522513 525214 501776 511183 511755 512921 517276 392748 395679 402245 416029 427498 406992 428450 544199 557027 568990 571987 541994 559617 560654 542434 551752 576681 551612 556494 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.00%) |
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 191485 382542 383751 384522 388365 388440 389360 392748 393188 394243 395258 395679 395707 398253 398984 400126 401673 402245 406992 408767 409346 416029 419731 425163 427498 428450 428988 428996 433808 435734 436427 440257 442656 443664 449436 456857 458149 458712 460183 460439 460863 461444 461445 461490 462620 464757 466060 467161 467303 468899 470522 470915 475622 476095 477964 482030 484104 486112 486846 487074 490365 491513 500843 501735 501776 504351 504715 506531 506714 507385 507827 507856 509498 511183 511428 511755 512921 513278 514448 516440 517276 520277 521936 522305 522513 522796 525214 526496 527366 528820 538196 541994 542434 544199 544395 551612 551752 553642 554478 556494 557027 559617 560627 560654 565570 568990 571830 571987 575092 576038 576366 576681 579879 583728 588962 589784 596978 598062 652969 690088 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"парочка"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парочк"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"парочк"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.61%) |
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.