SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 352843 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 352843 [ RunTime:0.002260s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (972504,277911,652221,2732,538472,221213,271638,146345,243820,547166,722698,451493,214474,940983,163336,933415,825204,160216,462070,19163,121388,1000618,570648,459100,369673,132768,662013,747086,182493,843437,601985,81314,516057,473270,238269,819352,108873,395596,251231,201250,558041,278509,213866,896023,489772,821992,957889,331320,801119,509665,5327,223941,717631,217523,173103,1010486,991733,941186,122625,8907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 352843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 352843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]