SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494430 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494430 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (723802,928256,601428,41492,745400,553140,277769,927455,432809,1015981,20517,772996,538262,928320,748138,40585,29721,303979,508876,597702,520507,765191,305790,918664,693924,555197,711885,54436,507166,895755,564933,63656,387615,984475,468571,627391,981071,241823,448584,833991,1031237,640384,94985,880843,135350,108286,156796,484431,84641,135362,136305,162931,260892,228449,697365,1033030,933855,579374,659807,211090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494430 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494430 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]