SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476732 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476732 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111969,209461,745418,72897,612303,822442,330175,1045872,452075,861600,868824,958138,988326,625070,469128,956138,335028,494396,785033,912620,1034794,592237,987952,885166,192737,143411,443433,564508,485106,402052,1034486,163821,698,300694,951249,410427,427840,411924,265108,788752,905665,1802,185879,570356,968830,527114,373627,774325,29828,548760,645164,263716,341002,555696,849312,871440,456437,331008,267857,131724) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476732 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476732 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]