SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 224688 LIMIT 1 [ RunTime:0.000757s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 224688 [ RunTime:0.002964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329855,986019,244335,470245,26168,476949,878164,299605,955923,10103,907833,371542,250533,577764,995603,652525,232808,875332,397931,586788,746037,287270,402207,345201,305670,118199,558098,411827,253195,956917,918022,750952,733057,651009,95796,530001,327420,266127,653095,583394,101308,854048,734468,729749,626968,374425,405713,952971,561084,1015177,692718,693405,747346,1001004,322533,501380,978423,685358,798791,365650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 224688 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 224688 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]