SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405671 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405671 [ RunTime:0.001394s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409499,843115,757401,225688,793676,604031,722688,105079,268588,83059,807973,629117,306327,300857,357117,360358,139916,448287,476939,654308,441043,45490,561920,1005203,745263,524992,150296,956246,307740,226412,821375,1039449,109490,139463,892838,788347,798185,791473,575204,195954,630092,568589,415474,975226,855686,828760,598557,12478,1001286,788233,419700,255126,15474,750885,319960,201413,746141,560504,903411,666681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000935s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]