SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 983774 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 983774 [ RunTime:0.002409s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (215096,295725,74552,386910,660908,752459,995133,242690,915557,45845,894425,702544,183392,663518,989179,111854,789448,403355,589888,69651,875309,577927,639802,578585,175750,886984,77788,740694,389529,528786,889080,573912,1000112,524251,635105,568612,461232,995239,578034,825653,752023,778704,1014237,766471,711580,654600,997739,339020,388697,991776,847874,237585,222916,887590,130032,816792,544899,981307,827953,449426) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004827s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 983774 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 983774 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001609s ]