SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 610503 LIMIT 1 [ RunTime:0.000927s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 610503 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (662003,490876,426793,674230,177102,826369,123979,698212,394484,795418,736749,866336,959764,1011870,777513,586009,650781,287977,961576,852882,825863,892619,998151,442271,642897,540418,651291,454436,665027,985350,563186,926746,757569,907560,676825,224166,945080,328213,769229,374091,968912,836476,614104,526733,840179,279085,957503,330389,707073,130378,572500,718787,269799,55054,121035,174699,311376,622352,482491,1019214) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 610503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 610503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]