SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003744s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31380 LIMIT 1 [ RunTime:0.000694s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31380 [ RunTime:0.002538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (133214,104489,985788,994844,677686,520861,617541,756949,231960,485159,675914,129377,990594,270028,243206,441866,245751,24014,368526,1022560,745865,95321,71924,299532,316656,413004,563040,591434,451588,765054,586990,630159,214355,277718,312341,562149,551015,824732,421084,519497,987349,168318,766065,135860,981050,712916,496101,874738,743337,321948,650507,912870,266431,657798,62347,648280,1025198,1019955,211010,774984) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000394s ]