SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433421 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433421 [ RunTime:0.001913s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (877160,555336,198759,223924,837416,431213,31098,396295,80491,164425,321334,1003945,470782,153012,335031,714012,869548,999879,1017730,432526,878571,584560,805028,645739,966506,339108,334577,35439,474726,33278,640462,383003,823609,476147,720594,457827,525570,880573,50243,705075,301377,725728,518905,480787,647322,537957,21992,1017679,431618,701708,588174,637800,289125,583041,789900,661613,631729,431872,489592,172464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]