SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 197841 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 197841 [ RunTime:0.002895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (134063,602669,837146,770916,242432,857283,587794,740106,652628,691874,1018371,731730,1005190,565566,528133,941795,679715,1031478,543097,476577,645440,219655,499521,578564,1016188,851208,460338,158602,819324,1003668,231739,772312,478899,882019,801663,595756,491592,883804,385954,625126,658239,2730,239546,61532,514076,126746,142899,750101,224452,474817,158319,787211,527501,606931,511122,203513,727923,799498,829248,529343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 197841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 197841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]