SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431907 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431907 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502598,821516,717093,262481,650530,479874,345683,54977,496445,990576,746098,280124,637169,489783,129531,390841,176428,380954,682930,669762,844197,312367,524757,28858,520463,586466,862196,1038374,254736,429617,445846,319020,930388,936919,750160,1016600,463803,112657,398062,229071,378416,891234,778523,307703,236919,988457,216628,82360,273524,324288,40649,986582,710827,819221,542573,715942,626446,140289,1025714,342345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]