SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488280 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488280 [ RunTime:0.001691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (335524,102532,818063,857840,255727,984982,963613,907600,562202,823770,1014323,986798,909073,280265,697125,504136,145775,782592,885030,441695,657425,841594,979010,93759,3665,258683,995333,332191,78701,371630,435432,432991,813967,741230,953150,591525,275057,248711,625085,602715,499905,53856,406796,74639,779162,945990,140394,942891,985910,572039,790249,71615,439110,536754,268767,36098,510464,938423,234017,59505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001742s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]