SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 582300 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 582300 [ RunTime:0.001517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283315,249480,690781,42933,527073,610012,67163,823389,912046,807375,381849,419476,718686,558219,941937,804846,697753,757275,49623,101521,525019,257432,463215,640615,253349,494440,1047294,209036,90727,264470,204753,258412,996746,129288,47961,79441,557955,441260,741095,717518,669044,601371,78686,456598,826536,666966,225060,749227,543275,296296,764786,293556,514178,527183,1034009,745694,834156,602460,355964,335998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 582300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 582300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]