SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013814 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013814 [ RunTime:0.002503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820973,533069,805713,725147,809857,981379,157087,596477,378389,858963,484593,25431,277774,417351,34750,160166,428488,432691,958202,233638,974728,673407,524311,178618,512345,690414,434558,223838,254994,556678,916166,513827,77409,135461,412907,84693,463143,423225,117279,8648,753630,728254,543882,843385,354952,229456,130000,597098,517544,882176,289284,648741,439565,292415,470417,683035,57898,171680,714897,1037083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]