SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002367s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102081 LIMIT 1 [ RunTime:0.001151s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102081 [ RunTime:0.001921s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12161,697387,108430,625084,823473,810251,314562,573068,287191,832120,258773,363081,999888,598842,368293,54892,268772,869478,980401,758289,966143,144133,71063,190718,846767,925741,447927,981966,906092,36886,955255,608732,339147,91984,132869,205221,931987,789127,986888,832422,523542,247289,855396,707002,6178,183420,184382,449053,325705,340866,15558,673553,150663,919308,521936,40454,795349,479121,142483,1017903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]