SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001784s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313517 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313517 [ RunTime:0.002476s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (581791,169081,617399,127534,533239,590923,616087,122250,338600,993775,387779,331046,1013882,667105,513531,320365,223948,294016,305659,330373,955387,383827,986549,724210,105093,462703,826536,227279,460536,762167,913155,211427,418369,315292,929175,296230,934514,170347,354884,496914,506865,419102,1037410,335152,612718,937589,823352,407598,391261,784423,834127,631531,415308,522811,251548,141800,1014979,39781,729495,309811) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]