SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 576770 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 576770 [ RunTime:0.002838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486097,598316,995324,766428,948674,269252,687442,112947,681419,30967,1046705,822647,206177,225727,167365,261358,885146,590644,880745,163835,10154,508334,374989,1012678,937111,135321,37610,868135,210910,149579,1036943,1033536,273397,707695,773980,171944,787136,455748,140864,941120,613920,53638,567975,424638,372165,627125,596599,306235,1022355,692766,819959,461568,948571,272198,216786,93222,363201,974019,349531,523424) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 576770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 576770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002573s ]