SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 25148 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 25148 [ RunTime:0.002321s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555992,556529,340231,515704,549404,149664,254711,270524,170936,631817,780398,633104,761547,218510,368284,410413,541868,663524,116531,84449,275581,14107,343800,195337,683384,755654,651119,992336,461421,226135,505493,447342,641326,230815,763602,178161,349457,731238,424341,963516,95099,738881,813584,642737,718677,223897,229409,968375,782591,999341,317208,410505,431567,442368,387221,532142,36147,617580,854846,513316) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 25148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 25148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]