SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565908 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565908 [ RunTime:0.001749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (896788,483172,165298,7812,194963,537639,573891,706991,99061,88008,132087,246629,770866,571992,558731,772403,64573,1006071,64184,140866,642491,140467,818885,675515,159295,718016,452323,550449,278768,375061,343692,468879,797459,952379,644365,44560,705397,219776,29037,528112,918546,35281,591066,894430,716149,878958,411466,753750,148363,505963,960340,349536,1032378,653865,840890,425016,634165,840313,791070,87518) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]