SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281011 LIMIT 1 [ RunTime:0.000284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281011 [ RunTime:0.003037s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (712199,175764,997049,479372,281134,984268,616811,111333,951879,347022,168669,151035,258252,99822,795978,830699,597881,313278,326759,630751,1043508,586760,760251,1022626,492633,876284,972072,442965,25788,300418,279559,806309,141712,919114,1014025,388389,993334,362202,324168,757829,118361,139547,532220,1009958,174183,342295,224991,887986,621824,273070,176132,488660,764626,47627,896279,856115,59122,336858,906515,169346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000403s ]