Query Metrics
7
Database Queries
7
Different statements
168.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.29 ms (81.89%) |
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 2571 214988 382649 388522 389243 396265 396278 397809 398614 403635 405203 405990 406134 410132 412122 415950 416191 419910 419950 420206 420910 422561 422592 422705 422847 422997 423009 423021 423023 423270 425027 428479 429068 429583 433152 435629 435727 438765 443215 443216 443617 445081 445473 445879 446266 452221 452434 452441 452444 453019 453331 456627 456633 456634 457498 458094 458384 458429 459233 459237 459264 459316 469536 469550 477216 477404 478955 482621 485577 485578 488379 492573 492732 492805 497467 497715 498620 499035 499040 499212 501865 504722 507670 508962 510043 510622 511249 511260 511264 511271 512181 512192 522123 525099 526789 527110 527117 533499 533660 535626 537732 537932 539867 539899 540452 542648 551086 560216 560578 571824 592673 634422 720040 720829 737321 815764 819082 819390 820340 823245 ] |
||||||||||||||||||||||||||||||
|
19.64 ms (11.63%) |
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 469536 445879 446266 456633 560578 422705 410132 420206 456627 507670 443215 429068 497715 737321 2571 396265 397809 823245 819082 820340 511260 634422 389243 388522 405990 420910 422561 423021 423270 433152 422847 443216 445081 482621 445473 452221 452434 452444 459264 469550 452441 511264 512192 498620 504722 511271 533660 537732 499040 510043 508962 525099 526789 527110 537932 485577 542648 560216 571824 551086 720829 592673 423009 453019 396278 458094 405203 477216 457498 533499 488379 492573 492732 499212 501865 815764 539899 425027 419910 422592 438765 511249 415950 435727 539867 720040 382649 403635 412122 429583 819390 497467 535626 522123 459233 214988 485578 540452 398614 406134 416191 423023 428479 422997 443617 419950 435629 456634 459237 459316 477404 492805 453331 458384 458429 478955 499035 510622 512181 527117 ] |
||||||||||||||||||||||||||||||
|
3.30 ms (1.96%) |
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 2571 214988 382649 388522 389243 396265 396278 397809 398614 403635 405203 405990 406134 410132 412122 415950 416191 419910 419950 420206 420910 422561 422592 422705 422847 422997 423009 423021 423023 423270 425027 428479 429068 429583 433152 435629 435727 438765 443215 443216 443617 445081 445473 445879 446266 452221 452434 452441 452444 453019 453331 456627 456633 456634 457498 458094 458384 458429 459233 459237 459264 459316 469536 469550 477216 477404 478955 482621 485577 485578 488379 492573 492732 492805 497467 497715 498620 499035 499040 499212 501865 504722 507670 508962 510043 510622 511249 511260 511264 511271 512181 512192 522123 525099 526789 527110 527117 533499 533660 535626 537732 537932 539867 539899 540452 542648 551086 560216 560578 571824 592673 634422 720040 720829 737321 815764 819082 819390 820340 823245 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian white"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк white"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"азиатк white"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.