SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023583 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023583 [ RunTime:0.001829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (236898,138519,775129,315224,377926,65439,209637,100308,522111,29849,71619,434241,166848,973715,465023,710908,64585,710266,443398,969842,264602,687568,628395,446093,100151,445283,911040,25708,250238,924771,568133,780800,239925,903153,969789,153536,628453,1005644,28839,180501,474422,1040363,287417,651337,478911,630575,429208,555418,394810,424243,10056,435795,776962,821543,870974,571293,792011,852628,162896,567696) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]