SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514275 LIMIT 1 [ RunTime:0.002478s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514275 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324436,388333,80099,883777,458111,608948,76385,911038,73732,174240,137623,501017,1045808,582878,355954,529643,40750,706182,669306,48715,708841,998739,484973,376479,629475,803503,698618,924261,23569,346214,1021890,797954,832182,785040,1015343,856656,520981,432379,629355,236594,552444,1022376,31639,249939,809345,521394,405383,274964,229448,597960,175612,26987,1014888,424810,943939,111897,643471,362287,171343,495249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514275 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514275 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]