SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101300 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101300 [ RunTime:0.005281s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287710,899332,61847,867724,303287,131842,306829,198497,569779,191893,275066,207342,264102,78124,7850,76524,464685,632087,629068,501206,743790,572026,813858,267210,395799,505917,607763,692338,999615,404404,816939,299300,170,705544,616751,590994,192491,608166,965383,541649,452705,1023291,1047054,899774,842765,942453,429800,47930,150540,931869,746465,728688,338986,838216,476555,678366,305823,646784,307255,759763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]