SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 637876 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 637876 [ RunTime:0.001941s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401983,913096,425241,942916,1031273,286560,750085,381958,288136,364079,739217,28850,463950,685859,174467,602809,737572,893535,367507,192060,423361,804072,848362,16295,505116,883663,675019,118696,164451,24803,876631,576374,331660,693840,603657,788045,326455,129086,36474,530518,899690,761115,660244,874122,877752,573028,764118,708663,1040909,463323,253183,172059,784126,32004,765043,782689,486810,674136,432911,395031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 637876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 637876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]