SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589984 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589984 [ RunTime:0.002314s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (882646,902155,85245,767340,83242,534079,384942,437028,870094,969454,639357,65002,19108,389575,773056,384593,446556,407421,284170,350419,243381,148849,804938,479494,835761,698615,806050,571961,524016,495131,315563,526542,620764,881168,73275,221562,527452,475345,105616,209358,1040979,676940,701513,211902,600022,121299,722380,639962,249981,820192,947571,1047257,117846,530971,845455,761744,30010,636742,248387,387251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]