SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509252 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509252 [ RunTime:0.003149s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568215,763145,888836,216418,1041122,869889,187417,970835,1013110,96224,1029601,943700,317846,937647,247215,363352,583677,96761,972652,152377,150587,726412,501166,931139,742908,745538,264504,799110,802769,331294,924562,108587,1046038,268999,442590,605866,476087,343206,753796,128493,864926,340220,362536,301471,748404,993567,291790,992396,971255,160202,118967,94553,855980,216101,231236,172681,582712,486493,529794,962717) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509252 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509252 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000368s ]