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` = 575093 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575093 [ RunTime:0.001817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (86351,436544,743518,234920,266087,433617,427122,288938,274454,166123,831194,916876,477778,835778,134307,465658,298386,449858,897692,796942,18129,238808,950523,1007245,301115,360276,314346,516803,35667,743705,401876,607846,423295,214003,196535,191839,43804,297705,957256,930658,479524,721587,542159,397849,600703,896684,760931,1042447,729536,329514,783981,935816,152753,844918,562077,58770,864830,218513,423516,538176) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]