SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317708 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317708 [ RunTime:0.003653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285533,610778,360185,571446,639302,225232,803089,716572,918710,934221,349031,742184,818460,309753,998684,412032,417335,87356,672988,107671,967016,102564,384170,518496,71695,591737,522225,161753,54432,323578,1043354,580417,86178,999527,849849,254950,669503,722036,261877,658585,841890,151896,510712,265342,780400,624513,274012,942295,581516,469225,652049,415436,182715,741357,509975,753296,352744,484949,815007,1029639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002993s ]