SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012503 LIMIT 1 [ RunTime:0.000642s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012503 [ RunTime:0.002271s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (973497,863589,87698,1025411,257897,913017,816237,62027,172219,390469,893166,1021231,447768,1030372,675504,323825,793235,354579,710537,424110,124650,30232,353853,324831,415190,145606,934483,945491,119262,161958,546426,435714,200278,1014431,660305,253686,499946,66798,23698,781420,654214,791453,1029390,207681,396549,14664,197496,277263,805213,736412,437960,767349,807366,550878,618938,976539,570436,972064,980341,910726) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]