Query Metrics
7
Database Queries
7
Different statements
152.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.79 ms (83.23%) |
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 330511 382074 384470 386532 387579 388523 388726 390947 391656 394785 396911 397232 398936 401333 401961 402526 407533 413128 414601 415937 417241 418533 426741 428843 431594 435747 437121 439487 443360 443677 443711 446820 447061 447145 450250 452787 457348 458117 458721 458727 459636 460707 460745 461970 462001 462586 462599 463334 465119 466272 466852 468277 468350 468364 469420 469617 469952 470785 471993 472016 477188 479122 480012 480254 482230 482443 483576 483725 485432 487286 488466 490142 493888 497509 501526 502784 504898 506178 508706 509219 509575 509821 514751 516977 518763 525655 527154 536416 541119 545179 545511 547577 559105 563993 564252 564703 566014 567214 573193 573757 577419 586376 589814 590426 591353 593676 599710 604616 613837 637203 647105 666966 671889 671896 678691 683565 813608 819366 824817 828001 ] |
||||||||||||||||||||||||||||||
|
14.74 ms (9.68%) |
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 819366 824817 828001 604616 396911 460745 466272 384470 435747 482443 469420 480254 490142 469617 485432 497509 518763 573757 573193 566014 683565 547577 599710 591353 462599 470785 401333 462586 477188 461970 443677 479122 482230 504898 509821 506178 509219 401961 402526 813608 460707 483576 536416 527154 462001 488466 671896 666966 678691 589814 330511 480012 388523 390947 431594 426741 437121 516977 483725 487286 386532 391656 394785 387579 397232 428843 415937 418533 417241 439487 447061 447145 458721 463334 465119 468350 469952 446820 458727 466852 468277 468364 509575 514751 501526 502784 541119 564703 545511 564252 577419 545179 559105 563993 647105 671889 567214 586376 613837 637203 590426 593676 382074 458117 472016 407533 443360 443711 471993 398936 459636 413128 457348 414601 493888 525655 508706 388726 450250 452787 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.85%) |
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 330511 382074 384470 386532 387579 388523 388726 390947 391656 394785 396911 397232 398936 401333 401961 402526 407533 413128 414601 415937 417241 418533 426741 428843 431594 435747 437121 439487 443360 443677 443711 446820 447061 447145 450250 452787 457348 458117 458721 458727 459636 460707 460745 461970 462001 462586 462599 463334 465119 466272 466852 468277 468350 468364 469420 469617 469952 470785 471993 472016 477188 479122 480012 480254 482230 482443 483576 483725 485432 487286 488466 490142 493888 497509 501526 502784 504898 506178 508706 509219 509575 509821 514751 516977 518763 525655 527154 536416 541119 545179 545511 547577 559105 563993 564252 564703 566014 567214 573193 573757 577419 586376 589814 590426 591353 593676 599710 604616 613837 637203 647105 666966 671889 671896 678691 683565 813608 819366 824817 828001 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин постел"
]
|
||||||||||||||||||||||||||||||
|
2.16 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother bed"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин постел"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.13%) |
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.