SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002007s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48268 LIMIT 1 [ RunTime:0.001253s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48268 [ RunTime:0.002898s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (782423,623269,935334,238350,190120,742626,685506,333320,700173,764687,357494,52562,821813,324366,638426,54343,670996,610789,787990,823190,54681,375058,300650,338998,544271,319406,897463,992765,535065,72363,677615,803468,266076,178579,9008,1006909,950930,3435,970389,834571,155747,269021,332505,995188,676557,4668,915825,561247,933878,787638,865700,603979,586623,132199,957595,34820,320512,953979,680733,455525) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48268 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48268 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]