SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047253 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047253 [ RunTime:0.002086s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (706213,318325,474549,472114,691768,285538,68875,406880,969035,686102,533395,482577,916072,1021446,133069,197103,715522,865531,614668,615826,1010850,1025491,288867,753202,623867,893066,16348,125369,11892,598879,482191,999949,462239,455926,301035,337433,200832,953861,910473,485227,849135,711062,94434,855690,581388,1042789,974926,895063,162134,599358,103690,642434,216236,381883,371345,171402,932647,110021,668750,493196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]