SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554239 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554239 [ RunTime:0.001824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620364,548099,273909,31180,961055,975598,233197,627434,691989,310342,12533,366219,377560,558865,816939,311553,432566,506055,79233,771597,611088,353789,507355,703233,171053,134452,918716,193005,20111,729067,57490,392668,943199,864215,309454,384468,249837,294030,993035,426313,720933,35080,337704,540010,200345,22257,963567,793882,654717,203291,51528,669836,10613,720922,241327,617077,767106,713072,103511,735382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554239 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554239 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]