SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437213 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437213 [ RunTime:0.003768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (96080,703680,958755,374888,949108,921913,140401,583401,603171,419945,929193,798465,902783,813453,186404,187939,1032556,703197,819677,639888,876513,936624,993800,683113,643942,621031,867249,520052,435148,151005,320499,685350,507406,704118,27525,664756,685120,731129,190685,617435,877113,857413,162985,449233,967622,156091,791560,852325,244259,335910,761017,22008,315509,638777,57890,201589,3657,635375,938289,663823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]