SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502504 LIMIT 1 [ RunTime:0.001550s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502504 [ RunTime:0.004162s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813601,467835,10127,35451,130347,635043,895378,1030350,106869,967529,545891,841899,215249,459723,957298,373092,422068,772043,444185,188826,432155,501910,666480,772607,396758,169806,174295,527342,174265,895827,306545,230344,770259,98002,21507,433465,544224,70365,445794,581942,240974,338168,916280,945150,566215,494433,81391,217701,542134,806783,101172,338475,213158,100924,343568,37469,220788,613725,702798,541219) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]