SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531425 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531425 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (364604,870770,64276,854316,145178,627423,683627,1000251,854816,1024041,144734,936315,1014417,930722,342550,735056,247588,1021092,800402,440880,145862,231254,296763,1014725,483328,740387,787217,583519,493055,43556,40150,533590,978186,986652,49458,99977,845181,850917,893361,836984,661282,952085,951227,213553,646881,82831,254988,200861,369265,233605,961985,809726,521914,1024848,1024403,89123,567295,216380,220253,1017053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531425 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531425 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]