Query Metrics
7
Database Queries
7
Different statements
125.56 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.75 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.05 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck outdoor"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.72 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 646433 436865 452080 528882 580958 526428 509591 562269 475971 491380 467733 578389 443587 456182 484165 515555 500098 528416 455852 456607 486434 464956 501551 618239 624480 493288 552955 527602 596599 511066 476597 526134 577349 594879 401933 464301 562282 649912 506467 450851 545943 557042 417324 547717 572840 451943 458359 461668 566729 569156 584709 606798 452114 527936 424312 500931 445881 626139 607094 601990 507309 598046 436032 457793 458775 486086 484866 556001 548226 577350 469736 512339 499774 618806 637460 599534 614737 416886 537251 562368 562358 444356 591202 621449 601954 659328 562367 558472 528075 ] |
||||||||||||||||||||||||||||||
| 4 | 2.03 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 401933 416886 417324 424312 436032 436865 443587 444356 445881 450851 451943 452080 452114 455852 456182 456607 457793 458359 458775 461668 464301 464956 467733 469736 475971 476597 484165 484866 486086 486434 491380 493288 499774 500098 500931 501551 506467 507309 509591 511066 512339 515555 526134 526428 527602 527936 528075 528416 528882 537251 545943 547717 548226 552955 556001 557042 558472 562269 562282 562358 562367 562368 566729 569156 572840 577349 577350 578389 580958 584709 591202 594879 596599 598046 599534 601954 601990 606798 607094 614737 618239 618806 621449 624480 626139 637460 646433 649912 659328 ] |
||||||||||||||||||||||||||||||
| 5 | 101.55 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 401933 416886 417324 424312 436032 436865 443587 444356 445881 450851 451943 452080 452114 455852 456182 456607 457793 458359 458775 461668 464301 464956 467733 469736 475971 476597 484165 484866 486086 486434 491380 493288 499774 500098 500931 501551 506467 507309 509591 511066 512339 515555 526134 526428 527602 527936 528075 528416 528882 537251 545943 547717 548226 552955 556001 557042 558472 562269 562282 562358 562367 562368 566729 569156 572840 577349 577350 578389 580958 584709 591202 594879 596599 598046 599534 601954 601990 606798 607094 614737 618239 618806 621449 624480 626139 637460 646433 649912 659328 ] |
||||||||||||||||||||||||||||||
| 6 | 1.85 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс outdoor"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.61 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс outdoor"
]
|
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.