Query Metrics
7
Database Queries
7
Different statements
206.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.58 ms (86.15%) |
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 188242 233556 327786 385632 389639 389840 392597 392674 393102 396758 397908 397923 400807 403321 411324 411349 411376 411394 411419 419523 420478 428412 432596 439728 440601 440744 442377 443706 443758 443795 446059 454175 454187 454194 454508 454555 454561 457417 460887 460906 462305 462706 465386 465399 466025 466056 466085 466111 466199 466238 466348 467397 470201 470271 474635 475198 476274 476338 477712 477958 479052 479129 482386 484394 484413 484460 484638 484738 490267 502843 505855 507541 508800 509515 509995 511541 515726 516470 520154 526002 529246 546929 546936 563195 563640 577965 580640 582546 587846 599527 609592 613988 615667 617016 620240 620241 620265 620708 623385 666807 731305 734323 740530 741027 741080 758446 761147 781742 782261 782264 782270 782284 788543 788696 794678 794679 794698 820249 824807 824908 ] |
||||||||||||||||||||||||||||||
|
17.77 ms (8.62%) |
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 440601 397923 440744 442377 446059 587846 761147 580640 546929 411376 820249 824807 824908 613988 620708 788696 609592 782264 462305 505855 508800 476274 466199 484460 457417 439728 507541 563195 327786 470271 516470 397908 428412 466056 515726 465399 470201 443795 520154 490267 577965 617016 758446 731305 466025 466085 411324 563640 385632 474635 389639 741080 794679 454175 620265 419523 400807 420478 389840 454508 460887 466111 509515 454555 526002 529246 392674 620240 460906 466238 454194 484738 432596 443758 666807 615667 782270 782261 794678 734323 741027 740530 403321 781742 443706 477958 509995 484413 392597 479052 502843 623385 411419 188242 546936 467397 484394 465386 620241 782284 794698 477712 788543 233556 393102 482386 479129 411349 484638 511541 582546 599527 462706 476338 454187 454561 466348 411394 396758 475198 ] |
||||||||||||||||||||||||||||||
|
4.70 ms (2.28%) |
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 188242 233556 327786 385632 389639 389840 392597 392674 393102 396758 397908 397923 400807 403321 411324 411349 411376 411394 411419 419523 420478 428412 432596 439728 440601 440744 442377 443706 443758 443795 446059 454175 454187 454194 454508 454555 454561 457417 460887 460906 462305 462706 465386 465399 466025 466056 466085 466111 466199 466238 466348 467397 470201 470271 474635 475198 476274 476338 477712 477958 479052 479129 482386 484394 484413 484460 484638 484738 490267 502843 505855 507541 508800 509515 509995 511541 515726 516470 520154 526002 529246 546929 546936 563195 563640 577965 580640 582546 587846 599527 609592 613988 615667 617016 620240 620241 620265 620708 623385 666807 731305 734323 740530 741027 741080 758446 761147 781742 782261 782264 782270 782284 788543 788696 794678 794679 794698 820249 824807 824908 ] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian mature blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.71%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск mature минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск mature минет оральн секс"
]
|
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.