SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003069s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310994 LIMIT 1 [ RunTime:0.003693s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310994 [ RunTime:0.004722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49046,579898,463647,800330,691873,381592,17765,169126,82036,595425,495231,193387,759532,192717,398608,642533,945239,311912,528479,138100,654298,888546,178339,264308,324037,241646,948451,528120,990500,1003757,207037,874375,678580,745809,94132,98418,900081,238693,150630,589125,312426,867019,723989,746906,811431,757717,1029047,235868,802112,698302,112828,166500,397124,960590,169957,674334,579360,208458,202935,665639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310994 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310994 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]