SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 308001 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 308001 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (547723,753494,302888,431254,101241,1022063,655758,208531,1000102,751314,865767,732089,382753,414760,194835,979379,351460,260728,601554,349542,36314,51852,609082,103539,563728,100818,398730,90337,373715,890944,400026,60292,410535,470000,420665,940348,356517,435418,772492,909681,266050,844336,872910,349015,819521,985689,45101,1041850,479039,998359,225504,396711,206750,730811,1012052,364366,868105,472167,475809,814231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 308001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 308001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]