Query Metrics
7
Database Queries
7
Different statements
150.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.99 ms (83.52%) |
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 107495 381963 383370 387499 392978 394053 402564 407171 421326 422475 424497 426893 428968 431962 433697 436691 441822 446783 447132 448412 449317 457593 460970 461893 462207 462359 462360 462381 464209 465924 465933 467195 468765 468827 470973 475824 477470 479202 482585 486673 488360 488705 489603 491357 491940 492110 499182 500549 501290 503361 503488 510841 511600 511996 512580 514781 516652 516979 519403 521228 521581 521741 522343 523189 523684 526787 527099 530523 534334 536214 536684 539086 546829 548034 552933 554498 556319 559228 559551 560950 561024 567349 568561 573345 574863 575451 576377 580262 585740 592763 598187 607102 611730 623656 629388 634208 634818 640531 646023 654340 667917 702149 709404 713115 750940 754204 759786 766337 782193 794472 795717 805023 806331 806383 807464 810715 810725 815150 815566 816371 ] |
||||||||||||||||||||||||||||||
|
15.95 ms (10.58%) |
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 806331 794472 381963 407171 433697 521228 536684 523189 559551 640531 462381 634818 634208 522343 499182 461893 462359 462360 488360 667917 449317 519403 465933 816371 548034 575451 568561 574863 468827 503488 511600 489603 492110 536214 383370 392978 426893 422475 436691 424497 815150 448412 510841 530523 539086 482585 546829 552933 573345 554498 556319 567349 646023 654340 702149 709404 713115 607102 611730 623656 592763 795717 810715 782193 810725 750940 759786 754204 766337 629388 806383 807464 394053 457593 470973 402564 387499 446783 500549 511996 526787 491357 512580 580262 815566 460970 501290 516979 475824 576377 559228 560950 561024 598187 585740 805023 462207 464209 465924 479202 421326 468765 503361 491940 486673 488705 527099 514781 521741 523684 447132 521581 534334 431962 467195 477470 516652 107495 428968 441822 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.54%) |
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 107495 381963 383370 387499 392978 394053 402564 407171 421326 422475 424497 426893 428968 431962 433697 436691 441822 446783 447132 448412 449317 457593 460970 461893 462207 462359 462360 462381 464209 465924 465933 467195 468765 468827 470973 475824 477470 479202 482585 486673 488360 488705 489603 491357 491940 492110 499182 500549 501290 503361 503488 510841 511600 511996 512580 514781 516652 516979 519403 521228 521581 521741 522343 523189 523684 526787 527099 530523 534334 536214 536684 539086 546829 548034 552933 554498 556319 559228 559551 560950 561024 567349 568561 573345 574863 575451 576377 580262 585740 592763 598187 607102 611730 623656 629388 634208 634818 640531 646023 654340 667917 702149 709404 713115 750940 754204 759786 766337 782193 794472 795717 805023 806331 806383 807464 810715 810725 815150 815566 816371 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bdsm pussy licking"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бдсм pussy лиза"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.92%) |
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.