Query Metrics
7
Database Queries
7
Different statements
181.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.43 ms (87.69%) |
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 290847 386858 395174 402207 417318 449829 450896 453502 455855 457972 458842 464310 464335 465967 466439 474034 474647 476330 478934 483283 489709 491157 493276 494418 495369 496540 498405 500122 500982 503565 505977 510508 513123 513261 513322 515722 516940 518577 521145 521334 521337 523122 526658 538837 539282 546568 546640 546884 548844 549249 552258 553003 554551 556398 557512 557892 558431 562291 563619 563906 564209 564488 564504 564929 565103 565119 568381 568719 569572 570545 571664 572918 573473 574047 575185 575302 576039 576266 580161 585321 586302 586584 588830 590352 591278 591313 592955 593387 594453 596741 596841 598062 598515 602509 603398 604844 605619 606109 607604 613117 615916 617649 618199 619836 623381 628110 629847 631481 632734 637737 638885 642409 663568 666603 667189 672311 705879 717628 788295 806086 ] |
||||||||||||||||||||||||||||||
|
12.97 ms (7.13%) |
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 549249 571664 574047 576039 580161 546884 548844 557892 568719 575302 546568 552258 553003 554551 556398 563619 563906 564488 564504 565103 565119 568381 569572 572918 575185 576266 663568 666603 667189 672311 705879 546640 557512 558431 562291 564209 564929 570545 573473 592955 594453 596741 598062 605619 606109 628110 642409 586584 588830 591278 602509 604844 617649 618199 632734 590352 591313 593387 596841 598515 603398 615916 637737 585321 586302 631481 788295 806086 607604 613117 619836 623381 629847 638885 717628 417318 464310 386858 474647 402207 453502 395174 449829 450896 500122 510508 526658 489709 495369 521334 493276 515722 483283 491157 494418 521337 290847 466439 455855 464335 478934 457972 458842 465967 474034 476330 498405 503565 505977 513322 521145 523122 496540 500982 513123 513261 516940 518577 538837 539282 ] |
||||||||||||||||||||||||||||||
|
3.43 ms (1.89%) |
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 290847 386858 395174 402207 417318 449829 450896 453502 455855 457972 458842 464310 464335 465967 466439 474034 474647 476330 478934 483283 489709 491157 493276 494418 495369 496540 498405 500122 500982 503565 505977 510508 513123 513261 513322 515722 516940 518577 521145 521334 521337 523122 526658 538837 539282 546568 546640 546884 548844 549249 552258 553003 554551 556398 557512 557892 558431 562291 563619 563906 564209 564488 564504 564929 565103 565119 568381 568719 569572 570545 571664 572918 573473 574047 575185 575302 576039 576266 580161 585321 586302 586584 588830 590352 591278 591313 592955 593387 594453 596741 596841 598062 598515 602509 603398 604844 605619 606109 607604 613117 615916 617649 618199 619836 623381 628110 629847 631481 632734 637737 638885 642409 663568 666603 667189 672311 705879 717628 788295 806086 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"кара"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кар"
]
|
||||||||||||||||||||||||||||||
|
1.20 ms (0.66%) |
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.