SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001618s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51130 LIMIT 1 [ RunTime:0.000544s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51130 [ RunTime:0.002237s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698522,162170,69294,45697,693613,502087,794139,1025318,756372,515378,178170,50087,422417,819301,718988,922640,981896,844609,623420,622819,629058,909386,836721,104629,50498,306892,952776,45759,890560,544203,496492,110997,920906,330431,644280,210717,576985,293468,257053,47519,502806,73976,99267,113555,156859,135871,330164,706043,557268,569335,823324,738818,420283,433222,924661,130049,131442,536526,1025772,73220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51130 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000718s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51130 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]