Query Metrics
7
Database Queries
7
Different statements
176.13 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.86 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.73 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"хуй в сиськах"
]
|
||||||||||||||||||||||||||||||
| 3 | 17.14 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 511069 460644 715844 457255 488926 482806 459634 443187 525064 428772 466333 516161 544704 428804 453463 461443 507840 520573 455967 453072 485361 499744 385466 454246 498416 754941 512657 415590 429592 482895 489250 496389 517115 520347 535979 488154 467404 524572 506749 415436 457563 475849 575675 591859 448236 453261 497025 587998 463079 495905 526370 388973 397625 420257 458110 468053 569783 481211 488728 514741 454992 509279 544683 388027 459888 546114 484931 383621 595507 444394 495062 542778 486864 505012 500699 600531 407890 485371 529144 460479 565557 458827 527426 515076 509867 479668 650632 516263 622041 545015 661256 558524 606002 412639 450241 496559 522493 474682 490183 550079 408831 468077 536274 461157 665264 456720 480531 508414 464401 907 542525 426701 439194 480161 524976 617656 514760 596424 384541 507708 ] |
||||||||||||||||||||||||||||||
| 4 | 3.37 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 907 383621 384541 385466 388027 388973 397625 407890 408831 412639 415436 415590 420257 426701 428772 428804 429592 439194 443187 444394 448236 450241 453072 453261 453463 454246 454992 455967 456720 457255 457563 458110 458827 459634 459888 460479 460644 461157 461443 463079 464401 466333 467404 468053 468077 474682 475849 479668 480161 480531 481211 482806 482895 484931 485361 485371 486864 488154 488728 488926 489250 490183 495062 495905 496389 496559 497025 498416 499744 500699 505012 506749 507708 507840 508414 509279 509867 511069 512657 514741 514760 515076 516161 516263 517115 520347 520573 522493 524572 524976 525064 526370 527426 529144 535979 536274 542525 542778 544683 544704 545015 546114 550079 558524 565557 569783 575675 587998 591859 595507 596424 600531 606002 617656 622041 650632 661256 665264 715844 754941 ] |
||||||||||||||||||||||||||||||
| 5 | 148.66 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 907 383621 384541 385466 388027 388973 397625 407890 408831 412639 415436 415590 420257 426701 428772 428804 429592 439194 443187 444394 448236 450241 453072 453261 453463 454246 454992 455967 456720 457255 457563 458110 458827 459634 459888 460479 460644 461157 461443 463079 464401 466333 467404 468053 468077 474682 475849 479668 480161 480531 481211 482806 482895 484931 485361 485371 486864 488154 488728 488926 489250 490183 495062 495905 496389 496559 497025 498416 499744 500699 505012 506749 507708 507840 508414 509279 509867 511069 512657 514741 514760 515076 516161 516263 517115 520347 520573 522493 524572 524976 525064 526370 527426 529144 535979 536274 542525 542778 544683 544704 545015 546114 550079 558524 565557 569783 575675 587998 591859 595507 596424 600531 606002 617656 622041 650632 661256 665264 715844 754941 ] |
||||||||||||||||||||||||||||||
| 6 | 1.78 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"член в сиськ"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.58 ms |
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.