Query Metrics
7
Database Queries
7
Different statements
390.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
362.12 ms (92.70%) |
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 118086 143302 260297 314133 385359 392903 394187 398217 398317 399396 400556 401704 404927 407007 412775 416099 417502 417877 418521 420655 426482 430508 431541 440692 445776 447473 451582 452992 453041 454129 455126 456681 456952 460938 461432 466649 467758 469846 474237 477347 481099 486385 497524 497589 499382 502052 502441 504206 505634 507887 508470 515219 519816 520545 521107 521619 527427 531777 538998 542502 544396 544977 551164 552312 555664 560405 560427 561416 564172 573778 576024 576381 579635 587038 589349 595249 603220 603248 603662 615883 621709 629304 649196 650853 662197 665921 667859 670562 672999 677038 684014 684088 684181 684554 699627 699631 705540 707275 717828 717940 721325 725599 737332 741196 742422 746980 747004 748549 749266 770396 770490 788315 799653 800240 809439 809688 810701 814265 814822 825116 ] |
||||||||||||||||||||||||||||||
|
17.80 ms (4.56%) |
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 412775 260297 385359 445776 460938 400556 461432 420655 504206 527427 508470 497524 520545 560427 564172 398217 399396 417877 426482 407007 440692 814822 825116 453041 481099 454129 456681 466649 452992 456952 499382 502441 544977 555664 542502 552312 561416 579635 662197 717828 717940 649196 650853 665921 667859 684181 699631 670562 672999 684014 684554 705540 603248 587038 589349 603662 629304 615883 603220 799653 809439 770490 800240 809688 741196 746980 725599 737332 748549 707275 314133 401704 418521 143302 398317 477347 404927 430508 431541 467758 474237 118086 416099 451582 486385 521107 521619 497589 502052 519816 684088 810701 749266 505634 394187 417502 814265 538998 531777 544396 551164 573778 576381 560405 677038 699627 576024 595249 621709 770396 742422 747004 721325 788315 447473 507887 515219 392903 455126 469846 ] |
||||||||||||||||||||||||||||||
|
3.56 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 118086 143302 260297 314133 385359 392903 394187 398217 398317 399396 400556 401704 404927 407007 412775 416099 417502 417877 418521 420655 426482 430508 431541 440692 445776 447473 451582 452992 453041 454129 455126 456681 456952 460938 461432 466649 467758 469846 474237 477347 481099 486385 497524 497589 499382 502052 502441 504206 505634 507887 508470 515219 519816 520545 521107 521619 527427 531777 538998 542502 544396 544977 551164 552312 555664 560405 560427 561416 564172 573778 576024 576381 579635 587038 589349 595249 603220 603248 603662 615883 621709 629304 649196 650853 662197 665921 667859 670562 672999 677038 684014 684088 684181 684554 699627 699631 705540 707275 717828 717940 721325 725599 737332 741196 742422 746980 747004 748549 749266 770396 770490 788315 799653 800240 809439 809688 810701 814265 814822 825116 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"two girls"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"two девушк"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"two девушк"
]
|
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.