SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50470 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50470 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516251,496065,588800,218297,525193,46838,100287,778509,268812,547706,783826,607016,884179,426417,705227,642995,274320,643886,279399,833907,341712,238206,207689,284957,542844,314502,633421,339772,130664,403288,974194,518496,887276,1006316,186588,447338,1002954,240287,406504,328733,670057,905289,976923,225935,639443,821573,205275,94170,457308,622574,949774,91829,287201,226900,871646,738799,643000,181799,1029486,481917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001809s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]