SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480493 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480493 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (991568,758140,158100,658436,340800,1008069,76971,661350,132645,330107,363568,342051,738336,123413,306683,482291,68710,484803,518191,312262,527875,454981,155300,455738,149746,218544,272776,313375,951735,849107,885199,911598,395332,388346,622330,672438,917841,673405,884486,788969,221701,883351,254405,768539,438892,838156,117671,465391,102001,800880,991152,544056,345339,897334,781736,855913,585475,176017,305686,772579) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480493 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480493 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]