SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040515 LIMIT 1 [ RunTime:0.000510s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040515 [ RunTime:0.001828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033936,412937,847217,624226,557969,60690,712750,409228,961903,22517,530331,546386,518055,903421,997381,162631,923298,313472,736006,555968,337924,447153,546262,617736,866391,680124,762965,342349,1004337,544282,387045,433009,640309,957846,734694,520837,132500,96208,385019,388366,979755,21709,924879,732787,750563,138992,575247,246876,181348,191386,25617,513926,404907,635301,334383,758303,255387,679254,940453,608281) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]