SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 985313 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 985313 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (69210,134599,162970,994710,393033,661276,509366,72048,878567,584976,340902,141972,620471,134409,901403,728198,864699,962774,85719,536978,70276,101443,671022,53789,1008628,516392,212102,285055,413815,231860,782046,984018,180723,864236,798023,153530,434282,129914,515918,1004660,395312,46515,285555,192630,366879,942266,847486,261261,640748,897354,461941,1039322,969702,789183,916358,218157,1046013,956892,757318,981897) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 985313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 985313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]