SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280601 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280601 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246595,1391,809047,455549,462008,184010,369610,458703,819077,767951,598964,863759,5355,509558,968474,119780,260843,446845,837438,414702,426200,890098,793057,177816,85071,179060,364336,516600,144545,217608,975718,918764,135878,932958,696939,815023,889307,665991,531912,714995,247086,289625,176401,286658,370483,792585,188963,69741,833232,138047,157429,702772,692414,462669,243370,788281,399778,144907,245076,1000789) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]