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` = 4875 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4875 [ RunTime:0.001967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191284,453594,773302,8116,145842,1044752,436157,795618,108044,176583,1012403,725306,706084,941385,353775,573626,732817,123096,40498,533955,801315,1039754,514273,989380,729589,707856,16148,730210,126650,873243,715202,493555,575994,733724,388442,209576,789778,495752,73994,635808,559611,872548,270667,902536,598580,108178,263043,794086,943569,538890,877200,920406,841877,796933,709940,199077,996550,217308,96666,108107) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]