SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002423s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416842 LIMIT 1 [ RunTime:0.000805s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416842 [ RunTime:0.002296s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (146753,833003,198694,1038661,265278,627522,595511,896994,535158,426189,540974,814383,308649,144181,10529,894032,158534,159534,73941,756297,238593,310931,250943,585840,79865,422988,333396,800878,921262,210447,275901,904866,746338,246150,665068,331063,903961,205829,765757,614299,74836,776711,570572,365750,280029,621697,653295,1022417,875669,347529,278434,103363,598047,465719,873473,497034,847114,764017,273504,129934) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000713s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]