SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 357470 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 357470 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408638,791452,305787,203745,633648,449575,163778,582680,975073,410102,393887,638091,2647,253429,420924,770356,526588,430985,254087,442467,72404,119295,806465,668787,1013855,923428,833965,16687,678669,251473,379196,117560,801744,392489,1042789,931046,423783,1038254,409733,52634,917783,955376,386917,849384,547755,170201,351314,322914,535239,578071,577999,422786,233585,985534,134710,29069,939936,773857,649689,873281) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 357470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 357470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]