SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 82611 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 82611 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (720178,432105,795679,411976,957401,774099,35512,194037,251952,232850,309118,716374,926147,992176,835582,25505,315880,775742,709058,13087,522902,188343,76454,308238,484658,90866,731560,984754,106468,843547,82553,585742,132166,372797,865956,824923,58370,633285,200199,1008998,452556,851120,332668,714011,724598,449137,412651,249911,511789,19716,264893,588405,834312,33455,723366,255534,901456,993480,842372,349028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 82611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000686s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 82611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]