SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001905s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501409 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501409 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (826552,589290,342231,104681,953642,317978,757926,884279,587775,772070,1027960,891251,1008924,156765,373534,610282,500275,234843,22066,1029865,1001884,123509,710398,563460,172531,9672,580088,148395,1037433,202473,131301,209782,975951,299901,575866,392254,569816,272295,249716,278706,212495,691021,805306,137795,303510,365600,87235,630289,591264,556489,513525,423760,263419,183247,985597,851780,1023246,938638,74212,899230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]