Query Metrics
7
Database Queries
7
Different statements
168.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.00 ms (86.05%) |
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 7196 388281 397982 403797 417021 419492 422271 423612 423633 426571 434670 435398 436139 436437 437610 439151 440655 443202 445022 446560 447790 447888 453337 457569 460450 466747 467558 468548 468579 470011 470813 472321 472962 474914 478514 478548 480207 483737 487506 492571 493047 495163 499776 501650 502190 503361 507601 508430 509672 510573 512189 512830 512855 513324 514357 514574 515572 515847 516693 517832 518270 519084 523003 523540 525058 527177 527412 528459 532152 532370 533917 536766 537926 538963 548548 554912 558820 559095 559159 563259 563823 565201 567957 569249 576270 581683 584474 585767 586890 597947 598786 598794 600565 602532 615608 616013 616315 617412 628069 629411 630221 633524 635225 635900 637065 637105 637168 640708 640783 642750 650379 650767 656319 672711 679808 687330 714109 762213 770382 790878 ] |
||||||||||||||||||||||||||||||
|
14.45 ms (8.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 569249 567957 687330 650379 679808 635225 637105 642750 790878 422271 426571 466747 436437 397982 478548 503361 512830 502190 517832 515847 581683 633524 472962 423612 419492 443202 492571 501650 478514 483737 523540 519084 537926 714109 586890 637065 640708 616013 472321 467558 474914 439151 480207 493047 453337 635900 630221 468579 533917 554912 576270 598786 598794 417021 470011 445022 434670 487506 514574 508430 548548 628069 527412 437610 457569 510573 527177 512189 515572 563823 585767 600565 597947 637168 440655 460450 446560 470813 423633 436139 447790 512855 516693 532370 563259 672711 616315 762213 617412 629411 435398 7196 388281 468548 514357 538963 584474 559159 558820 656319 640783 770382 447888 509672 513324 495163 523003 499776 518270 403797 507601 532152 559095 565201 650767 602532 615608 528459 525058 536766 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.72%) |
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 7196 388281 397982 403797 417021 419492 422271 423612 423633 426571 434670 435398 436139 436437 437610 439151 440655 443202 445022 446560 447790 447888 453337 457569 460450 466747 467558 468548 468579 470011 470813 472321 472962 474914 478514 478548 480207 483737 487506 492571 493047 495163 499776 501650 502190 503361 507601 508430 509672 510573 512189 512830 512855 513324 514357 514574 515572 515847 516693 517832 518270 519084 523003 523540 525058 527177 527412 528459 532152 532370 533917 536766 537926 538963 548548 554912 558820 559095 559159 563259 563823 565201 567957 569249 576270 581683 584474 585767 586890 597947 598786 598794 600565 602532 615608 616013 616315 617412 628069 629411 630221 633524 635225 635900 637065 637105 637168 640708 640783 642750 650379 650767 656319 672711 679808 687330 714109 762213 770382 790878 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"18 teen cute"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"18 teen cute"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"18 teen cute"
]
|
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.