SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033187 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033187 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (146501,831224,347754,885924,663253,119644,111260,52922,661024,903706,542582,93319,44641,258361,543893,221954,268070,572557,406821,32383,38230,13402,629474,767520,494858,692510,606115,433141,428447,804009,215683,704126,518407,840699,152656,901475,9541,155345,742287,618899,1028888,931399,560901,575072,735932,31705,991600,816505,455536,459541,849722,62608,320790,711272,941888,849962,391943,709109,354921,7050) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001745s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]