SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005429s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311305 LIMIT 1 [ RunTime:0.003930s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311305 [ RunTime:0.009750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002501,829656,426943,471394,490331,972328,544971,1012601,505791,470543,963272,598481,112976,1043091,773827,519200,238367,663252,1009686,452978,45175,627848,166530,243416,672080,120987,822231,367250,621455,128422,838191,548996,21496,565625,971267,219591,809290,975076,685512,926676,415478,892294,200652,306358,800056,991380,955987,110606,19823,779153,325225,141029,638709,219560,978929,512206,165698,201130,236927,352135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311305 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003845s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311305 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003311s ]