SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341053 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341053 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14631,532412,845250,156207,201361,131653,996470,74911,1014376,648424,652390,467811,679035,674753,485148,477734,634079,222205,522828,777051,146977,847364,423531,276846,220350,923908,683683,577404,406854,387733,491541,1014339,992968,448897,429061,789857,639789,112074,805305,760734,542954,726597,674689,647742,197579,242368,123357,42808,884534,176527,992463,587098,219363,362989,478513,855274,372535,540391,629558,770165) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]