SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 840945 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 840945 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292491,708733,854680,363166,1048697,309672,652458,196398,205563,21259,489964,870043,566640,327090,171404,431059,990057,859258,861081,347493,664752,548028,57043,852490,602863,134708,25701,810362,862478,690449,690344,538234,266764,634238,113060,79311,543645,57131,305189,706933,926768,383863,58243,523489,209294,691449,22629,989007,395056,676477,664707,309721,675760,928521,914848,660574,333848,811765,674481,294987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 840945 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 840945 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]