Open tetsuzawa opened 10 months ago
サービス一覧
DBはtableが2つ。 初期状態。
SELECT count(*) FROM chair;
29500
SELECT count(*) FROM estate;
29500
データ量一緒っぽい。 index はPKしかない。
SQL一覧
SELECT * FROM chair WHERE id = ?: L324
INSERT INTO chair(id, name, description, thumbnail, price, height, width, depth, color, features, kind, popularity, stock) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?): L384
SELECT * FROM chair WHERE : L505
SELECT COUNT(*) FROM chair WHERE : L506
SELECT * FROM chair WHERE id = ? AND stock > 0 FOR UPDATE: L560
UPDATE chair SET stock = stock - 1 WHERE id = ?: L570
SELECT * FROM chair WHERE stock > 0 ORDER BY price ASC, id ASC LIMIT ?: L591
SELECT * FROM estate WHERE id = ?: L613
INSERT INTO estate(id, name, description, thumbnail, address, latitude, longitude, rent, door_height, door_width, features, popularity) VALUES(?,?,?,?,?,?,?,?,?,?,?,?): L681
SELECT * FROM estate WHERE : L773
SELECT COUNT(*) FROM estate WHERE : L774
SELECT * FROM estate ORDER BY rent ASC, id ASC LIMIT ?: L803
SELECT * FROM chair WHERE id = ?: L825
SELECT * FROM estate WHERE (door_width >= ? AND door_height >= ?) OR (door_width >= ? AND door_height >= ?) OR (door_width >= ? AND door_height >= ?) OR (door_width >= ? AND door_height >= ?) OR (door_width >= ? AND door_height >= ?) OR (door_width >= ? AND door_height >= ?) ORDER BY popularity DESC, id ASC LIMIT ?: L840
SELECT * FROM estate WHERE latitude <= ? AND latitude >= ? AND longitude <= ? AND longitude >= ? ORDER BY popularity DESC, id ASC: L867
SELECT * FROM estate WHERE id = ? AND ST_Contains(ST_PolygonFromText(%s), ST_GeomFromText(%s)): L882
SELECT * FROM estate WHERE id = ?: L928
sudo tailscale up