Query Metrics
7
Database Queries
7
Different statements
164.99 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.34 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.64 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"model wife"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.61 ms |
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 581566 645446 670372 553852 635716 595244 776531 780788 757078 813184 773924 616566 790469 406021 445790 487219 496512 505648 502519 428373 452745 457903 454478 450533 456837 500207 539991 519349 522782 525440 519531 477788 559222 562922 575300 567068 599520 617984 587211 599305 791034 621937 633485 779647 434782 446430 435550 440760 455646 488608 502935 514955 516859 716392 449246 516023 507628 521326 532102 466824 541241 556484 572198 586071 601981 608613 448498 453597 458773 471959 421991 451311 456839 473537 435078 456531 464136 477789 525398 591689 425966 465745 628175 626042 553411 524620 ] |
||||||||||||||||||||||||||||||
| 4 | 3.27 ms |
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 406021 421991 425966 428373 434782 435078 435550 440760 445790 446430 448498 449246 450533 451311 452745 453597 454478 455646 456531 456837 456839 457903 458773 464136 465745 466824 471959 473537 477788 477789 487219 488608 496512 500207 502519 502935 505648 507628 514955 516023 516859 519349 519531 521326 522782 524620 525398 525440 532102 539991 541241 553411 553852 556484 559222 562922 567068 572198 575300 581566 586071 587211 591689 595244 599305 599520 601981 608613 616566 617984 621937 626042 628175 633485 635716 645446 670372 716392 757078 773924 776531 779647 780788 790469 791034 813184 ] |
||||||||||||||||||||||||||||||
| 5 | 139.61 ms |
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 406021 421991 425966 428373 434782 435078 435550 440760 445790 446430 448498 449246 450533 451311 452745 453597 454478 455646 456531 456837 456839 457903 458773 464136 465745 466824 471959 473537 477788 477789 487219 488608 496512 500207 502519 502935 505648 507628 514955 516023 516859 519349 519531 521326 522782 524620 525398 525440 532102 539991 541241 553411 553852 556484 559222 562922 567068 572198 575300 581566 586071 587211 591689 595244 599305 599520 601981 608613 616566 617984 621937 626042 628175 633485 635716 645446 670372 716392 757078 773924 776531 779647 780788 790469 791034 813184 ] |
||||||||||||||||||||||||||||||
| 6 | 1.80 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"model жен"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.71 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"model жен"
]
|
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.