SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002085s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546315 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546315 [ RunTime:0.006228s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (491866,98125,815377,142214,406736,841401,415373,125790,27101,235197,93896,1015150,559040,246864,707814,818772,383835,554146,913001,2508,196932,168764,393922,734691,160794,3220,477571,630714,965174,471946,432453,294547,826490,257333,817612,946189,627839,631878,995630,918846,209305,72085,860177,818095,560440,419584,15255,242993,380890,587171,503260,508863,71142,926438,289254,305951,678793,1017372,780197,667738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000889s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]