SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 295421 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 295421 [ RunTime:0.001954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459332,465213,352721,936232,660464,1016250,11951,304825,805119,24265,76827,481001,697904,477704,553054,176589,851673,619031,530748,728413,502681,115389,456460,588877,613040,412238,898419,561291,364589,369141,997509,239940,464403,331667,819204,275699,396985,59993,585478,561389,251148,258525,537679,135813,572035,869841,948000,103748,659322,321478,976304,1040825,384366,57986,762434,93949,376780,67469,871776,364195) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 295421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 295421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.007521s ]