Query Metrics
7
Database Queries
7
Different statements
368.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
343.88 ms (93.36%) |
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 383902 385334 405128 415307 418868 425018 432786 433644 440265 443645 451591 452400 453539 454537 454661 454706 455835 456557 456816 458243 459192 474272 475065 476564 479517 484075 484401 485560 486978 487862 488844 488920 491372 491376 492010 492396 493933 494394 494938 496711 497625 499184 501408 502210 503792 505858 508645 509005 510126 511065 518586 518826 522266 525638 525950 527021 528911 528913 531547 532375 534862 537290 544064 544313 545365 547427 548316 551183 554647 559087 562285 562618 563333 564860 565088 565361 565377 566695 568168 569169 569793 572566 574421 577376 577957 581120 585447 587385 588813 594505 599788 603387 606321 608363 624329 626911 631185 633155 643728 650275 659297 667555 673424 680900 681530 690410 691899 698341 701609 712964 717676 718740 741649 778400 787532 789846 793622 811510 815041 825595 ] |
||||||||||||||||||||||||||||||
|
14.33 ms (3.89%) |
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 418868 793622 491376 486978 532375 497625 488920 778400 569169 603387 425018 527021 508645 574421 455835 681530 624329 815041 454661 459192 562618 525950 787532 562285 503792 691899 545365 488844 452400 789846 505858 667555 701609 673424 551183 599788 385334 741649 456557 572566 698341 680900 588813 499184 476564 534862 564860 690410 518586 631185 415307 494394 528911 502210 565088 491372 493933 433644 511065 451591 405128 626911 581120 608363 825595 811510 501408 496711 525638 383902 650275 484075 453539 454537 717676 587385 566695 492010 718740 585447 522266 537290 458243 547427 544064 563333 577376 577957 594505 484401 659297 454706 509005 544313 518826 548316 440265 443645 510126 559087 606321 494938 456816 487862 528913 565361 565377 479517 432786 475065 554647 712964 633155 568168 569793 485560 492396 531547 643728 474272 ] |
||||||||||||||||||||||||||||||
|
3.34 ms (0.91%) |
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 383902 385334 405128 415307 418868 425018 432786 433644 440265 443645 451591 452400 453539 454537 454661 454706 455835 456557 456816 458243 459192 474272 475065 476564 479517 484075 484401 485560 486978 487862 488844 488920 491372 491376 492010 492396 493933 494394 494938 496711 497625 499184 501408 502210 503792 505858 508645 509005 510126 511065 518586 518826 522266 525638 525950 527021 528911 528913 531547 532375 534862 537290 544064 544313 545365 547427 548316 551183 554647 559087 562285 562618 563333 564860 565088 565361 565377 566695 568168 569169 569793 572566 574421 577376 577957 581120 585447 587385 588813 594505 599788 603387 606321 608363 624329 626911 631185 633155 643728 650275 659297 667555 673424 680900 681530 690410 691899 698341 701609 712964 717676 718740 741649 778400 787532 789846 793622 811510 815041 825595 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex public"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.41%) |
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.