SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425479 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425479 [ RunTime:0.002068s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513786,655928,355713,72403,372578,667831,847431,994413,6959,807377,175408,463477,326028,662419,722030,469551,871870,81214,652711,424989,171535,258617,613752,324750,1007723,395153,43773,649353,484546,392864,951689,133480,428352,794766,199074,427760,634871,398117,277093,766065,22456,790833,918725,753221,855480,1048741,391565,465342,575690,190246,841171,814533,887637,275923,921910,306954,364412,649319,399408,48271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425479 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425479 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]