SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681235 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681235 [ RunTime:0.002169s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511775,470342,980397,933458,220130,555415,173137,842168,621592,550951,450751,76872,241774,561089,714925,446505,38224,895313,356253,21929,840589,86808,379093,656300,85197,124500,884949,18684,395881,383673,572591,341973,970020,506441,139778,179515,910988,217427,8663,93029,496006,58845,247301,572683,622814,835774,792549,268194,309080,211010,232013,163491,44984,711256,715056,685651,816440,692849,595964,506212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681235 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681235 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]