SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002717s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671497 LIMIT 1 [ RunTime:0.001343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671497 [ RunTime:0.002813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583765,691162,177013,26832,129354,553549,407320,733978,52807,493328,1002609,529370,356991,255269,277329,565610,458193,15082,36978,583037,298916,379728,203325,540888,388480,858551,44634,218170,526162,582298,818582,847854,888683,366566,110696,786398,263918,623704,796518,467296,279503,353138,852990,414733,385398,736379,142817,232345,831509,756150,278510,504199,524983,875271,949137,125149,574620,557465,437010,702807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671497 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671497 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]