Query Metrics
7
Database Queries
7
Different statements
200.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.22 ms (86.28%) |
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 395144 421236 434097 437663 438219 439765 444612 446815 452146 453441 454228 462949 465498 467066 467837 469477 470568 472078 474113 474433 474461 474538 475240 475280 476706 480296 480707 481965 482539 482620 483350 484379 487260 490474 490783 493896 496057 496311 496518 496874 498594 502249 503859 508515 509430 510456 512955 513828 514575 517687 519316 519825 520340 521203 521350 524327 528452 532545 533320 533388 533998 541162 541831 541887 541897 542885 545857 547543 548169 549311 549391 549968 554826 555317 556786 557475 557499 562147 564816 565571 566075 566704 568383 569196 570797 572551 572603 576519 579622 587998 590730 592477 593185 593596 601438 614829 622385 625783 629571 630890 635839 674206 697459 715509 716167 716765 724126 724740 731124 732163 759132 759691 776940 797142 801292 805139 805149 813249 814849 816958 ] |
||||||||||||||||||||||||||||||
|
16.32 ms (8.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 487260 814849 480296 533998 697459 801292 776940 438219 474433 474113 484379 476706 446815 469477 532545 545857 579622 542885 674206 601438 724740 732163 715509 593596 395144 496518 508515 513828 816958 475240 481965 521203 533320 474538 541897 555317 549391 568383 549311 805149 813249 434097 467837 490474 462949 444612 453441 483350 512955 519316 519825 514575 541887 716765 590730 759691 454228 509430 496057 490783 587998 533388 521350 496311 541162 547543 572603 569196 557475 566704 548169 570797 635839 630890 797142 731124 759132 724126 614829 472078 554826 467066 482620 474461 482539 805139 593185 480707 528452 502249 541831 421236 452146 470568 465498 503859 520340 524327 565571 566075 549968 564816 716167 556786 572551 576519 629571 622385 592477 510456 498594 437663 517687 557499 562147 625783 493896 439765 496874 475280 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (1.42%) |
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 395144 421236 434097 437663 438219 439765 444612 446815 452146 453441 454228 462949 465498 467066 467837 469477 470568 472078 474113 474433 474461 474538 475240 475280 476706 480296 480707 481965 482539 482620 483350 484379 487260 490474 490783 493896 496057 496311 496518 496874 498594 502249 503859 508515 509430 510456 512955 513828 514575 517687 519316 519825 520340 521203 521350 524327 528452 532545 533320 533388 533998 541162 541831 541887 541897 542885 545857 547543 548169 549311 549391 549968 554826 555317 556786 557475 557499 562147 564816 565571 566075 566704 568383 569196 570797 572551 572603 576519 579622 587998 590730 592477 593185 593596 601438 614829 622385 625783 629571 630890 635839 674206 697459 715509 716167 716765 724126 724740 731124 732163 759132 759691 776940 797142 801292 805139 805149 813249 814849 816958 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"нарезка--в--туалете--женщин--"
]
|
||||||||||||||||||||||||||||||
|
2.21 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"подборк туалет женщин"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.80%) |
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.