SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267860 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267860 [ RunTime:0.001978s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (240071,827869,358993,632078,433932,311098,966078,263284,580869,765033,812449,781506,963167,305059,312536,442466,436084,1020535,566395,443779,170885,426509,307803,491408,711020,37969,77384,1000411,109788,218749,267182,446519,619361,323409,591580,397543,964106,821491,102344,625493,154873,291247,265972,817275,865122,919629,719942,849298,972150,462782,290064,412892,554826,330581,94994,923036,156518,850335,117725,665750) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001461s ]