寝具・カエルカテゴリー・Daniel/ダニエル のセール・展示会情報

イベント件数2件
検索条件を変更
2.07sRequest Duration4MBMemory UsageGET eventsRoute
  • [19:40:08] LOG.debug: Performance of controller. {"url":"https:\/\/sale.dev.heyagoto.com\/events?cat...debuglog
  • Booting (193.6ms)
  • Application (1.89s)
    17 templates were rendered
    • front.events.index (resources/views/front/events/index.blade.php)16blade
      Params
      0
      events
      1
      sortOptions
      2
      condition
      3
      sortKey
      4
      topBanners
      5
      insetBanners
      6
      title
      7
      description
      8
      searchTexts
      9
      noindex
      10
      canonical
      11
      shopTitle
      12
      shopLink
      13
      suggestions
      14
      hashtags
      15
      isAppSule
    • front._parts.event (resources/views/front/_parts/event.blade.php)34blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      events
      5
      sortOptions
      6
      condition
      7
      sortKey
      8
      topBanners
      9
      insetBanners
      10
      title
      11
      description
      12
      searchTexts
      13
      noindex
      14
      canonical
      15
      shopTitle
      16
      shopLink
      17
      suggestions
      18
      hashtags
      19
      isAppSule
      20
      breadcrumbPosition
      21
      _categories
      22
      texts
      23
      __currentLoopData
      24
      _suggestion
      25
      key
      26
      loop
      27
      _hashtag
      28
      _insetThreshold
      29
      _insetInterval
      30
      _event
      31
      _i
      32
      event
      33
      lazy
    • front._parts.event (resources/views/front/_parts/event.blade.php)34blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      events
      5
      sortOptions
      6
      condition
      7
      sortKey
      8
      topBanners
      9
      insetBanners
      10
      title
      11
      description
      12
      searchTexts
      13
      noindex
      14
      canonical
      15
      shopTitle
      16
      shopLink
      17
      suggestions
      18
      hashtags
      19
      isAppSule
      20
      breadcrumbPosition
      21
      _categories
      22
      texts
      23
      __currentLoopData
      24
      _suggestion
      25
      key
      26
      loop
      27
      _hashtag
      28
      _insetThreshold
      29
      _insetInterval
      30
      _event
      31
      _i
      32
      event
      33
      lazy
    • pagination::default (vendor/laravel/framework/src/Illuminate/Pagination/resources/views/default.blade.php)2blade
      Params
      0
      paginator
      1
      elements
    • front._widgets.search (resources/views/front/_widgets/search.blade.php)41blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      events
      5
      sortOptions
      6
      condition
      7
      sortKey
      8
      topBanners
      9
      insetBanners
      10
      title
      11
      description
      12
      searchTexts
      13
      noindex
      14
      canonical
      15
      shopTitle
      16
      shopLink
      17
      suggestions
      18
      hashtags
      19
      isAppSule
      20
      breadcrumbPosition
      21
      _categories
      22
      texts
      23
      __currentLoopData
      24
      _suggestion
      25
      key
      26
      loop
      27
      _hashtag
      28
      _insetThreshold
      29
      _insetInterval
      30
      _event
      31
      _i
      32
      _makers
      33
      categoryFromMaker
      34
      makers
      35
      categories
      36
      areas
      37
      prefectures
      38
      regions
      39
      calendar
      40
      adBanner
    • front._layouts.pc (resources/views/front/_layouts/pc.blade.php)34blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      events
      5
      sortOptions
      6
      condition
      7
      sortKey
      8
      topBanners
      9
      insetBanners
      10
      title
      11
      description
      12
      searchTexts
      13
      noindex
      14
      canonical
      15
      shopTitle
      16
      shopLink
      17
      suggestions
      18
      hashtags
      19
      isAppSule
      20
      breadcrumbPosition
      21
      _categories
      22
      texts
      23
      __currentLoopData
      24
      _suggestion
      25
      key
      26
      loop
      27
      _hashtag
      28
      _insetThreshold
      29
      _insetInterval
      30
      _event
      31
      _i
      32
      _makers
      33
      categoryFromMaker
    • front._parts.meta (resources/views/front/_parts/meta.blade.php)34blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      events
      5
      sortOptions
      6
      condition
      7
      sortKey
      8
      topBanners
      9
      insetBanners
      10
      title
      11
      description
      12
      searchTexts
      13
      noindex
      14
      canonical
      15
      shopTitle
      16
      shopLink
      17
      suggestions
      18
      hashtags
      19
      isAppSule
      20
      breadcrumbPosition
      21
      _categories
      22
      texts
      23
      __currentLoopData
      24
      _suggestion
      25
      key
      26
      loop
      27
      _hashtag
      28
      _insetThreshold
      29
      _insetInterval
      30
      _event
      31
      _i
      32
      _makers
      33
      categoryFromMaker
    • front._parts.style (resources/views/front/_parts/style.blade.php)34blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      events
      5
      sortOptions
      6
      condition
      7
      sortKey
      8
      topBanners
      9
      insetBanners
      10
      title
      11
      description
      12
      searchTexts
      13
      noindex
      14
      canonical
      15
      shopTitle
      16
      shopLink
      17
      suggestions
      18
      hashtags
      19
      isAppSule
      20
      breadcrumbPosition
      21
      _categories
      22
      texts
      23
      __currentLoopData
      24
      _suggestion
      25
      key
      26
      loop
      27
      _hashtag
      28
      _insetThreshold
      29
      _insetInterval
      30
      _event
      31
      _i
      32
      _makers
      33
      categoryFromMaker
    • front._parts.tracking-tag-head-end (resources/views/front/_parts/tracking-tag-head-end.blade.php)34blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      events
      5
      sortOptions
      6
      condition
      7
      sortKey
      8
      topBanners
      9
      insetBanners
      10
      title
      11
      description
      12
      searchTexts
      13
      noindex
      14
      canonical
      15
      shopTitle
      16
      shopLink
      17
      suggestions
      18
      hashtags
      19
      isAppSule
      20
      breadcrumbPosition
      21
      _categories
      22
      texts
      23
      __currentLoopData
      24
      _suggestion
      25
      key
      26
      loop
      27
      _hashtag
      28
      _insetThreshold
      29
      _insetInterval
      30
      _event
      31
      _i
      32
      _makers
      33
      categoryFromMaker
    • front._parts.tracking-tag-body-start (resources/views/front/_parts/tracking-tag-body-start.blade.php)34blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      events
      5
      sortOptions
      6
      condition
      7
      sortKey
      8
      topBanners
      9
      insetBanners
      10
      title
      11
      description
      12
      searchTexts
      13
      noindex
      14
      canonical
      15
      shopTitle
      16
      shopLink
      17
      suggestions
      18
      hashtags
      19
      isAppSule
      20
      breadcrumbPosition
      21
      _categories
      22
      texts
      23
      __currentLoopData
      24
      _suggestion
      25
      key
      26
      loop
      27
      _hashtag
      28
      _insetThreshold
      29
      _insetInterval
      30
      _event
      31
      _i
      32
      _makers
      33
      categoryFromMaker
    • front._parts.main-header (resources/views/front/_parts/main-header.blade.php)37blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      events
      5
      sortOptions
      6
      condition
      7
      sortKey
      8
      topBanners
      9
      insetBanners
      10
      title
      11
      description
      12
      searchTexts
      13
      noindex
      14
      canonical
      15
      shopTitle
      16
      shopLink
      17
      suggestions
      18
      hashtags
      19
      isAppSule
      20
      breadcrumbPosition
      21
      _categories
      22
      texts
      23
      __currentLoopData
      24
      _suggestion
      25
      key
      26
      loop
      27
      _hashtag
      28
      _insetThreshold
      29
      _insetInterval
      30
      _event
      31
      _i
      32
      _makers
      33
      categoryFromMaker
      34
      areas
      35
      logo
      36
      seasonIcon
    • front._parts.breadcrumb (resources/views/front/_parts/breadcrumb.blade.php)34blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      events
      5
      sortOptions
      6
      condition
      7
      sortKey
      8
      topBanners
      9
      insetBanners
      10
      title
      11
      description
      12
      searchTexts
      13
      noindex
      14
      canonical
      15
      shopTitle
      16
      shopLink
      17
      suggestions
      18
      hashtags
      19
      isAppSule
      20
      breadcrumbPosition
      21
      _categories
      22
      texts
      23
      __currentLoopData
      24
      _suggestion
      25
      key
      26
      loop
      27
      _hashtag
      28
      _insetThreshold
      29
      _insetInterval
      30
      _event
      31
      _i
      32
      _makers
      33
      categoryFromMaker
    • front._parts.alert-box (resources/views/front/_parts/alert-box.blade.php)34blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      events
      5
      sortOptions
      6
      condition
      7
      sortKey
      8
      topBanners
      9
      insetBanners
      10
      title
      11
      description
      12
      searchTexts
      13
      noindex
      14
      canonical
      15
      shopTitle
      16
      shopLink
      17
      suggestions
      18
      hashtags
      19
      isAppSule
      20
      breadcrumbPosition
      21
      _categories
      22
      texts
      23
      __currentLoopData
      24
      _suggestion
      25
      key
      26
      loop
      27
      _hashtag
      28
      _insetThreshold
      29
      _insetInterval
      30
      _event
      31
      _i
      32
      _makers
      33
      categoryFromMaker
    • front._parts.error-box (resources/views/front/_parts/error-box.blade.php)34blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      events
      5
      sortOptions
      6
      condition
      7
      sortKey
      8
      topBanners
      9
      insetBanners
      10
      title
      11
      description
      12
      searchTexts
      13
      noindex
      14
      canonical
      15
      shopTitle
      16
      shopLink
      17
      suggestions
      18
      hashtags
      19
      isAppSule
      20
      breadcrumbPosition
      21
      _categories
      22
      texts
      23
      __currentLoopData
      24
      _suggestion
      25
      key
      26
      loop
      27
      _hashtag
      28
      _insetThreshold
      29
      _insetInterval
      30
      _event
      31
      _i
      32
      _makers
      33
      categoryFromMaker
    • front._parts.main-footer (resources/views/front/_parts/main-footer.blade.php)39blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      events
      5
      sortOptions
      6
      condition
      7
      sortKey
      8
      topBanners
      9
      insetBanners
      10
      title
      11
      description
      12
      searchTexts
      13
      noindex
      14
      canonical
      15
      shopTitle
      16
      shopLink
      17
      suggestions
      18
      hashtags
      19
      isAppSule
      20
      breadcrumbPosition
      21
      _categories
      22
      texts
      23
      __currentLoopData
      24
      _suggestion
      25
      key
      26
      loop
      27
      _hashtag
      28
      _insetThreshold
      29
      _insetInterval
      30
      _event
      31
      _i
      32
      _makers
      33
      categoryFromMaker
      34
      areas
      35
      prefectures
      36
      makers
      37
      categories
      38
      adBanner
    • front._parts.script (resources/views/front/_parts/script.blade.php)34blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      events
      5
      sortOptions
      6
      condition
      7
      sortKey
      8
      topBanners
      9
      insetBanners
      10
      title
      11
      description
      12
      searchTexts
      13
      noindex
      14
      canonical
      15
      shopTitle
      16
      shopLink
      17
      suggestions
      18
      hashtags
      19
      isAppSule
      20
      breadcrumbPosition
      21
      _categories
      22
      texts
      23
      __currentLoopData
      24
      _suggestion
      25
      key
      26
      loop
      27
      _hashtag
      28
      _insetThreshold
      29
      _insetInterval
      30
      _event
      31
      _i
      32
      _makers
      33
      categoryFromMaker
    • front._parts.tracking-tag-body-end (resources/views/front/_parts/tracking-tag-body-end.blade.php)34blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      events
      5
      sortOptions
      6
      condition
      7
      sortKey
      8
      topBanners
      9
      insetBanners
      10
      title
      11
      description
      12
      searchTexts
      13
      noindex
      14
      canonical
      15
      shopTitle
      16
      shopLink
      17
      suggestions
      18
      hashtags
      19
      isAppSule
      20
      breadcrumbPosition
      21
      _categories
      22
      texts
      23
      __currentLoopData
      24
      _suggestion
      25
      key
      26
      loop
      27
      _hashtag
      28
      _insetThreshold
      29
      _insetInterval
      30
      _event
      31
      _i
      32
      _makers
      33
      categoryFromMaker
    uri
    GET events
    middleware
    web, front
    as
    front.events.index
    controller
    Seiloo\Http\Front\Event\EventController@index
    namespace
    null
    prefix
    null
    where
    file
    app/Http/Front/Event/EventController.php:34-191
    41 statements were executed, 14 of which were duplicated, 27 unique425.65ms
    • select * from `regions` where `regions`.`id` is null limit 145.34msheyagoto_core
      Metadata
      Hints
      • Use SELECT * only if you need all columns from table
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    • select * from `prefectures` where `prefectures`.`id` is null limit 112.3msheyagoto_core
      Metadata
      Hints
      • Use SELECT * only if you need all columns from table
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    • select * from `areas` where `areas`.`id` is null limit 18.56msheyagoto_core
      Metadata
      Hints
      • Use SELECT * only if you need all columns from table
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    • select * from `categories` where `slug` in ('frogcategory')7.46msheyagoto_core
      Metadata
      Bindings
      • 0. frogcategory
      Hints
      • Use SELECT * only if you need all columns from table
    • select * from `makers` where `slug` in ('daniel')29.32msheyagoto_core
      Metadata
      Bindings
      • 0. daniel
      Hints
      • Use SELECT * only if you need all columns from table
    • select count(*) as aggregate from `events` where `status_id` = '6' and `list_ended_at` > '2025-07-30 19:40:06' and `keyword` LIKE '%寝具%' and (select count(*) from `categories` inner join `events_categories` on `categories`.`id` = `events_categories`.`category_id` where `events`.`id` = `events_categories`.`event_id` and `id` in ('28')) = 1 and (select count(*) from `makers` inner join `events_makers` on `makers`.`id` = `events_makers`.`maker_id` where `events`.`id` = `events_makers`.`event_id` and `makers`.`id` in ('91')) = 1 and `revision` = '0'15.08msheyagoto_core
      Metadata
      Bindings
      • 0. 6
      • 1. 2025-07-30 19:40:06
      • 2. %寝具%
      • 3. 28
      • 4. 91
      • 5. 0
    • select * from `events` where `status_id` = '6' and `list_ended_at` > '2025-07-30 19:40:06' and `keyword` LIKE '%寝具%' and (select count(*) from `categories` inner join `events_categories` on `categories`.`id` = `events_categories`.`category_id` where `events`.`id` = `events_categories`.`event_id` and `id` in ('28')) = 1 and (select count(*) from `makers` inner join `events_makers` on `makers`.`id` = `events_makers`.`maker_id` where `events`.`id` = `events_makers`.`event_id` and `makers`.`id` in ('91')) = 1 and `revision` = '0' order by `priority` asc limit 10 offset 015.93msheyagoto_core
      Metadata
      Bindings
      • 0. 6
      • 1. 2025-07-30 19:40:06
      • 2. %寝具%
      • 3. 28
      • 4. 91
      • 5. 0
      Hints
      • Use SELECT * only if you need all columns from table
    • select * from `prefectures` where `prefectures`.`id` in ('12')23msheyagoto_core
      Metadata
      Bindings
      • 0. 12
      Hints
      • Use SELECT * only if you need all columns from table
    • select `categories`.*, `events_categories`.`event_id` as `pivot_event_id`, `events_categories`.`category_id` as `pivot_category_id` from `categories` inner join `events_categories` on `categories`.`id` = `events_categories`.`category_id` where `events_categories`.`event_id` in ('2983', '3996') and `status_id` = '1' and `opened` = '1' order by `weight` asc12.46msheyagoto_core
      Metadata
      Bindings
      • 0. 2983
      • 1. 3996
      • 2. 1
      • 3. 1
      Hints
      • Use SELECT * only if you need all columns from table
    • select * from `events_pages` where `events_pages`.`event_id` in ('2983', '3996')17.21msheyagoto_core
      Metadata
      Bindings
      • 0. 2983
      • 1. 3996
      Hints
      • Use SELECT * only if you need all columns from table
    • select * from `events_pages_resources` where `events_pages_resources`.`page_id` in ('2983', '3996')14.28msheyagoto_core
      Metadata
      Bindings
      • 0. 2983
      • 1. 3996
      Hints
      • Use SELECT * only if you need all columns from table
    • select `id`, `name` from `files` where `files`.`id` in ('2', '3', '4', '5', '6', '8', '9', '10', '141280', '141281', '141282', '142043', '142044')32.73msheyagoto_core
      Metadata
      Bindings
      • 0. 2
      • 1. 3
      • 2. 4
      • 3. 5
      • 4. 6
      • 5. 8
      • 6. 9
      • 7. 10
      • 8. 141280
      • 9. 141281
      • 10. 141282
      • 11. 142043
      • 12. 142044
    • select `hashtags`.*, `events_hashtags`.`event_id` as `pivot_event_id`, `events_hashtags`.`hashtags_id` as `pivot_hashtags_id` from `hashtags` inner join `events_hashtags` on `hashtags`.`id` = `events_hashtags`.`hashtags_id` where `events_hashtags`.`event_id` in ('2983', '3996')21.93msheyagoto_core
      Metadata
      Bindings
      • 0. 2983
      • 1. 3996
      Hints
      • Use SELECT * only if you need all columns from table
    • select * from `banner_slots` where `symbol` = 'seiloo.events.top' limit 111.17msheyagoto_core
      Metadata
      Bindings
      • 0. seiloo.events.top
      Hints
      • Use SELECT * only if you need all columns from table
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    • select * from `banners` where `status_id` = '2' and `started_at` < '2025-07-30 19:40:06' and `ended_at` > '2025-07-30 19:40:06' and `slot_id` = '3' order by RAND() limit 413.96msheyagoto_core
      Metadata
      Bindings
      • 0. 2
      • 1. 2025-07-30 19:40:06
      • 2. 2025-07-30 19:40:06
      • 3. 3
      Hints
      • Use SELECT * only if you need all columns from table
      • ORDER BY RAND() is slow, try to avoid if you can. You can read this or this
    • select * from `banner_slots` where `symbol` = 'seiloo.events.inset' limit 112.31msheyagoto_core
      Metadata
      Bindings
      • 0. seiloo.events.inset
      Hints
      • Use SELECT * only if you need all columns from table
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    • select * from `banners` where `status_id` = '2' and `started_at` < '2025-07-30 19:40:06' and `ended_at` > '2025-07-30 19:40:06' and `slot_id` = '8' and exists (select * from `categories` inner join `banners_categories` on `categories`.`id` = `banners_categories`.`category_id` where `banners`.`id` = `banners_categories`.`banner_id` and `id` in ('28')) and exists (select * from `makers` inner join `banners_makers` on `makers`.`id` = `banners_makers`.`maker_id` where `banners`.`id` = `banners_makers`.`banner_id` and `id` in ('91')) order by RAND()20.18msheyagoto_core
      Metadata
      Bindings
      • 0. 2
      • 1. 2025-07-30 19:40:06
      • 2. 2025-07-30 19:40:06
      • 3. 8
      • 4. 28
      • 5. 91
      Hints
      • Use SELECT * only if you need all columns from table
      • ORDER BY RAND() is slow, try to avoid if you can. You can read this or this
    • select * from `categories` where `slug` in ('frogcategory')10.68msheyagoto_core
      Metadata
      Bindings
      • 0. frogcategory
      Hints
      • Use SELECT * only if you need all columns from table
    • select * from `makers` where `slug` in ('daniel')10.82msheyagoto_core
      Metadata
      Bindings
      • 0. daniel
      Hints
      • Use SELECT * only if you need all columns from table
    • select * from `product_categories` where `product_categories`.`id` is null and `status_id` <> '3' limit 17.8msheyagoto_core
      Metadata
      Bindings
      • 0. 3
      Hints
      • Use SELECT * only if you need all columns from table
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    • select * from `services` where `status_id` <> '4' order by `weight` asc10.32msheyagoto_core
      Metadata
      Bindings
      • 0. 4
      Hints
      • Use SELECT * only if you need all columns from table
    • select `areas`.*, (select count(*) from `events` inner join `prefectures` on `prefectures`.`id` = `events`.`site_prefecture_id` where `areas`.`id` = `prefectures`.`area_id` and `status_id` = '6' and `list_ended_at` > '2025-07-30 19:40:07' and `keyword` LIKE '%寝具%' and (select count(*) from `categories` inner join `events_categories` on `categories`.`id` = `events_categories`.`category_id` where `events`.`id` = `events_categories`.`event_id` and `id` in ('28')) = 1 and (select count(*) from `makers` inner join `events_makers` on `makers`.`id` = `events_makers`.`maker_id` where `events`.`id` = `events_makers`.`event_id` and `makers`.`id` in ('91')) = 1 and `revision` = '0') as `events_count` from `areas` where exists (select * from `events` inner join `prefectures` on `prefectures`.`id` = `events`.`site_prefecture_id` where `areas`.`id` = `prefectures`.`area_id` and `status_id` = '6' and `list_ended_at` > '2025-07-30 19:40:06' and `keyword` LIKE '%寝具%' and (select count(*) from `categories` inner join `events_categories` on `categories`.`id` = `events_categories`.`category_id` where `events`.`id` = `events_categories`.`event_id` and `id` in ('28')) = 1 and (select count(*) from `makers` inner join `events_makers` on `makers`.`id` = `events_makers`.`maker_id` where `events`.`id` = `events_makers`.`event_id` and `makers`.`id` in ('91')) = 1 and `revision` = '0')34.15msheyagoto_core
      Metadata
      Bindings
      • 0. 6
      • 1. 2025-07-30 19:40:07
      • 2. %寝具%
      • 3. 28
      • 4. 91
      • 5. 0
      • 6. 6
      • 7. 2025-07-30 19:40:06
      • 8. %寝具%
      • 9. 28
      • 10. 91
      • 11. 0
      Hints
      • Use SELECT * only if you need all columns from table
    • select * from `event_page_templates` where `event_page_templates`.`id` = '2575' and `revision` = '0' limit 110.88msheyagoto_core
      Metadata
      Bindings
      • 0. 2575
      • 1. 0
      Hints
      • Use SELECT * only if you need all columns from table
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    • select * from `event_page_templates` where `event_page_templates`.`id` = '2575' and `revision` = '0' limit 14.83msheyagoto_core
      Metadata
      Bindings
      • 0. 2575
      • 1. 0
      Hints
      • Use SELECT * only if you need all columns from table
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    • select `categories`.*, `categories_makers`.`maker_id` as `pivot_maker_id`, `categories_makers`.`category_id` as `pivot_category_id`, `categories_makers`.`description` as `pivot_description` from `categories` inner join `categories_makers` on `categories`.`id` = `categories_makers`.`category_id` where `categories_makers`.`maker_id` = '91' and `categories`.`id` = '28' limit 1590μsheyagoto_core
      Metadata
      Bindings
      • 0. 91
      • 1. 28
      Hints
      • Use SELECT * only if you need all columns from table
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    • select * from `regions` where `regions`.`id` is null limit 1340μsheyagoto_core
      Metadata
      Hints
      • Use SELECT * only if you need all columns from table
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    • select * from `prefectures` where `prefectures`.`id` is null limit 1300μsheyagoto_core
      Metadata
      Hints
      • Use SELECT * only if you need all columns from table
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    • select * from `categories` where `slug` in ('frogcategory')380μsheyagoto_core
      Metadata
      Bindings
      • 0. frogcategory
      Hints
      • Use SELECT * only if you need all columns from table
    • select * from `makers` where `slug` in ('daniel')380μsheyagoto_core
      Metadata
      Bindings
      • 0. daniel
      Hints
      • Use SELECT * only if you need all columns from table
    • select * from `areas` where (select count(*) from `events` inner join `prefectures` on `prefectures`.`id` = `events`.`site_prefecture_id` where `areas`.`id` = `prefectures`.`area_id` and `status_id` = '6' and `list_ended_at` > '2025-07-30 19:40:08' and `keyword` LIKE '%寝具%' and (select count(*) from `categories` inner join `events_categories` on `categories`.`id` = `events_categories`.`category_id` where `events`.`id` = `events_categories`.`event_id` and `id` in ('28')) = 1 and (select count(*) from `makers` inner join `events_makers` on `makers`.`id` = `events_makers`.`maker_id` where `events`.`id` = `events_makers`.`event_id` and `makers`.`id` in ('91')) = 1 and `revision` = '0') > 01.66msheyagoto_core
      Metadata
      Bindings
      • 0. 6
      • 1. 2025-07-30 19:40:08
      • 2. %寝具%
      • 3. 28
      • 4. 91
      • 5. 0
      Hints
      • Use SELECT * only if you need all columns from table
    • select * from `areas` where `areas`.`id` is null limit 1310μsheyagoto_core
      Metadata
      Hints
      • Use SELECT * only if you need all columns from table
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    • select * from `prefectures` where (select count(*) from `events` where `prefectures`.`id` = `events`.`site_prefecture_id` and `status_id` = '6' and `list_ended_at` > '2025-07-30 19:40:08' and `keyword` LIKE '%寝具%' and (select count(*) from `categories` inner join `events_categories` on `categories`.`id` = `events_categories`.`category_id` where `events`.`id` = `events_categories`.`event_id` and `id` in ('28')) = 1 and (select count(*) from `makers` inner join `events_makers` on `makers`.`id` = `events_makers`.`maker_id` where `events`.`id` = `events_makers`.`event_id` and `makers`.`id` in ('91')) = 1 and `revision` = '0') > 010.33msheyagoto_core
      Metadata
      Bindings
      • 0. 6
      • 1. 2025-07-30 19:40:08
      • 2. %寝具%
      • 3. 28
      • 4. 91
      • 5. 0
      Hints
      • Use SELECT * only if you need all columns from table
    • select * from `makers` where `status_id` = '1' and `public` = '1' and exists (select * from `events` inner join `events_makers` on `events`.`id` = `events_makers`.`event_id` where `makers`.`id` = `events_makers`.`maker_id` and `status_id` = '6' and `list_ended_at` > '2025-07-30 19:40:08' and `keyword` LIKE '%寝具%' and (select count(*) from `categories` inner join `events_categories` on `categories`.`id` = `events_categories`.`category_id` where `events`.`id` = `events_categories`.`event_id` and `id` in ('28')) = 1 and (select count(*) from `makers` inner join `events_makers` on `makers`.`id` = `events_makers`.`maker_id` where `events`.`id` = `events_makers`.`event_id` and `makers`.`id` in ('91')) = 1 and `revision` = '0')3.93msheyagoto_core
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. 6
      • 3. 2025-07-30 19:40:08
      • 4. %寝具%
      • 5. 28
      • 6. 91
      • 7. 0
      Hints
      • Use SELECT * only if you need all columns from table
    • select * from `categories` where `status_id` = '1' and `opened` = '1' and exists (select * from `events` inner join `events_categories` on `events`.`id` = `events_categories`.`event_id` where `categories`.`id` = `events_categories`.`category_id` and `revision` = '0')1.19msheyagoto_core
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. 0
      Hints
      • Use SELECT * only if you need all columns from table
    • select * from `banner_slots` where `symbol` = 'seiloo.sidebar.ad' limit 1480μsheyagoto_core
      Metadata
      Bindings
      • 0. seiloo.sidebar.ad
      Hints
      • Use SELECT * only if you need all columns from table
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    • select * from `banners` where `status_id` = '2' and `started_at` < '2025-07-30 19:40:08' and `ended_at` > '2025-07-30 19:40:08' and `slot_id` = '25' order by RAND() limit 1600μsheyagoto_core
      Metadata
      Bindings
      • 0. 2
      • 1. 2025-07-30 19:40:08
      • 2. 2025-07-30 19:40:08
      • 3. 25
      Hints
      • Use SELECT * only if you need all columns from table
      • ORDER BY RAND() is slow, try to avoid if you can. You can read this or this
    • select `id`, `name` from `files` where `files`.`id` in ('141442')340μsheyagoto_core
      Metadata
      Bindings
      • 0. 141442
    • select * from `banner_slots` where `symbol` = 'seiloo.logo' limit 1630μsheyagoto_core
      Metadata
      Bindings
      • 0. seiloo.logo
      Hints
      • Use SELECT * only if you need all columns from table
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    • select * from `banners` where `status_id` = '2' and `started_at` < '2025-07-30 19:40:08' and `ended_at` > '2025-07-30 19:40:08' and `slot_id` = '9' limit 1590μsheyagoto_core
      Metadata
      Bindings
      • 0. 2
      • 1. 2025-07-30 19:40:08
      • 2. 2025-07-30 19:40:08
      • 3. 9
      Hints
      • Use SELECT * only if you need all columns from table
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    • select * from `banner_slots` where `symbol` = 'seiloo.season.icon' limit 1450μsheyagoto_core
      Metadata
      Bindings
      • 0. seiloo.season.icon
      Hints
      • Use SELECT * only if you need all columns from table
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    • select * from `banners` where `status_id` = '2' and `started_at` < '2025-07-30 19:40:08' and `ended_at` > '2025-07-30 19:40:08' and `slot_id` = '26' limit 1450μsheyagoto_core
      Metadata
      Bindings
      • 0. 2
      • 1. 2025-07-30 19:40:08
      • 2. 2025-07-30 19:40:08
      • 3. 26
      Hints
      • Use SELECT * only if you need all columns from table
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      _token
      FWfONEzvjEWTrfBKMD08h0wWUFjBGqZWgmmBpC0H
      _previous
      array:1 [ "url" => "https://sale.dev.heyagoto.com/events?category_slug%5B%5D=frogcategory&maker_sl...
      PHPDEBUGBAR_STACK_DATA
      []
      format
      html
      content_type
      text/html; charset=UTF-8
      status_text
      OK
      status_code
      200
      request_query
      array:3 [ "category_slug" => array:1 [ 0 => "frogcategory" ] "maker_slug" => array:1 [ ...
      request_request
      array:3 [ "category_slug" => array:1 [ 0 => "frogcategory" ] "maker_slug" => array:1 [ ...
      request_headers
      array:21 [ "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 =>...
      request_server
      array:115 [ "USER" => "apache" "HOME" => "/usr/share/httpd" "SCRIPT_NAME" => "/index.php" "R...
      request_cookies
      []
      response_headers
      array:5 [ "cache-control" => array:1 [ 0 => "max-age=0, no-cache, no-store, private" ] "da...
      path_info
      /events
      session_attributes
      array:3 [ "_token" => "FWfONEzvjEWTrfBKMD08h0wWUFjBGqZWgmmBpC0H" "_previous" => array:1 [ "u...