SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005488s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445975 LIMIT 1 [ RunTime:0.004563s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445975 [ RunTime:0.002707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (861978,480718,837435,615108,907407,71979,257876,55290,398164,519781,439498,557369,694149,527322,70746,557172,1046166,93910,673400,292152,364408,410762,987474,45275,554556,304520,567518,811767,441150,338507,796356,986362,253289,826050,599918,477919,618004,120879,789364,388718,283610,326912,510562,830954,204784,959716,753430,306213,67516,799266,325908,803492,875823,53871,1039817,268329,435178,740719,154297,769701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002782s ]