SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281070 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281070 [ RunTime:0.001927s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108958,857205,868714,555578,632116,877665,193701,470335,809086,71797,228320,875283,272451,16799,850999,828475,698545,407497,403498,168859,317918,692249,884318,666386,263769,676799,383503,890210,283711,303169,467393,391793,1045571,131948,60054,20531,772252,202250,542560,1045500,1006261,989631,884648,665282,259755,737816,491258,782623,1045631,649787,530671,759463,794651,970553,440860,201289,1040081,344071,366803,220188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281070 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281070 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]