SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 211288 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 211288 [ RunTime:0.001968s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698288,873977,988420,442599,495392,524855,264436,883490,436640,196769,1026089,835031,885457,803618,413084,209702,94425,668300,216912,228419,198135,801071,562439,1025103,625381,925100,1045414,505981,1045778,489802,492260,30971,246790,20354,298616,918563,757547,125576,612878,908033,374955,620559,424618,1012672,719047,265391,719977,578397,387497,986335,815710,975362,288808,1007477,781884,789542,871200,766961,307976,541843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 211288 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 211288 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]