Query Metrics
7
Database Queries
7
Different statements
162.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.02 ms (85.00%) |
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 105093 123614 387682 390991 394103 406954 409784 422523 423071 428451 428726 429068 429479 429635 430239 430270 431660 435449 443274 443611 454147 458518 463750 464949 471822 483551 489806 491678 492414 494402 494510 496114 508487 510581 512194 526090 526100 536214 546428 549329 550769 550774 551012 552029 554424 554425 554436 557812 559861 559880 559945 564585 564795 565161 565167 565997 566002 566074 572373 572736 585159 586588 592935 596911 600830 601024 603102 603144 606487 607845 610247 611322 615951 617493 617921 619443 619447 619457 622197 622658 623502 623555 623564 628161 637740 638544 642439 642796 646219 649224 668394 672217 673051 674016 679059 680517 690771 696125 697288 712205 723865 730572 732395 735623 749493 752155 755312 766718 770747 785755 796397 805810 814048 817918 818172 818351 819396 820538 821096 821923 ] |
||||||||||||||||||||||||||||||
|
14.18 ms (8.73%) |
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 628161 585159 603144 586588 596911 601024 622197 623564 623502 123614 463750 394103 422523 471822 429635 430239 430270 443611 494402 489806 536214 551012 552029 554425 603102 435449 817918 819396 821096 818351 821923 496114 546428 554436 559861 564795 549329 672217 697288 674016 679059 680517 690771 712205 649224 696125 559880 619443 642796 592935 600830 619447 637740 642439 607845 615951 606487 638544 796397 805810 732395 770747 723865 755312 766718 730572 735623 749493 617493 622658 623555 785755 428451 458518 508487 565161 565167 668394 550774 610247 454147 406954 423071 491678 387682 429068 429479 428726 818172 492414 464949 494510 512194 526090 526100 565997 566002 550769 566074 564585 646219 673051 554424 557812 559945 572373 572736 617921 619457 752155 611322 390991 431660 443274 409784 483551 510581 105093 814048 820538 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.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 105093 123614 387682 390991 394103 406954 409784 422523 423071 428451 428726 429068 429479 429635 430239 430270 431660 435449 443274 443611 454147 458518 463750 464949 471822 483551 489806 491678 492414 494402 494510 496114 508487 510581 512194 526090 526100 536214 546428 549329 550769 550774 551012 552029 554424 554425 554436 557812 559861 559880 559945 564585 564795 565161 565167 565997 566002 566074 572373 572736 585159 586588 592935 596911 600830 601024 603102 603144 606487 607845 610247 611322 615951 617493 617921 619443 619447 619457 622197 622658 623502 623555 623564 628161 637740 638544 642439 642796 646219 649224 668394 672217 673051 674016 679059 680517 690771 696125 697288 712205 723865 730572 732395 735623 749493 752155 755312 766718 770747 785755 796397 805810 814048 817918 818172 818351 819396 820538 821096 821923 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian pussy"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк pussy"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"азиатк pussy"
]
|
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.