SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305543 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305543 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378847,174222,877987,987513,1008484,480091,364185,911225,352901,378933,56346,10772,670423,539678,435481,750400,942592,279003,808036,261839,565590,735672,737325,251717,261104,35902,1014349,154560,948964,413398,194523,67659,924141,578061,964509,941616,884070,29507,397478,833806,688140,347056,822187,593168,734127,812034,509171,498374,709161,497940,176749,272869,472703,404981,58575,506164,660063,448476,356895,227838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000923s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]