SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001437s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410814 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410814 [ RunTime:0.002161s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (203354,779646,519197,528913,760064,241529,2993,70721,948952,705024,115827,321214,92887,926528,301096,47703,229743,322681,1000648,1017411,717563,307434,952033,912534,481767,300322,582953,772498,760027,247000,10337,137659,121705,175201,48858,700401,95398,690927,378678,686214,653397,79943,578178,738219,592949,358156,780396,770676,553647,906562,607429,755262,338479,434918,54708,372511,629819,613533,167737,643695) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002667s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]