spree.shiftvision.com
Open in
urlscan Pro
69.38.134.106
Public Scan
URL:
https://spree.shiftvision.com/
Submission: On April 17 via api from US — Scanned from DE
Submission: On April 17 via api from US — Scanned from DE
Form analysis 1 forms found in the DOM
GET /products
<form class="navbar-form" action="/products" accept-charset="UTF-8" method="get"><input name="utf8" type="hidden" value="✓">
<div class="form-group">
<select name="taxon" id="taxon" aria-label="Taxon" class="form-control">
<option value="">All departments</option>
<option value="1">Categories</option>
<option value="2">Brands</option>
</select>
</div>
<div class="form-group">
<input type="search" name="keywords" id="keywords" placeholder="Search" class="form-control">
</div>
<input type="submit" value="Search" class="btn btn-success" data-disable-with="Search">
</form>Text Content
* Login
* All departments Categories Brands
* Home
* Cart: (Empty)
SHOP BY CATEGORIES
Bags Mugs Clothing
SHOP BY BRANDS
Ruby Apache Spree Rails
Ruby on Rails Tote
$15.99
Ruby on Rails Bag
$22.99
Ruby on Rails Baseball Jersey
$19.99
Ruby on Rails Jr. Spaghetti
$19.99
Ruby on Rails Ringer T-Shirt
$19.99
Ruby Baseball Jersey
$19.99
Spree Baseball Jersey
$19.99
Spree Jr. Spaghetti
$19.99
Spree Ringer T-Shirt
$19.99
Spree Tote
$15.99
Spree Bag
$23.99
Ruby on Rails Mug
$13.99
* 1
* 2
* Next ›
* Last »
1149.2 ms
/ (1149.2 ms) spree.shiftvision.com on Wed, 17 Apr 2024 09:28:29 GMT
duration (ms) with children (ms) from start (ms) query time (ms) GET
http://spree.shiftvision.com:443/ 51.9 1149.2 +0.0 Executing action: index
65.8 1097.3 +49.0 6 sql 6.7 Rendering: spree/home/index 59.8 755.8 +114.0 7
sql 7.5 Rendering: spree/shared/_taxonomies 25.1 25.1 +126.0 4 sql 2.7
Rendering: spree/shared/_products 68.9 670.8 +199.0 8 sql 6.1 Rendering:
spree/products/_product 17.1 17.1 +261.0 Rendering: spree/products/_product
123.0 123.0 +279.0 Rendering: spree/products/_product 46.6 46.6 +402.0
Rendering: spree/products/_product 35.4 35.4 +448.0 Rendering:
spree/products/_product 36.6 36.6 +484.0 Rendering: spree/products/_product
34.8 34.8 +520.0 Rendering: spree/products/_product 27.6 27.6 +555.0
Rendering: spree/products/_product 29.2 29.2 +583.0 Rendering:
spree/products/_product 33.8 33.8 +612.0 Rendering: spree/products/_product
56.4 56.4 +646.0 Rendering: spree/products/_product 67.6 67.6 +703.0
Rendering: spree/products/_product 40.2 40.2 +770.0 1 sql 0.7 Rendering:
kaminari/twitter-bootstrap-3/_pagi... 23.5 53.6 +816.0 Rendering:
kaminari/twitter-bootstrap-3/_page 1.5 1.5 +825.0 Rendering:
kaminari/twitter-bootstrap-3/_page 25.3 25.3 +832.0 Rendering:
kaminari/twitter-bootstrap-3/_next... 1.8 1.8 +862.0 Rendering:
kaminari/twitter-bootstrap-3/_last... 1.4 1.4 +869.0 Rendering:
spree/layouts/spree_application 15.5 275.7 +870.0 Rendering:
spree/shared/_head 207.7 214.7 +877.0 Rendering: spree/shared/_paths 5.3
5.3 +930.0 1 sql 0.7 Rendering: spree/shared/_translations 1.7 1.7 +1089.0
Rendering: spree/shared/_header 26.3 44.5 +1096.0 1 sql 0.4 Rendering:
spree/shared/_nav_bar 5.5 13.4 +1117.0 Rendering: spree/shared/_search 7.8
7.8 +1123.0 1 sql 1.3 Rendering: spree/shared/_main_nav_bar 4.8 4.8 +1135.0
Rendering: spree/shared/_sidebar 1.1 1.1 +1145.0 show time with children 2.3
% in sql
client event duration (ms) from start (ms) Navigation 0.0 +0.0 Fetch 0.0 +0.0
Domain Lookup 0.0 +7.0 Connect 269.0 +7.0 Secure Connection 0.0 +126.0 Request
0.0 +278.0 Response 114.0 +1550.0 domLoading +1557.0 Dom Content Loaded Event
3.0 +2725.0 domInteractive +2725.0 First Paint Time 0.0 +2738.0 Load Event 1.0
+3054.0 domComplete +3054.0 share more show trivial
step
time from start
query type
duration call stack
query 67.00 ms
GET http://spree.shiftvision.com:443/ — 49.00 ms
Executing action: index
T+67.0 ms
Reader
3.0 ms
SELECT 1 AS one FROM "spree_orders" WHERE "spree_orders"."guest_token" = ? LIMIT ?;
5.20 ms
Executing action: index — 5.20 ms
Executing action: index
T+75.2 ms
Reader
0.8 ms
SELECT "spree_preferences".* FROM "spree_preferences" WHERE "spree_preferences"."key" = ? LIMIT ?;
4.10 ms
Executing action: index — 4.10 ms
Executing action: index
T+80.1 ms
Reader
0.9 ms
SELECT "spree_preferences".* FROM "spree_preferences" WHERE "spree_preferences"."key" = ? LIMIT ?;
4.40 ms
Executing action: index — 4.40 ms
Executing action: index
T+85.4 ms
Reader
0.6 ms
SELECT "spree_preferences".* FROM "spree_preferences" WHERE "spree_preferences"."key" = ? LIMIT ?;
5.30 ms
Executing action: index — 5.30 ms
Executing action: index
T+91.3 ms
Reader
0.7 ms
SELECT "spree_preferences".* FROM "spree_preferences" WHERE "spree_preferences"."key" = ? LIMIT ?;
16.30 ms
Executing action: index — 16.30 ms
Executing action: index
T+108.3 ms
Reader
0.7 ms
SELECT "spree_preferences".* FROM "spree_preferences" WHERE "spree_preferences"."key" = ? LIMIT ?;
20.50 ms
Rendering: spree/home/index — 12.00 ms
Rendering: spree/shared/_taxonomies
T+129.5 ms
Reader
0.5 ms
SELECT "spree_preferences".* FROM "spree_preferences" WHERE "spree_preferences"."key" = ? LIMIT ?;
2.40 ms
Rendering: spree/shared/_taxonomies — 2.40 ms
Rendering: spree/shared/_taxonomies
T+132.4 ms
Reader
0.6 ms
SELECT "spree_taxonomies".* FROM "spree_taxonomies" ORDER BY spree_taxonomies.position, spree_taxonomies.created_at;
4.20 ms
Rendering: spree/shared/_taxonomies — 4.20 ms
Rendering: spree/shared/_taxonomies
T+137.2 ms
Reader
0.8 ms
SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" IS NULL AND "spree_taxons"."taxonomy_id" IN (1, 2);
3.20 ms
Rendering: spree/shared/_taxonomies — 3.20 ms
Rendering: spree/shared/_taxonomies
T+141.2 ms
Reader
0.8 ms
SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" IN (1, 2) ORDER BY "spree_taxons"."lft" ASC;
16.70 ms
Rendering: spree/shared/_taxonomies — 9.10 ms
Rendering: spree/home/index
T+158.7 ms
Reader
1.3 ms
SELECT COUNT(*) FROM (SELECT 1 AS one FROM "spree_products" INNER JOIN "spree_variants" ON "spree_variants"."product_id" = "spree_products"."id" AND "spree_variants"."deleted_at" IS NULL AND "spree_variants"."is_master" = ? INNER JOIN "spree_prices" ON "spree_prices"."variant_id" = "spree_variants"."id" AND "spree_prices"."deleted_at" IS NULL WHERE "spree_products"."deleted_at" IS NULL AND ("spree_products".discontinue_on IS NULL or "spree_products".discontinue_on >= '2024-04-17 09:28:29.126764') AND ("spree_products".available_on <= '2024-04-17 09:28:29.126701') AND (spree_prices.amount IS NOT NULL) AND "spree_prices"."currency" = ? LIMIT ? OFFSET ?) subquery_for_count;
7.40 ms
Rendering: spree/home/index — 7.40 ms
Rendering: spree/home/index
T+167.4 ms
Reader
1.6 ms
SELECT DISTINCT "spree_products"."id" FROM "spree_products" INNER JOIN "spree_variants" ON "spree_variants"."product_id" = "spree_products"."id" AND "spree_variants"."deleted_at" IS NULL AND "spree_variants"."is_master" = ? INNER JOIN "spree_prices" ON "spree_prices"."variant_id" = "spree_variants"."id" AND "spree_prices"."deleted_at" IS NULL LEFT OUTER JOIN "spree_product_promotion_rules" ON "spree_product_promotion_rules"."product_id" = "spree_products"."id" LEFT OUTER JOIN "spree_promotion_rules" ON "spree_promotion_rules"."id" = "spree_product_promotion_rules"."promotion_rule_id" LEFT OUTER JOIN "spree_promotions" ON "spree_promotions"."id" = "spree_promotion_rules"."promotion_id" AND "spree_promotions"."advertise" = ? AND (spree_promotions.starts_at IS NULL OR spree_promotions.starts_at < '2024-04-17 09:28:29.202833') AND (spree_promotions.expires_at IS NULL OR spree_promotions.expires_at > '2024-04-17 09:28:29.203147') WHERE "spree_products"."deleted_at" IS NULL AND ("spree_products".discontinue_on IS NULL or "spree_products".discontinue_on >= '2024-04-17 09:28:29.126764') AND ("spree_products".available_on <= '2024-04-17 09:28:29.126701') AND (spree_prices.amount IS NOT NULL) AND "spree_prices"."currency" = ? LIMIT ? OFFSET ?;
10.90 ms
Rendering: spree/home/index — 10.90 ms
Rendering: spree/home/index
T+179.9 ms
Reader
1.1 ms
SELECT MAX("spree_products"."updated_at") FROM "spree_products" INNER JOIN "spree_variants" ON "spree_variants"."product_id" = "spree_products"."id" AND "spree_variants"."deleted_at" IS NULL AND "spree_variants"."is_master" = ? INNER JOIN "spree_prices" ON "spree_prices"."variant_id" = "spree_variants"."id" AND "spree_prices"."deleted_at" IS NULL LEFT OUTER JOIN "spree_product_promotion_rules" ON "spree_product_promotion_rules"."product_id" = "spree_products"."id" LEFT OUTER JOIN "spree_promotion_rules" ON "spree_promotion_rules"."id" = "spree_product_promotion_rules"."promotion_rule_id" LEFT OUTER JOIN "spree_promotions" ON "spree_promotions"."id" = "spree_promotion_rules"."promotion_id" AND "spree_promotions"."advertise" = ? AND (spree_promotions.starts_at IS NULL OR spree_promotions.starts_at < '2024-04-17 09:28:29.211266') AND (spree_promotions.expires_at IS NULL OR spree_promotions.expires_at > '2024-04-17 09:28:29.211473') WHERE "spree_products"."deleted_at" IS NULL AND ("spree_products".discontinue_on IS NULL or "spree_products".discontinue_on >= '2024-04-17 09:28:29.126764') AND ("spree_products".available_on <= '2024-04-17 09:28:29.126701') AND (spree_prices.amount IS NOT NULL) AND "spree_prices"."currency" = ? AND "spree_products"."id" IN (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13);
4.20 ms
Rendering: spree/home/index — 4.20 ms
Rendering: spree/home/index
T+185.2 ms
Reader
0.8 ms
SELECT "spree_stores".* FROM "spree_stores" WHERE (url like '%spree.shiftvision.com%') ORDER BY "spree_stores"."id" ASC LIMIT ?;
1.10 ms
Rendering: spree/home/index — 1.10 ms
Rendering: spree/home/index
T+187.1 ms
Reader
0.9 ms
SELECT "spree_stores".* FROM "spree_stores" WHERE "spree_stores"."default" = ? ORDER BY "spree_stores"."id" ASC LIMIT ?;
2.60 ms
Rendering: spree/home/index — 2.60 ms
Rendering: spree/home/index
T+190.6 ms
Reader
1.4 ms
SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."completed_at" IS NULL AND "spree_orders"."currency" = ? AND "spree_orders"."guest_token" = ? AND "spree_orders"."store_id" = ? LIMIT ?;
2.60 ms
Rendering: spree/home/index — 2.60 ms
Rendering: spree/home/index
T+194.6 ms
Reader
0.4 ms
SELECT "spree_zones".* FROM "spree_zones" WHERE "spree_zones"."default_tax" = ? LIMIT ?;
13.30 ms
Rendering: spree/shared/_products — 9.30 ms
Rendering: spree/shared/_products
T+208.3 ms
Reader
0.7 ms
SELECT COUNT(*) FROM "spree_products" INNER JOIN "spree_variants" ON "spree_variants"."product_id" = "spree_products"."id" AND "spree_variants"."deleted_at" IS NULL AND "spree_variants"."is_master" = ? INNER JOIN "spree_prices" ON "spree_prices"."variant_id" = "spree_variants"."id" AND "spree_prices"."deleted_at" IS NULL WHERE "spree_products"."deleted_at" IS NULL AND ("spree_products".discontinue_on IS NULL or "spree_products".discontinue_on >= '2024-04-17 09:28:29.126764') AND ("spree_products".available_on <= '2024-04-17 09:28:29.126701') AND (spree_prices.amount IS NOT NULL) AND "spree_prices"."currency" = ?;
5.40 ms
Rendering: spree/shared/_products — 5.40 ms
Rendering: spree/shared/_products
T+214.4 ms
Reader
0.6 ms
SELECT 1 AS one FROM "spree_products" INNER JOIN "spree_variants" ON "spree_variants"."product_id" = "spree_products"."id" AND "spree_variants"."deleted_at" IS NULL AND "spree_variants"."is_master" = ? INNER JOIN "spree_prices" ON "spree_prices"."variant_id" = "spree_variants"."id" AND "spree_prices"."deleted_at" IS NULL WHERE "spree_products"."deleted_at" IS NULL AND ("spree_products".discontinue_on IS NULL or "spree_products".discontinue_on >= '2024-04-17 09:28:29.126764') AND ("spree_products".available_on <= '2024-04-17 09:28:29.126701') AND (spree_prices.amount IS NOT NULL) AND "spree_prices"."currency" = ? LIMIT ? OFFSET ?;
3.90 ms
Rendering: spree/shared/_products — 3.90 ms
Rendering: spree/shared/_products
T+218.9 ms
Reader
1.1 ms
SELECT "spree_products".* FROM "spree_products" INNER JOIN "spree_variants" ON "spree_variants"."product_id" = "spree_products"."id" AND "spree_variants"."deleted_at" IS NULL AND "spree_variants"."is_master" = ? INNER JOIN "spree_prices" ON "spree_prices"."variant_id" = "spree_variants"."id" AND "spree_prices"."deleted_at" IS NULL WHERE "spree_products"."deleted_at" IS NULL AND ("spree_products".discontinue_on IS NULL or "spree_products".discontinue_on >= '2024-04-17 09:28:29.126764') AND ("spree_products".available_on <= '2024-04-17 09:28:29.126701') AND (spree_prices.amount IS NOT NULL) AND "spree_prices"."currency" = ? LIMIT ? OFFSET ?;
5.40 ms
Rendering: spree/shared/_products — 5.40 ms
Rendering: spree/shared/_products
T+225.4 ms
Reader
0.6 ms
SELECT "spree_tax_categories".* FROM "spree_tax_categories" WHERE "spree_tax_categories"."deleted_at" IS NULL AND "spree_tax_categories"."id" = 1;
4.00 ms
Rendering: spree/shared/_products — 4.00 ms
Rendering: spree/shared/_products
T+230.0 ms
Reader
1.0 ms
SELECT "spree_variants".* FROM "spree_variants" WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."is_master" = ? AND "spree_variants"."product_id" IN (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13);
5.50 ms
Rendering: spree/shared/_products — 5.50 ms
Rendering: spree/shared/_products
T+236.5 ms
Reader
0.5 ms
SELECT "spree_prices".* FROM "spree_prices" WHERE "spree_prices"."deleted_at" IS NULL AND "spree_prices"."variant_id" IN (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13);
6.90 ms
Rendering: spree/shared/_products — 6.90 ms
Rendering: spree/shared/_products
T+243.9 ms
Reader
1.1 ms
SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."viewable_type" = ? AND "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" IN (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13) ORDER BY "spree_assets"."position" ASC;
9.50 ms
Rendering: spree/shared/_products — 9.50 ms
Rendering: spree/shared/_products
T+254.5 ms
Reader
0.5 ms
SELECT "spree_product_promotion_rules".* FROM "spree_product_promotion_rules" WHERE "spree_product_promotion_rules"."product_id" IN (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13);
554.30 ms
Rendering: spree/products/_product — 530.24 ms
Rendering: spree/products/_product
T+809.3 ms
Reader
0.7 ms
SELECT "spree_tax_categories".* FROM "spree_tax_categories" WHERE "spree_tax_categories"."deleted_at" IS NULL AND "spree_tax_categories"."is_default" = ? LIMIT ?;
124.30 ms
Rendering: spree/shared/_head — 53.00 ms
Rendering: spree/shared/_paths
T+934.3 ms
Reader
0.7 ms
SELECT "spree_preferences".* FROM "spree_preferences" WHERE "spree_preferences"."key" = ? LIMIT ?;
163.60 ms
Rendering: spree/shared/_head — 154.65 ms
Rendering: spree/shared/_header
T+1098.6 ms
Reader
0.4 ms
SELECT "spree_preferences".* FROM "spree_preferences" WHERE "spree_preferences"."key" = ? LIMIT ?;
28.70 ms
Rendering: spree/shared/_header — 18.00 ms
Rendering: spree/shared/_search
T+1127.7 ms
Reader
1.3 ms
SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" IS NULL ORDER BY "spree_taxons"."lft" ASC;
20.22 ms
Rendering: spree/shared/_header — 5.26 ms
show trivial gaps