Query Metrics
7
Database Queries
7
Different statements
164.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.92 ms (83.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 391808 393218 400465 403434 417263 417283 421932 422167 425287 428764 429365 434936 435799 436465 436490 444212 445682 446762 449344 450379 452732 453603 453835 453838 456507 457276 459008 459411 461782 465630 467799 469757 471332 471960 475503 477849 477853 482923 483036 483278 484885 486166 486751 489257 489260 490498 493024 493286 494013 495457 496230 496627 497858 497993 498723 499020 499987 500008 500178 504703 505304 505359 505360 505864 506217 506649 509084 509099 512413 513561 513581 513747 514573 516952 520699 522124 522714 525027 526810 533125 533703 534463 534603 536682 540422 541099 542079 542104 544509 545852 547539 552352 553332 554219 557740 559319 560793 563555 564892 565086 578240 580144 582380 645264 645446 650060 664468 666404 674340 679166 692074 696225 702286 704208 711565 712540 716856 814556 817298 823456 ] |
||||||||||||||||||||||||||||||
|
17.46 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 435799 436465 452732 453603 467799 444212 461782 475503 417263 417283 421932 422167 425287 429365 434936 445682 469757 500178 513747 482923 483036 483278 493286 495457 522124 493024 496627 498723 499020 504703 506217 506649 509099 486166 486751 497858 497993 500008 505359 505864 520699 522714 489260 578240 560793 645446 716856 494013 499987 489257 512413 393218 391808 400465 403434 428764 436490 817298 814556 823456 449344 453835 457276 459008 465630 446762 450379 453838 456507 459411 471332 471960 477849 477853 490498 505360 534603 540422 509084 534463 505304 513561 513581 516952 525027 533703 536682 496230 514573 526810 533125 484885 541099 542079 542104 544509 554219 559319 580144 547539 553332 582380 557740 563555 564892 565086 650060 674340 679166 702286 692074 704208 645264 664468 666404 696225 711565 712540 545852 552352 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.76%) |
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 391808 393218 400465 403434 417263 417283 421932 422167 425287 428764 429365 434936 435799 436465 436490 444212 445682 446762 449344 450379 452732 453603 453835 453838 456507 457276 459008 459411 461782 465630 467799 469757 471332 471960 475503 477849 477853 482923 483036 483278 484885 486166 486751 489257 489260 490498 493024 493286 494013 495457 496230 496627 497858 497993 498723 499020 499987 500008 500178 504703 505304 505359 505360 505864 506217 506649 509084 509099 512413 513561 513581 513747 514573 516952 520699 522124 522714 525027 526810 533125 533703 534463 534603 536682 540422 541099 542079 542104 544509 545852 547539 552352 553332 554219 557740 559319 560793 563555 564892 565086 578240 580144 582380 645264 645446 650060 664468 666404 674340 679166 692074 696225 702286 704208 711565 712540 716856 814556 817298 823456 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum-in-mouth"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum mouth"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum mouth"
]
|
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.