SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528950 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528950 [ RunTime:0.001919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (879669,311269,866617,180491,346836,566213,427696,276624,467254,573842,249874,721864,508416,919269,925915,228986,894808,247311,267204,157896,278174,169977,825182,414435,313596,922828,812381,467883,356645,219267,740992,372346,7511,134356,845690,1039343,728898,84490,954764,400199,625364,953997,167377,543448,844139,11585,800122,471165,867166,912516,50367,1011315,609495,316180,832103,416085,1043922,924839,1046301,409948) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528950 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528950 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]