SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 972005 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 972005 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447848,977197,736785,284691,628886,788574,737443,47357,765267,460892,149920,598113,265114,578682,756398,69562,884543,267406,605674,577667,808252,42166,23009,813027,857316,661534,449592,135508,130515,212857,962054,89802,650521,914666,104983,712216,3566,1140,407381,878454,415861,931705,764274,316109,391403,514208,612734,544183,567083,308485,819526,511012,586218,647529,868644,328703,909901,292797,715465,1020666) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 972005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 972005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]