SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4750 LIMIT 1 [ RunTime:0.000606s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4750 [ RunTime:0.002565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (933020,810525,820597,480426,711158,322283,387982,901917,109571,78035,1031370,344284,651529,952649,1004449,1039869,221263,543269,927696,473071,492626,514369,332971,1013086,211155,1032913,947906,645758,58373,121521,538604,293571,560526,294063,238691,684603,649896,950810,360555,926196,754850,871182,1003474,41163,824531,3590,131925,678799,843436,1001651,193739,464529,797361,460733,478215,717028,753852,93937,769199,571275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4750 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000724s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4750 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003383s ]