SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 685308 LIMIT 1 [ RunTime:0.002677s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 685308 [ RunTime:0.003602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (996157,427741,456398,835945,535740,704258,485566,551979,1026751,14509,16101,808746,117632,930380,718016,136400,953813,880387,929522,455165,24396,121913,646289,986151,361665,532383,809485,895206,30644,589249,911423,913866,383036,64255,47250,585800,121875,343723,128545,990561,943466,55307,392341,791369,530008,21808,798411,367785,134071,367580,397912,352368,746828,472309,121253,275704,800291,557269,907622,669212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 685308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 685308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]