SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 97003 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 97003 [ RunTime:0.002990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (925269,543423,649884,16929,49871,532057,483092,381238,1003549,1033921,139244,632376,355040,40409,883078,236188,60939,37006,260538,989395,795047,433813,173145,44846,564898,630360,807680,1044184,7849,1012409,646741,635652,280594,442043,844448,52270,715336,726765,384954,863807,875880,38869,1006456,800992,419515,993153,921562,577324,401425,386125,587838,659618,647859,43409,581168,225244,992637,629874,103486,483969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 97003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 97003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]