SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 233481 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 233481 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (46728,186699,593803,312012,47175,887043,539823,611832,202068,636160,412944,38678,46158,257005,119562,591929,214799,107350,367417,145010,695322,1025816,852507,610808,889193,446277,520048,954403,10718,176037,815203,616228,495195,825378,267548,133801,158012,714967,623484,397079,455164,349512,882718,732363,695911,445399,877746,557164,24753,126733,548043,224888,456261,852581,602195,282411,658619,698267,422630,643119) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 233481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 233481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]