SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398991 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398991 [ RunTime:0.001404s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (976981,872534,144511,403142,522928,128167,770305,975258,856367,32141,314901,775541,766408,611377,253115,554374,883790,766684,195319,725154,797640,870153,1031375,913866,69242,694722,551413,388307,446860,407546,23380,752753,286989,603113,697090,817134,293184,13696,7388,991202,752513,924148,962863,550836,64972,795298,239578,2124,531474,471574,246951,1539,755436,747775,92375,355406,541568,562989,998848,294732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]